CODEWITHSUNDEEP
pythonpostgresql
Mike Trelinski
Mike Trelinski

Reputation: 25

What are my options for a Python open source cross-platform Postgres-Compatible driver?

I'm not really a Python expert nor am I a Postgres expert, but here goes:

I need a good open source Postgres driver for Python. It must be able to work cross platform with little fuss, between Windows, Mac, and Linux. The end goal is to have it deployed to a 64 bit CentOS Linux server.

I need it to be open source, because I will need to modify it a little bit to fit our Postgres-like database. I have already done this in the C-only world with great success and I would like to avoid rolling my own driver from scratch.

Any suggestions?

Thanks you.

Upvotes: 0

Views: 148

Answers (1)

mata
mata

Reputation: 69042

i've used these:

  • pg8000 - written in pure python, therefore no compiling needed on the target platform. good if portability is an issue.

  • psycopg2 - written in c, therefore a bit faster then pg8000, but compiling needed for the target platform.

Upvotes: 2

Related Questions