Forum Down

[Art Deco]

I once contracted with one of the largest library systems in the USA because their system ain't broke, but it still needed fixing because it had grown unmanageable in its present form.. To fix the problem the floorboards needed to be completely torn up and the whole system needed a full do-over.

What was wrong?

The entire system was using Microsoft Access as the back end database. Not just one MS Access MDB file. There were (literally) 50 of them. Each with their own ODBC connection. This is a system with tens of thousands of county residents who were subscribers to a system that among other things tied into the U.S. Library of Congress every day (who used Oracle, BTW) to a) see what books had been published that day that matched the subscriber's preferences, so the subscriber could check off what they wanted when it came in b) which new books had been delivered to which library branches and c) reserved those books for subscribers who signed up to get first dibs on them when they came in. Oh and d) notified said subscribers of the book delivery and lets not forget e) managed everyone's login details and security.

50 Access database files, each of which had any number of individual database tables inside. I converted it all to one, single SQL Server database on a dedicated server. And re-did the Library of Congress feed. And the security system, and the subscription system.

But it was still working when they hired me. Pretty much. If it ain't broke, that doesn't mean its going to stay that way in a changing world.

I got that years-long job, btw, by hacking into the system in real time from the browser url while I was on the phone with the administrator and reading off to her the details I was seeing that I shouldn't be.

Been there, done that, got the damn . Not worth it IMHO.

 

[m@Robertson]

There is another solution to all of this.... It's called getting a life

Screw that noise! Without all this twitchy computer stuff some of us would have had to go flip burgers. Or walk dogs. Or something.

Bring on the EOLs and the 'password' passwords!

 

[Stefan Mikes]

There is another solution to all of this.... It's called getting a life

Prove how many km or miles you rode on last Saturday.

 

[Art Deco]

Screw that noise! Without all this twitchy computer stuff some of us would have had to go flip burgers. Or walk dogs. Or something.

Bring on the EOLs and the 'password' passwords!

Yeah, I tried "honest work" for several years BC (Before Computers) and couldn't figure out how folks make a living at it.

 

[Gionnirocket]

Prove how many km or miles you rode on last Saturday.

I have a life and "I" know what I did.
So I don't require validation or praise from anyone nor most certainly provide proof of anything.

Now you prove that you weren't having a mental crisis because you hadn't received any online "likes" on Saturday.
So far the evidence points to multiple panty changes.

 

[m@Robertson]

Prove how many km or miles you rode on last Saturday.

Why would ANYONE care about such a thing? The less you say things like this - ideally never again - the less respect you will lose.

 

[Stefan Mikes]

Why would ANYONE care about such a thing? The less you say things like this - ideally never again - the less respect you will lose.

I do not care of your respect.