Re: Great Bridge PostgreSQL
FYI, Many of you probably have seen the blurbs about Great Bridge, a new company dedicated to promoting and supporting PostgreSQL. This looked like an opportunity to tap into a source of expert support to bring the Python / Zope interfaces for PostgreSQL up to par with the currrent revs. Below is a reply to an E-Mail I sent to Colin Orr, Great Bridge's technical contact. Later, Jerry S.
From: "colin orr" <max_orr@hotmail.com> To: jerry@spicklemire.com Subject: Re: Great Bridge PostgreSQL Date: Wed, 10 May 2000 08:11:08 GMT
Jerry,
Thanks for your enquiry and interest. I am currently looking into the state of DB-API2 compliance and I will get back to you shortly with an update.
Regards,
Colin
Date: Tue, 09 May 2000 11:40:16 -0500
Hi Colin,
Below are some snippets from the Zope-Development Mailist, mentioning why PostgreSQL was not considered as a platform for initial development of several critical new modules. The Zope Web Development Environment is poised to make an unparalleled impact on Web Development, and all PostgreSQL lacks to be a primary partner is a fully functional Python/Zope Database Adapter. Hopefully the folks at Great Bridge can look into what it might take to quickly eliminate this impediment.
snip
... MySQL and Oracle (and actually InterBase as well) are frontrunning candidates for development of RelationalStorage because they already have Python DB-API2 compliant adapters written for them. Postgres can certainly handle it (AFAICT it's ideal), but I don't much feel like writing to a non-DBAPI compliant in the first cut as it limits the platform to *only* postgres initially, and I don't want to wrap the existing postgres da in a DB-API2 wrapper or anything (it's just no fun). Hopefully, once there is some code to poke at, people will modify it to make it work against their database of choice.
Jerry Spicklemire wrote:
FYI,
Many of you probably have seen the blurbs about Great Bridge, a new company dedicated to promoting and supporting PostgreSQL. This looked like an opportunity to tap into a source of expert support to bring the Python / Zope interfaces for PostgreSQL up to par with the currrent revs. Below is a reply to an E-Mail I sent to Colin Orr, Great Bridge's technical contact.
Later, Jerry S.
From: "colin orr" <max_orr@hotmail.com> To: jerry@spicklemire.com Subject: Re: Great Bridge PostgreSQL Date: Wed, 10 May 2000 08:11:08 GMT
Jerry,
Thanks for your enquiry and interest. I am currently looking into the state of DB-API2 compliance and I will get back to you shortly with an update.
Actually DB-API and ZPyGreSQL are not the same thing at all. Although DB-API compliance could help, the real issues for Zope are with the DA (Zope Database Adapter). For some reason the the general belief in Zope community is that libpq is not thread-safe (which I believe is not true for a few year already ;) and therefor PyGreSQL is can not be made thread-safe and thus ZPyGreSQLDA is not thread-safe. It does not mean that different threads should be able to issue queries to the same connection (which the backend would not support anyhow), but that different threads should be able to open different connections for then and not be afraid of stepping on each others toes in the process. ----------------- Hannu
Scavenging the mail folder uncovered Hannu Krosing's letter:
Actually DB-API and ZPyGreSQL are not the same thing at all.
true. we are working on a DBI compliant python module for pg. (it does not support lobs and error management is not perfect but we'll publish it (GPL) ASAP (check www.mixadlive.com in the next few days...) -- Federico Di Gregorio MIXAD LIVE System Programmer fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org 99.99999999999999999999% still isn't 100% but sometimes suffice. -- Me
participants (3)
-
fog@mixadlive.com -
Hannu Krosing -
Jerry Spicklemire