On 04/28/2016 11:04 PM, Neal Gompa wrote:
On Thu, Apr 28, 2016 at 8:09 PM, Mike Bonnet mikeb@redhat.com wrote:
Hi! As an exercise, I looked in to what it would take to port Koji from PyGreSQL to psycopg2. Turns out, it didn't take much at all:
https://pagure.io/fork/mikeb/koji/c/676db88a8bd4c729278ef4594c9174be5b554b2f
Now, do we think this is a good idea? I haven't done any performance testing, but in general it seems like pycopg2 is better supported. Thoughts?
I'm curious as to why you didn't choose pg8000 (a pure-Python module) over pycopg2 (a Python extension)?
Well, we haven't chosen anything yet. Psycopg2 just seems to be the most popular. For this use, I don't think pure python matters much to us.
We can certainly evaluate other options. Here is the list from the postgres site: https://wiki.postgresql.org/wiki/Python
(granted all other options besides the three listed so far appear unmaintained)