oursql is a set of MySQL bindings for python 2.4+ with a focus
on wrapping the MYSQL_STMT API to provide real parameterization
and real server-side cursors. MySQL 4.1.2 or better is required.
Peewee is a small, expressive ORM written in Python. It supports
PostgreSQL, MySQL and SQLite.
pg8000 is a Pure-Python interface to the PostgreSQL database
engine. It is one of many PostgreSQL interfaces for the Python
programming language. pg8000 is somewhat distinctive in that
it is written entirely in Python and does not rely on any
external libraries (such as a compiled python module, or
PostgreSQL's libpq library). pg8000 supports the standard
Python DB-API version 2.0.
PQueue is a package providing low-level PQ protocol classes for
interacting with a PostgreSQL database. It supports version 3.0
of the protocol--the current primary version of protocol. The
package also provides a basic protocol transaction class. This
class keeps the state of the protocol in an interrupt safe manner,
and validates the integrity of the communication as messages are
received.
In general, you probably will never use this package directly,
unless you are writing a driver.
pgcli is a command line interface for Postgres with auto-completion and syntax
highlighting.
This package provides an API to execute meta-commands (AKA "special", or
"backslash commands") on PostgreSQL.
pickleDB is a lightweight, fast, and simple database based on Python's own
json module.
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
The psycogreen package enables psycopg2 to work with coroutine libraries,
using asynchronous calls internally but offering a blocking interface so
that regular code can run unmodified.
psycopg2 is a PostgreSQL database adapter for the Python programming language.
It was written from scratch with the aim of being small, fast and stable. It
supports the full Python DBAPI-2.0 and is thread safe.
psycopg2 is different from the other database adapter because it was designed
for heavily multi-threaded applications that create and destroy lots of cursors
and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open
Python connection keeps a pool of real (UNIX or TCP/IP) connections to the
database. Every time a new cursor is created, a new connection does not need to
be opened; instead one of the unused connections from the pool is used. That
makes psycopg very fast in typical client-server applications that create a
servicing thread every time a client request arrives.