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.

Yoyo is a database schema migration tool. Migrations are written as SQL files or Python scripts that define a list of migration steps.

Valkey is a high-performance key-value datastore that supports a variety of workloads such as caching, message queues, and can act as a primary database.

This module is nearly identical to SQL::Abstract 1.81, and exists to preserve the ability of users to opt into the new way of doing things in later versions according to their own schedules.

It is an abstract SQL generation module based on the concepts used by DBIx::Abstract, with several important differences, especially when it comes to WHERE clauses. These concepts were 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. You shouldn't have to modify your code every time your data changes, as this module figures it out.

MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249).

Libpqxx is a C++ library to enable user programs to communicate with the PostgreSQL database back-end. The database back-end can be local or it may be on another machine, accessed via TCP/IP.

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.

This package implements the LSP for SQL.

This module creates a temporary SQLite database, deploys a DBIC schema, and then connects to it. This lets you easily test DBIC schema. Since you have a fresh database for every test, you don't have to worry about cleaning up after your tests, ordering of tests affecting failure, etc.

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.

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

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.

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.

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.

Virtuoso is a scalable cross-platform server that combines relational, graph, and document data management with web application server and web services platform functionality.

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

This package provides a Python client library for CrateDB. It implements the Python DB API 2.0 specification and includes support for SQLAlchemy.

This Python package provides an API to execute meta-commands (AKA "special", or "backslash commands") on PostgreSQL.

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

Package rdb implements parsing and encoding of the Redis RDB file format.

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.

The DB::File module provides Perl bindings to the Berkeley DB version 1.x.

This package provides a Postgres SQL parser as a library.

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.