On Mon, Mar 31, 2008 at 12:32 PM, Nathan <<a href="mailto:nathan.stocks@gmail.com">nathan.stocks@gmail.com</a>> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is there any noticeable difference between psycopg (version 2) or<br>
pygresql (version 3.8.1) when used with twisted.enterprise to connect<br>
to postgresql?<br>
</blockquote><div><br>I have found psycopg 2 to be faster. I do not have the data anymore but I use it in production and works great.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Pygresql hasn't been updated since June 2006, but maybe that's just<br>
because it's stable (?) -- I haven't used it at all, ever.<br>
<br>
Psycopg2 has had more recent releases, but I've experience some bugs<br>
with it in (non-twisted) threaded code and the web site has been down<br>
for weeks (months?), so I thought it wise to explore alternatives...</blockquote><div><br>What bugs are you experiencing? What version are you using? We use psycopg2-2.0.6svn in production and has been fine.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
Or is there a better third alternative???<br>
<br>
Also, we're considering turning on SSL client-certificate verification<br>
on our postgresql installation -- does anyone know whether either of<br>
the above support SSL client certificates?<br>
</blockquote><div><br>I do not know if psycopg supports this.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Opinions?<br>
</blockquote><div><br><br>If you run psycopg you may want to use the patch in ticket #2488 it helps performance.<br> <br><a href="http://twistedmatrix.com/trac/ticket/2488">http://twistedmatrix.com/trac/ticket/2488</a><br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
~ Nathan<br>
<br>
_______________________________________________<br>
Twisted-Python mailing list<br>
<a href="mailto:Twisted-Python@twistedmatrix.com">Twisted-Python@twistedmatrix.com</a><br>
<a href="http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python" target="_blank">http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python</a><br>
</blockquote></div><br>