[Seaside] state of the aubergine

Cees de Groot cg@cdegroot.com
23 Apr 2002 00:36:51 +0200


Julian Fitzell <julian@beta4.com> said:
>You can access them but there is no db-independant layer.  We've got 
>around this by abstracting some stuff ourselves but in a case where 
>you're writing something that is going to be re-used for multiple 
>projects and the dbms' involved cannot be predicted, having a generic 
>DBI layer is more than a nicety.
>
So start growing one. 

Last time I did this I just started out with a db-dependent layer
until the request for the first port came. That request hurt a bit, the
subsequent requests hurt a lot less. Certainly I wouldn't take the absence
of a db-independent layer as a reason to let Java enter the picture ;-).

(I'm a bit on my home turf here, having designed and implemented lots of ODBC
and JDBC and even ODBC-to-JDBC-bridging stuff - JDBC and ODBC suck to a large
extent, because Microsoft bloated ODBC beyond recognition and JDBC imitated
that; the original X/Open SAG/CLI spec would probably be a reasonable
starting point for a database independence layer. I'm not sure whether it
floats on the Net somewhere; an old DB/2 programming manual would probably
do, IBM used to stick close to this spec).


-- 
Cees de Groot               http://www.cdegroot.com     <cg@cdegroot.com>
GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD  1986 F303 937F E098 9E8B