From: "Florian G. Pflug" <fgp@...>
Date: 2001-05-08T04:08:22+09:00
Subject: [ruby-talk:14795] Re: Database Abstraction Framework

On Mon, May 07, 2001 at 10:38:10PM +0900, Steve Tuckner wrote:
> If you have time, please try to make sure that your high level database
> interface (object/relation mapping) maps to the ongoing DBI/DBD framework
> being developed. That way Ruby can have the best of both worlds (a very high
> level database interface and lots of database drivers to connect that high
> level interface to).
Hi

I certainly will use DBI - but there will still be the need for an extra
driver for each database for my api.

the difference between the SQLs the dbmses understand are too big - especially
when it comes to transactions, and referenceral integrity(hope I translated
that into english correctly ;-) ).

Mysql e.g. has no features which support referencial integrity, meaning that
things like deleting not referenced records from a related table will need
to be implemented in some sort of "emulation layer".

This is the hardest part of the whole thing I guess - at least I only partly
figured how to solve this until now.

greetings, Florian Pflug