Uninventing The Wheel

I'd forgotten about this site, SQLZoo.net, but it is indispensible for those of us working on cross-platform database projects. Give it a goal, say granting permissions on a database, and it will give you the syntax for how it's implemented across various DB engines.

The existence of these variations is, or should be, a source of considerable professional embarassment.

More than that, it reminds me how often it becomes necessary to descend from software abstraction into implementation minutae. This is an old problem. There's something rotten eating away at the trunk of the Tower of Babel.

Promising solutions: www.sqlobject.org, other middleware.

No comments: