My first class on relational databases and SQL was a BIG step backwards.

I was using FOCUS, which used relational hierarchies. You could not do SQL injection with its update and retrieval language. Also, you would not take apart the entire timesheet. Only the employee’s personal information would be in a separate structure. It did take more skill to design the database, though.

Relational databases and SQL are an excellent example of the product with the best publicity becoming the standard, whether it worked well or not. I cursed the Focus management’s business decisions every time I had to use SQL, to the day I retired in 2016.

Looking back, I built my first relational database in 1969. I had to write my own update and retrieval functions. I also had to write my own memory swapping routines since the data fields in the program would not all fit. The disk drive, the size of a small, square table, shook when it ran. The system ran for 18 years, without an upgrade, until they replaced it.

A great article highlighting the faults of relational databases in a way that a normal person can understand. This is the first article that I have given 50 claps to.

William “Bill” Myers, Analyzes all, Programmer, retired. If you learn anything new, find enjoyment, have a new thought, then I’m successful. Photo: 1st article

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store