Welcome to the Lounge

GuyThiebaut8-Feb-14 19:59

GuyThiebaut

8-Feb-14 19:59

CDP1802 wrote:
without leaving the customer alone with anything he would try to 'improve'.

Years ago I worked in a business where the server room was a cupboard - we would leave it open at times when we had to perform maintenance.
One of these 'times' we had a power cut and fortunately the UPS kept the computer(yes we only had one) going while at the same time beeping, telling us that we had limited time to shut down.

One of the accounts ladies was passing by and decided to switch off the UPS - her reason when asked - 'The box was letting out a loud beeping noise as though it was in distress so I turned it off to ease its distress'...

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

CDP18028-Feb-14 20:08

8-Feb-14 20:08

Yes, put the poor thing out of its misery. Smile | :)

And tomorrow I will again work on a project where the customer requested a change that would require to completely replace the primary keys of most tables in order to be able to arrange all major objects (and future expansions) in a tree structure as he sees fit. But please without changing anything in the table definitions, so that the stored procedures he has written to manipulate the database (!!!) still work.

The language is JavaScript. that of Mordor, which I will not utter here

I hold an A-7 computer expert classification, Commodore. I'm well acquainted with Dr. Daystrom's theories and discoveries. The basic design of all our ship's computers are JavaScript.

Colborne_Greg8-Feb-14 21:30

8-Feb-14 21:30

Move away from SQL, just stop using databases.

Move into class libraries with properties that serialize the data.
Much faster
Then you can have the properties bring in data from the old database seamlessly without having to rewrite the primary key system.
You can also inject the value backwards into the database for the clients scripts, and as well get them to upgrade to the new system by using windows 8 xaml apps.

CDP18028-Feb-14 21:42

8-Feb-14 21:42

That's exactly what we are doing, but unfortunately the customer has never heard of something like application logic and insists on messing around in the database with his stored procedures. The old composite primary keys are not adequate to represent the new tree structure, so we have little choice than to make those changes in the database and keep the changes to his SPs as small as possible.

Colborne_Greg8-Feb-14 23:54

8-Feb-14 23:54

ekk

Eddy Vluggen9-Feb-14 0:31

Eddy Vluggen

9-Feb-14 0:31

CDP1802 wrote:
that would require to completely replace the primary keys of most tables

Sorry, I could not resist $Shucks | :-\$

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Mehdi Gholam8-Feb-14 20:19

Mehdi Gholam

8-Feb-14 20:19

Take the fox over to the island to take care of the rabbit problem,

then go back and have a nice fat roast hen for dinner...

Colborne_Greg8-Feb-14 21:37

8-Feb-14 21:37

The seed killed the chicken because it ate to much in the short 40 minutes it takes to go there and back.
Also the seed was for the fields now your whole family will starve.

Mehdi Gholam8-Feb-14 21:46

Mehdi Gholam

8-Feb-14 21:46

Ah, an exercise in requirement gathering and talking to users... [oh! didn't I mention that] Smile | :)

Colborne_Greg8-Feb-14 23:53

8-Feb-14 23:53

If you have to ask the user what they want you're in the wrong business.

You should have been able to gather the parameters of life from the fact he was a farmer and had to live more then one day.

This isn't a program, even if it was, you failed.

You don't need to ask the user that life goes on after one day.

Mehdi Gholam9-Feb-14 0:02

Mehdi Gholam

9-Feb-14 0:02

When it comes to users it is better not to assume anything...

... anyway what's wrong with living for the day!? Smile | :)

Colborne_Greg9-Feb-14 2:12

9-Feb-14 2:12

I don't think you see it.

If you fulfill the users needs - great you fulfilled the purpose for which they wanted.

What did that have anything to do with their jobs?
Are you sure they know exactly what they want?
Are they even saying the right keywords in the meaning you understand them?

If you program for today - today is as long as it will last.

ALM - Application lifecycle management; this concept should extend beyond the memory management and into the user cases - the GUI itself.

The PC is so great yet it's simplicity does not handle any one use case.
So when you handle the needs of the user you are defining your own limitations.

Septimus Hedgehog9-Feb-14 0:33

Septimus Hedgehog

9-Feb-14 0:33

Club the fox to death and rip its head off. Wring the chicken's neck and cook the bird and serve with a delicious peri-peri sauce. As for the seed, throw it away and see what grows in its place the following year. In the meantime, go to the island. Rabbit pie anyone?

If there is one thing more dangerous than getting between a bear and her cubs it's getting between my wife and her chocolate.

Riddle me this

Colborne_Greg8-Feb-14 17:54

8-Feb-14 17:54

If you can only do 2 things:
Add 25 to a number
or
subtract 6 from that number;
is it possible to obtain any number?
And how could you get the number 20 starting from 0?

CDP18028-Feb-14 18:46

8-Feb-14 18:46

x = 0;
while (x != n)    // n = 20, for example
{
    x += 25;    // x + 25 - 6 - 6 - 6 - 6 = x + 1
    x -= 6;     // loop will iterate n times to reach any positive number
    x -= 6;
    x -= 6;
    x -= 6;
}

Wow. That was hard. I just fell out of bed and still am sleeping to 90%. And, of course, you can also unroll the loop 20 times if it must be the primitive solution.

modified 9-Feb-14 1:37am.

Colborne_Greg8-Feb-14 19:19

8-Feb-14 19:19

Try to reach this answer in the least number of steps.

Try the human asnwer

CDP18028-Feb-14 19:44

8-Feb-14 19:44

The loop contains 5 operation and iterates 20 times, so we would have 100 operations. Fine.

0 + 25 - 6 + 25 - 6 - 6 - 6 - 6 = 20.

Or you could try to find the solutions for a x 25 + b x -6 = n for any given n. For n = 20 a would be 2 and b would be 5.

Colborne_Greg wrote:
Try the human asnwer

That's hard, even if I have to wait another 100 years before they finally send a ship to pick me up.

Colborne_Greg8-Feb-14 21:10

8-Feb-14 21:10

Two quarters and five half dozens.

The solution 50 cents for case of eggs.

Nagy Vilmos9-Feb-14 21:48

Nagy Vilmos

9-Feb-14 21:48

Simples:

int x = 0;
int n = 21;
while (x != n)
{
  while (x < n)
  {
    x+=25;  // too low goes up
  }
  while (x > n)
  {
    x-=6;  // too high goes down
  }
}
// Goldilocks, just right.

speramus in juniperus

Colborne_Greg10-Feb-14 10:19

10-Feb-14 10:19

Cool