Postgresql - Preferred Python Library

[Lee Harr]

On 2004-09-10, Matt Goodall <matt at pollenation.net> wrote:
> I've just started experimenting with psycopg2
> (http://wiki.initd.org/Projects/PsycopgTwo) and it's looking good.
>
> As far as I know, psycopg2 is the only DB-API 2.0 implementation for
> PostgreSQL that uses Python 2.3's datetime types by default.


ooh, aah.   :o)

Yes, the datetime handling in the older psycopg was getting on my
nerves... Native datetime is going to make things much nicer.

That said, psycopg works very well for me.

The only other thing that is a bit strange is passing array
types in to the database. I have been using this:

alist = ['foo', 'bar']
query = 'SELECT ARRAY%(alist)s'
execute(query, locals())

It works perfectly well, but it seems a bit strange...