[Twisted-Python] Is psycopg or pygresql better with twisted.enterprise?

Christopher Zorn christopher.zorn at gmail.com
Tue Apr 1 09:09:56 EDT 2008


On Mon, Mar 31, 2008 at 12:32 PM, Nathan <nathan.stocks at gmail.com> wrote:

> Is there any noticeable difference between psycopg (version 2) or
> pygresql (version 3.8.1) when used with twisted.enterprise to connect
> to postgresql?
>

I have found psycopg 2 to be faster. I do not have the data anymore but I
use it in production and works great.


>
> Pygresql hasn't been updated since June 2006, but maybe that's just
> because it's stable (?) -- I haven't used it at all, ever.
>
> Psycopg2 has had more recent releases, but I've experience some bugs
> with it in (non-twisted) threaded code and the web site has been down
> for weeks (months?), so I thought it wise to explore alternatives...


What bugs are you experiencing? What version are you using? We use
psycopg2-2.0.6svn in production and has been fine.


>
>
> Or is there a better third alternative???
>
> Also, we're considering turning on SSL client-certificate verification
> on our postgresql installation -- does anyone know whether either of
> the above support SSL client certificates?
>

I do not know if psycopg supports this.


>
> Opinions?
>


If you run psycopg you may want to use the patch in ticket #2488 it helps
performance.

http://twistedmatrix.com/trac/ticket/2488


> ~ Nathan
>
> _______________________________________________
> Twisted-Python mailing list
> Twisted-Python at twistedmatrix.com
> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://twistedmatrix.com/pipermail/twisted-python/attachments/20080401/846f28a2/attachment.htm 


More information about the Twisted-Python mailing list