Peewee

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 Clients - Small, expressive ORM for multiple SQL databases.
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.

Open-source alternatives to Peewee

Similar open-source projects, ranked by how many features they share with Peewee.

sqlalchemy/sqlalchemy
sqlalchemy/sqlalchemy
11,612View on GitHub
SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a
Pythonpythonsqlsqlalchemy
View on GitHub11,612
dotnet/efcore
dotnet/efcore
14,587View on GitHub
Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a
C#aspnet-productc-sharpdatabase
View on GitHub14,587
dapperlib/dapper
DapperLib/Dapper
18,331View on GitHub
Dapper is a lightweight object-relational mapper for .NET that functions as a high-performance data access library. It operates by extending standard database connection interfaces, allowing developers to execute raw SQL queries while automating the mapping of database results to strongly-typed objects. The library distinguishes itself through its use of runtime code generation, which creates high-performance instructions to map database rows to object properties with minimal overhead. It provides flexible data retrieval options, supporting both memory-buffered loading for speed and row-by-ro
C#ado-netdappersql
View on GitHub18,331
fastapi/sqlmodel
fastapi/sqlmodel
18,137View on GitHub
SQLModel is a type-safe object-relational mapping library for Python that integrates database schema definitions with data validation logic. By combining these two roles into a single class, it allows developers to manage relational data structures and enforce data integrity for web APIs simultaneously. The framework is built to support asynchronous database operations, enabling high-performance applications to execute queries and transactions without blocking the main execution thread. The library distinguishes itself by leveraging Python type hints to provide IDE autocompletion and compile-
Pythonfastapijsonjson-schema
View on GitHub18,137

See all 30 alternatives to Peewee

coleiferpeewee

Features

Open-source alternatives to Peewee

sqlalchemy/sqlalchemy

dotnet/efcore

DapperLib/Dapper

fastapi/sqlmodel

Star history

Open-source alternatives to Peewee

sqlalchemy/sqlalchemy

dotnet/efcore

DapperLib/Dapper

fastapi/sqlmodel