From: Baruch E. <ba...@ev...> - 2001-08-01 13:30:23
|
I believe I've seen that someone is working on implementing PostgreSQL support for MiddleKit. I'm interested in this and willing to help some in coding/debugging it. -- Baruch Even http://baruch.ev-en.org/ |
From: Federico Di G. <fo...@mi...> - 2001-08-01 17:37:16
|
Scavenging the mail folder uncovered Baruch Even's letter: > I believe I've seen that someone is working on implementing PostgreSQL > support for MiddleKit. > > I'm interested in this and willing to help some in coding/debugging it. doesn't MiddleKit use *any* DBAPI compliant driver? try out using it with psycopg (http://initd.org/Software/psycopg/) a quite good postgresql driver :) (ok, ok, i know it still has a #ç%£$£! segfault hidden somewhere...) ciao, federico |
From: Chuck E. <Chuck@StockAlerts.com> - 2001-08-01 17:48:08
|
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). -Chuck |