I did work for PostgreSQL, using pypgsql, although I actually don't know its
state. There were some problems, one of them being the unique Object Id, and
the other the support of enum data types which PostgresQL doesn't have but
On the other way it's very compatible to use the database to generate enums,
although this makes it easier to do load balancing. In some of the OO
papers, it's proposed to do a high/low counter generation, that is, there
would be a light weight process to serve high numbers and each webware
process would generate it's own low values, e.g. 32 buts for high and other
32 bits low, so each Webware process will request a new high value when it
gets out of low values (after 2^32 times). This would make the Object Id
code absolutely DB independent.
On the other hand I would like to see going MiddleKit towards DB-API 2.0, or
the new persistence framework of the Python Crew (when it is out), something
more standard and not such mySQL specific, because there are so many
wonderful databases out there (Firebird, SQL lite, MetaKit, etc.)
----- Original Message -----
From: "Ian Bicking" <ianb@...>
To: "Max Ischenko" <max@...>
Sent: Wednesday, October 09, 2002 2:49 AM
Subject: Re: [Webware-discuss] MiddleKit port to PostgreSQL
> On Tue, 2002-10-08 at 01:53, Max Ischenko wrote:
> > Hi,
> > I'd like to try MiddleKit but I am to use PostgreSQL DB, which seems
> > unsupported.
> > How complex would be to add the PostgreSQL support or may be it is
> > already done in CVS?
> There's a patch on sourceforge -- I have no idea what it looks like, or
> what kind of state it is in. Many people have started to work on this,
> but no one has really finished as far as I can tell. I was hoping one
> of them would pipe up -- at least to say what problem they encountered,
> or if they have some progress they could share. Maybe it's harder than
> it seems, or maybe it just doesn't quite get done, I dunno.
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> Webware-discuss mailing list