peewee

Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use.

• a small, expressive ORM

• flexible query-builder that exposes full power of SQL

• supports sqlite, mysql, mariadb, postgresql.

• asyncio support

• tons of extensions

Peewee’s source code hosted on GitHub.

New to peewee? These may help:

• Quickstart

• Example twitter app

• Using peewee interactively

• Models and fields

• Querying

• Relationships and joins

Contents:

• Installing and Testing
  • Installing with git
  • Running tests
  • Driver support
• Quickstart
  • Model Definition
  • Storing data
  • Retrieving Data
  • Database
  • What next?
• Example app
  • Running the example
  • Diving into the code
  • More examples
• Using Peewee Interactively
• Contributing
  • Patches
  • Bugs
  • Questions
• Database
  • Initializing a Database
  • Using Postgresql
  • Using SQLite
  • Using MariaDB
  • Using MySQL
  • Connecting using a Database URL
  • Run-time database configuration
  • Connection Management
  • Connection Pooling
  • Executing Queries
  • Managing Transactions
  • Database Errors
  • Testing Peewee Applications
  • Async with Gevent
  • AsyncIO
  • Framework Integration
  • Logging queries
  • Adding a new Database Driver
• Models and Fields
  • Fields
  • Creating model tables
  • Model options and table metadata
  • Indexes and Constraints
  • Primary Keys, Composite Keys and other Tricks
  • Self-referential foreign keys
  • Circular foreign key dependencies
• Querying
  • Creating a new record
  • Bulk inserts
  • Updating existing records
  • Atomic updates
  • Deleting records
  • Selecting a single record
  • Create or get
  • Selecting multiple records
  • Filtering records
  • Sorting records
  • Getting random records
  • Paginating records
  • Counting records
  • Aggregating records
  • Retrieving Scalar Values
  • Window functions
  • Retrieving row tuples / dictionaries / namedtuples
  • Returning Clause
  • Common Table Expressions
  • Foreign Keys and Joins
• Query operators
  • Three valued logic
  • Adding user-defined operators
  • Expressions
  • SQL Functions
  • SQL Helper
  • Security and SQL Injection
• Relationships and Joins
  • Model definitions
  • Performing simple joins
  • Joining multiple tables
  • Selecting from multiple sources
  • Subqueries
  • Multiple foreign-keys to the same Model
  • Joining on arbitrary fields
  • Self-joins
  • Implementing Many to Many
  • Avoiding the N+1 problem
• API Documentation
  • Database
  • Query-builder
  • Fields
  • Schema Manager
  • Model
  • Query-builder Internals
  • Constants and Helpers
• SQLite Extensions
  • Getting started
  • APIs
• cysqlite Extension
  • CySqliteDatabase
• Asyncio Support
  • Supported Backends
  • Installation
  • Overview
  • Connections and Pooling
  • Transactions
  • Implementation Notes
  • Sharp Corners
  • API
• Playhouse, extensions to Peewee
  • SqliteQ
  • Sqlite User-Defined Functions
  • apsw, an advanced sqlite driver
  • Sqlcipher backend
  • Postgresql Extensions
  • Cockroach Database
  • MySQL Extensions
  • DataSet
  • Fields
  • Hybrid Attributes
  • Key/Value Store
  • Shortcuts
  • Signal support
  • pwiz, a model generator
  • Schema Migrations
  • Reflection
  • Database URL
  • Connection pool
  • Test Utils
  • Flask Utils
• Query Examples
  • Model Definitions
  • Schema Creation
  • Basic Exercises
  • Joins and Subqueries
  • Modifying Data
  • Aggregation
  • Recursion
• Query Builder
  • Declaring tables
  • Select queries
  • Insert queries
  • Update queries
  • Delete queries
  • Query Objects
  • More
• Hacks
  • Optimistic Locking
  • Top object per group
  • Top N objects per group
  • Writing custom functions with SQLite
  • Date math

Note

If you find any bugs, odd behavior, or have an idea for a new feature please don’t hesitate to open an issue on GitHub or contact me.

Indices and tables

• Index

• Module Index

• Search Page