Peewee

Peewee is a SQL object-relational mapper and query builder that provides an object-oriented interface for mapping application classes to relational database tables. It functions as a relational database toolkit for managing schemas, executing migrations, and handling complex table relationships.

The project distinguishes itself by providing an asyncio database driver for non-blocking database operations, ensuring event loop responsiveness. It also supports semi-structured data storage, allowing the storage and querying of flexible JSON documents within traditional relational database systems.

The toolkit covers a broad set of capabilities, including the construction of complex SQL queries via a composable programmatic interface and the management of many-to-many relationships and foreign key resolution. It includes utilities for bulk data operations, full-text search, and database introspection to generate models from existing schemas. Connection management is handled through pooling and transaction control to ensure data integrity.

Features

Object-Relational Mappers - Provides an object-oriented interface to map application classes to relational database tables and execute SQL queries.

Object-Relational Mapping - Implements an object-oriented interface that maps application classes to relational database tables.

Asynchronous Database Command Execution - Enables non-blocking execution of database commands to maintain event loop responsiveness.

Asynchronous Database Drivers - Provides non-blocking database drivers designed for high-concurrency asyncio environments.

Database Query Execution - Executes database queries and model methods asynchronously to keep the event loop responsive.

Database Record Querying - Provides structured mechanisms for retrieving records from tables using filters, sorting, and pagination.

Fluent Query APIs - Offers a fluent API for retrieving data with support for filtering, joining, and ordering.

Hybrid Relational-JSON Storage - Allows storing and querying flexible JSON documents within traditional relational database systems.

Code-to-Relational Mappings - Maps high-level class definitions to relational database tables for automated schema management.

SQL Query Builders - Ships a composable programmatic interface for constructing complex SQL queries.

Asynchronous Drivers - Provides an asyncio database driver for non-blocking operations to ensure event loop responsiveness.

Bulk Data Operations - Supports high-performance bulk inserts and updates to reduce database round-trips.

Semi-Structured Data Integration - Integrates flexible JSON and HStore data formats into relational tables for semi-structured storage.

Database Connection Managers - Manages the opening, closing, and pooling of connections to various database backends.

Database Driver Abstractions - Abstracts database-specific syntax through a common API layer for multiple SQL dialects.

Database Introspection Tools - Performs low-level reflection to discover table structures and constraints across different platforms.

Connection Pool Managers - Manages database connection lifecycles and pooling to optimize resource utilization.

Database Schema Migrations - Includes tools for evolving table structures and columns without losing existing data.

Schema Introspection - Analyzes existing database layouts to dynamically create corresponding model classes.

Database Transaction Management - Controls atomic blocks of work using transactions and savepoints to ensure data integrity.

Document Storage - Provides storage for flexible JSON documents within a traditional relational database system.

Lazy Loading Patterns - Supports deferred loading of foreign key relationships to optimize initial query performance.

Many-to-Many Relationship Managers - Provides specialized support for managing associations between entities through intermediate pivot tables.

Relation Loading Strategies - Implements lazy loading and eager prefetching strategies for fetching associated entity data.

Relational Database Connectors - Provides a comprehensive set of tools for connecting to and performing operations on relational databases.

Schema Generators - Provides utilities to automatically generate model code by scanning existing database schemas.

Database Connectivity Drivers - Interfaces with various database engines using both synchronous and asynchronous drivers.

Database ORMs - Listed in the “Database ORMs” section of the Awesome Python awesome list.

Object Relational Mappers - Small and expressive ORM.

ORM Frameworks - Small, expressive ORM.

coleiferpeewee

Features

Star history