SQL and the LGP-30

From: Roedy Green (look-on_at_mindprod.com.invalid)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 06:37:28 GMT

You can see a picture of my first personal computer, an LGP-30 at
http://mindprod.com/jgloss/mindprod.com/equipment.html

It had no transistors, just tubes, a rotating drum, and a few diodes.

You programmed the thing with absolute addresses, a hex track and
sector number on the drum.

Programming with JDBC took be back to those thrilling days of
yesteryear. Every parameter is numbered, one based.

I can't believe the incompetence of this intefarce.

At the very least it should have named parameters in the
prepareStatement.

It is a nightmare trying to write code where the PreparedStatements
are nowhere near the code that has to used counted fieldnames in them.
You CAN'T proofread the damn things.

Further the debugging tools to figure out what is going on are
non-existent. You have to pepper your code with debug output to
narrow down where the problem is.

You can't even cut and paste into MySQL to test the SQL.

You'd think after 30 years or so they have got this stuff polished. 

-- 
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming. 
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.