TinyDB is a small document oriented database written in pure Python with no external dependencies. The targets are small apps that would be blown away by a SQL-DB or an external database server.

This package provides a utility for dumping the contents of an ElasticSearch index to a compressed file and restoring the dumpfile back to an ElasticSearch server

This module was inspired by the excellent DBIx::Abstract. While based on the concepts used by DBIx::Abstract, the concepts used have been modified to make the SQL easier to generate from Perl data structures. The underlying idea is for this module to do what you mean, based on the data structures you provide it, so that you don't have to modify your code every time your data changes.

Peewee is a simple and small ORM (object-relation mapping) tool. Peewee handles converting between pythonic values and those used by databases, so you can use Python types in your code without having to worry. It has built-in support for sqlite, mysql and postgresql. If you already have a database, you can autogenerate peewee models using pwiz, a model generator.

PickleShare is a small ‘shelve’-like datastore with concurrency support. Like shelve, a PickleShareDB object acts like a normal dictionary. Unlike shelve, many processes can access the database simultaneously. Changing a value in database is immediately visible to other processes accessing the same database. Concurrency is possible because the values are stored in separate files. Hence the “database” is a directory where all files are governed by PickleShare.

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.

SDB is a simple key/value database based on djb's cdb disk storage that supports JSON and array introspection.

This package provides a CLI tool and Python utility functions for manipulating SQLite databases. It's main features are:

• Pipe JSON (or CSV or TSV) directly into a new SQLite database file, automatically creating a table with the appropriate schema.

• Run in-memory SQL queries, including joins, directly against data in CSV, TSV or JSON files and view the results.

• Configure SQLite full-text search against your database tables and run search queries against them, ordered by relevance.

• Run transformations against your tables to make schema changes that SQLite ALTER TABLE does not directly support, such as changing the type of a column.

• Extract columns into separate tables to better normalize your existing data.

This package contains type stubs and a mypy plugin to provide more precise static types and type inference for SQLAlchemy framework.

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.

Sqlitebrowser lets you create, design, and edit database files compatible with SQLite using a graphical user interface.

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.

pgcli is a command line interface for PostgreSQL with autocompletion and syntax highlighting.

This package implements the LSP for SQL.

Pebble is a LevelDB/RocksDB inspired key-value store focused on performance and internal usage by CockroachDB. Pebble inherits the RocksDB file formats and a few extensions such as range deletion tombstones, table-level bloom filters, and updates to the MANIFEST format. This package provides command line interface (CLI).

Databases provides a wrapper around asynchronous database libraries with SQLALchemy.

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.

Pebble is a LevelDB/RocksDB inspired key-value store focused on performance and internal usage by CockroachDB. Pebble inherits the RocksDB file formats and a few extensions such as range deletion tombstones, table-level bloom filters, and updates to the MANIFEST format.

QDBM is a library of routines for managing a database. The database is a simple data file containing key-value pairs. Every key and value is serial bytes with variable length. Binary data as well as character strings can be used as a key or a value. There is no concept of data tables or data types. Records are organized in a hash table or B+ tree.

asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python's asyncio framework.

MySQL::Config emulates the load_defaults function from libmysqlclient. It will fill an array with long options, ready to be parsed by Getopt::Long.

This package provides a lightweight wrapper around the sqlite3 database with a simple, Pythonic dict-like interface and support for multi-thread access.

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.

Apache Arrow is a columnar in-memory analytics layer designed to accelerate big data. It houses a set of canonical in-memory representations of flat and hierarchical data along with multiple language-bindings for structure manipulation. It also provides IPC and common algorithm implementations.