“As an open source database, PostgreSQL has one of the largest
libraries of Application Programmable Interfaces (APIs) available,
letting you access it easily from various languages. One such
language is Python, which happens to be one of my favorite
languages; I use it for almost all my hacking. To be honest, I’m
not that great a programmer. I’m a database administrator and
operating system consultant by trade. But Python ensures that the
code that I do write is readable by other, more talented
programmers—even six months after I stopped working on
it.“Nine times out of 10, I use Python to communicate with a
PostgreSQL database. My driver of choice when doing so is called
Psycopg2. Like the first release (Psycopg), it’s designed to be
lightweight and fast. Recently Psycopg2 has been under heavy
development and is currently in Beta 4, which is supposed to be the
last beta before the official release…”