At 07:37 PM 8/1/2001 +0200, Federico Di Gregorio wrote:
>doesn't MiddleKit use *any* DBAPI compliant driver?
No, because DB API doesn't capture the variations in SQL between databases.
It only captures the way that you connect and programmatically, via method
calls, interact with the database.
For example, MySQL allows multiple value sets for INSERT, but Postgres
(according to what I hear) does not. Also, MySQL uses 0 and 1 for booleans,
but Postgres uses 't' and 'f'. The minor variations go on and on.
Therefore it necessary to write "database adapters" in order for MiddleKit
to support various databases. Fortunately, most of the work is done for you
in abstract, but highly functional, base classes.
And the new Postgres support this has helped flush out some remaining flaws
in the framework's design (with being database agnostic).