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

Burus Gmail eburus at gmail.com
Tue Apr 1 13:55:06 MDT 2008


We using psycopg1 for the data synchronization between MySQL\PostgreSQL,
MSSQL\PostgreSQL and etc...

psycopg2 is "faster" but very buggy in the 256/24/7 systems. We use
older version and it better choose for us,
stability is in the priority.

Christopher Zorn wrote:
> 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
>>
>>     
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Twisted-Python mailing list
> Twisted-Python at twistedmatrix.com
> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>   

-- 
"""
Best regards, Alexander Burtsev. 
Web Development Department, TV Channel 'Sport'

http://sportbox.ru
http://burus.org
"""

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/twisted-python/attachments/20080401/d57b2d1c/attachment.html>


More information about the Twisted-Python mailing list