[Seaside] state of the aubergine

[Julian Fitzell]

Cees de Groot wrote:
> Avi Bryant <avi@beta4.com> said:
> 
>>Yes, what I've done instead is stolen an existing generic layer.  I keep a
>>small java app running that accepts socket connections from squeak and
>>forwards database queries through JDBC drivers; this lets me generically
>>access Oracle, Postgres, etc, at a slight performance penalty.
>>
>>A pure squeak solution would be preferable, of course.
>>
> 
> I think that you should be able to access PostgreSQL and MySQL from Squeak
> (IIRC, there's a Squeak driver for MySQL and the VW PostgreSQL driver has been
> ported). Both are probably direct socket interfaces.
> 
> Oracle and Sybase would probably be relatively easy as well with FFI.

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.

Julian

-- 
julian@beta4.com
Beta4 Productions (http://www.beta4.com)