Firebird is an SQL RDBMS with rich support for ANSI SQL (e.g., INSERT...RETURNING) including UDFs and PSQL stored procedures, cursors, and triggers. Transactions provide full ACID-compliant referential integrity.

The database requires very little manual maintenance once set up, making it ideal for small business or embedded use.

When installed as a traditional local or remote (network) database server, Firebird can grow to terabyte scale with proper tuning---although PostgreSQL may be a better choice for such very large environments.

Firebird can also be embedded into stand-alone applications that don't want or need a full client & server. Used in this manner, it offers richer SQL support than SQLite as well as the option to seamlessly migrate to a client/server database later.

Sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.

psycopg2 is a thread-safe PostgreSQL adapter that implements DB-API 2.0.

This package contains bindings for the ADBC Driver Manager, as well as a DBAPI 2.0/PEP 249-compatible interface on top. This can be used to load ADBC drivers at runtime and use them from Python. Backend-specific packages like adbc_driver_postgresql wrap this package in a more convenient interface, and should be preferred where they exist.

lmdbxx is a comprehensive C++ wrapper for the LMDB embedded database library, offering both an error-checked procedural interface and an object-oriented resource interface with RAII semantics.

aiomysql is a driver for accessing a MySQL database from the asyncio Python framework. It depends on and reuses most parts of PyMySQL. aiomysql tries to preserve the same API as the aiopg library.

This package provides aerich, a Python database migrations tool for Tortoise ORM. It can be used both programmatically or as a standalone CLI application.

SQL::Tokenizer is a tokenizer for SQL queries. It does not claim to be a parser or query verifier. It just creates sane tokens from a valid SQL query.

Galera is a wsrep-provider that is used with MariaDB for load-balancing and high-availability (HA).

This module tries to split any SQL code, even including non-standard extensions, into the atomic statements it is composed of.

Databases provides a wrapper around asynchronous database libraries with SQLALchemy.

This package provides two scripts that will backup PostgreSQL databases in a cluster. They are supposed to be run in scheduled jobs. pg_backup.sh runs regular backups, pg_backup_rotated.sh runs rotated backups.

This library provides a Pythonic API wrapper for the reference Arrow C++ implementation, along with tools for interoperability with pandas, NumPy, and other traditional Python scientific computing packages.

Redis is an advanced key-value cache and store. Redis supports many data structures including strings, hashes, lists, sets, sorted sets, bitmaps and hyperloglogs.

This package provides mock helpers for SQLAlchemy that makes it easy to mock an SQLAlchemy session while preserving the ability to do asserts.

Normally Normally SQLAlchemy's expressions cannot be easily compared as comparison on binary expression produces yet another binary expression, but this library provides functions to facilitate such comparisons.

Unixodbc is a library providing an API with which to access data sources. Data sources include SQL Servers and any software with an ODBC Driver.

FreeTDS is an implementation of the Tabular DataStream protocol, used for connecting to MS SQL and Sybase servers over TCP/IP.

pgloader is a program that can load data or migrate databases from CSV, DB3, iXF, SQLite, MS-SQL or MySQL to PostgreSQL.

python-sql is a library to write SQL queries, that transforms idiomatic python function calls to well-formed SQL queries.

APSW is a Python wrapper for the SQLite embedded relational database engine. In contrast to other wrappers such as pysqlite it focuses on being a minimal layer over SQLite attempting just to translate the complete SQLite API into Python.

dogpile.cache is a caching API which provides a generic interface to caching backends of any variety, and additionally provides API hooks which integrate these cache backends with the locking mechanism of dogpile.

MDB Tools is a set of tools and applications to read the proprietary MDB file format used in Microsoft's Access database package. This includes programs to export schema and data from Microsoft's Access database file format to other databases such as MySQL, Oracle, Sybase, PostgreSQL, etc., and an SQL engine for performing simple SQL queries.

This package is an implementation of psycopg2 using CFFI.

PostgreSQL is a powerful object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video.