[Zope] best postgreSQL adapter?

[Federico Di Gregorio]

> On Thu, Mar 08, 2001 at 11:53:43AM -0700, Joshua wrote:
> > I'm curious as to which PostgreSQL zope adapter is most solid. I'm looking
> > to build what will eventually have fairly heavy traffic database usage.
> > Let's see...I found:
> >
> > psycopg/ZpsycopgDA
> > ZPyGreSQLDA
> > PoPy
> >
> > any others?  psycopg mentions that it is designed for heavy multi threaded
> > operations but popy seems more developed.
> 
> In a nutshell, you hit it on the head.  Psycopg is _very_ young.
> It may surpass PoPy in the future.

true, psycopg is very young but already *very* stable. it is fully
DBAPI-2.0 compliant, just like popy, so you won't have any problem
switching back and forth between them. (btw, our website runs on 
psycopg from 0.3 onward and we never had any problems.)

> For now, I would recommend that you develop using PoPy and build a secondary
> test machine using psyco.  Your applications should be 100% compatible, so,
> there should be no real cost to switching later if psycopg proves better
> in your application.

completely true ;)

> > I would appreciate any good input. Thanks

what can i say? give psyco a try...

ciao,
federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
   Abandon the search for Truth; settle for a good fantasy. -- Anonymous