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 could emulate.
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.) Best regards, Erny ----- Original Message ----- From: "Ian Bicking" <[EMAIL PROTECTED]> To: "Max Ischenko" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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. > > Ian > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Webware-discuss mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/webware-discuss ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
