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. I would appreciate any good input. Thanks
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. 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.
I would appreciate any good input. Thanks
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
I can't compare the three, but can report excellent success of using PoPy w/many large results. We don't get millions of hits, so I have less knowledge of how it handles # of users, but for large results, it's fine. On Thu, 8 Mar 2001, 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.
I would appreciate any good input. Thanks
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Joel Burton <jburton@scw.org> Director of Information Systems, Support Center of Washington
On Thursday 08 March 2001 10:53, 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
fyi another postgres python adaptor (a very nice one at that) is pgsql at http://sourceforge.net/projects/pgsql i would recommend ZPoPy for a da at this time... but if you're going to be connect to postgres outside of zope i recommend not using PoPy. Its regularly crashes python for me when i try to do things any heavy db work from outside zope. heavy constituting using bind variables, stored procs, checking rowcount, description, etc. in accessing postgres external to zope i'd recommend using pygresql (the native non-standard interface not the dbi wrapper) or pgsql. one thing to not about ZPygre is that it synchronizes all db access. if you're making lots of small queries this is not the adaptor for you. if you've got some large queries you're better off testing both and seeing which one gives you better throughput (probably PoPy, buts it not a sure thing).
any others? psycopg mentions that it is designed for heavy multi threaded operations but popy seems more developed.
psycopg has interesting arch, but if you're using postgres its good to keep in mind that libpq (the c client interface to postgres) does not support multiple threads sharing a connection. psycopg does internal bookeeping in the module itself after a connect to keep around a pool of connections. when it matures it should be a very good postgres adaptor for zope. cheers kapil
participants (4)
-
ender -
Jim Penny -
Joel Burton -
Joshua