SOCI is an abstraction layer for several database backends, including PostreSQL, SQLite, ODBC and MySQL.

The Lightning Memory-Mapped Database (LMDB) is a high-performance transactional database. Unlike more complex relational databases, LMDB handles only key-value pairs (stored as arbitrary byte arrays) and relies on the underlying operating system for caching and locking, keeping the code small and simple. The use of ‘zero-copy’ memory-mapped files combines the persistence of classic disk-based databases with high read performance that scales linearly over multiple cores. The size of each database is limited only by the size of the virtual address space — not physical RAM.

Tokyo Cabinet is a library of routines for managing a database. The database is a simple data file containing records, each is a pair of a key and a value. Every key and value is serial bytes with variable length. Both binary data and character string can be used as a key and a value. There is neither concept of data tables nor data types. Records are organized in hash table, B+ tree, or fixed-length array.

SQLcrush lets you view and edit a database directly from the text console through an ncurses interface. You can explore each table's structure, browse and edit the contents, add and delete entries, all while tracking your changes.

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

dicedb is a fast, reactive, in-memory database optimized for modern hardware. Commonly used as a cache, it offers a familiar interface while enabling real-time data updates through query subscriptions. It delivers higher throughput and lower median latencies, making it ideal for modern workloads.

This library implements a database independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework.

This package implements the LSP for SQL.

This package provides a Postgres SQL parser as a library.

DBIx::Simple provides a simplified interface to DBI, Perl's powerful database module. This module is aimed at rapid development and easy maintenance. Query preparation and execution are combined in a single method, the result object (which is a wrapper around the statement handle) provides easy row-by-row and slurping methods.

SQLAlchemy-utils provides various utility functions and custom data types for SQLAlchemy. SQLAlchemy is an SQL database abstraction library for Python.

You might also want to install the following optional dependencies:

1. python-passlib

2. python-babel

3. python-cryptography

4. python-pytz

5. python-psycopg2

6. python-furl

7. python-flask-babel

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.

fastparquet is a Python implementation of the Parquet file format. fastparquet is used implicitly by dask, pandas and intake-parquet. It supports the following compression algorithms:

• Gzip

• Snappy

• Brotli

• LZ4

• Zstd

• LZO (optionally)

LevelDB is a fast key-value storage library that provides an ordered mapping from string keys to string values.

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.

SQLCipher is an implementation of SQLite, extended to provide transparent 256-bit AES encryption of database files. Pages are encrypted before being written to disk and are decrypted when read back. It’s well suited for protecting embedded application databases and for mobile development.

asyncmy is a fast asyncio MySQL driver, which reuses most of pymysql and aiomysql but rewrites the core protocol with Cython for performance.

libMemcached is a library to use memcached in C/C++ applications. It comes with a complete reference guide and documentation of the API, and provides features such as:

• Asynchronous and synchronous transport support

• Consistent hashing and distribution

• Tunable hashing algorithm to match keys

• Access to large object support

• Local replication

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 Python package provides an API to execute meta-commands (AKA "special", or "backslash commands") on PostgreSQL.

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

WiredTiger is an extensible platform for data management. It supports row-oriented storage (where all columns of a row are stored together), column-oriented storage (where columns are stored in groups, allowing for more efficient access and storage of column subsets) and log-structured merge trees (LSM), for sustained throughput under random insert workloads.

Memcached is an in-memory key-value store. It has a small and generic API, and was originally intended for use with dynamic web applications.

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