Postmodern is a Common Lisp library for interacting with PostgreSQL databases. It is under active development.
Psycopg is the most popular PostgreSQL adapter for the Python programming language.