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
• python 2.7+ and 3.4+ (developed with 3.6)
• supports sqlite, mysql, postgresql and cockroachdb
• 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
  • Optional dependencies
  • Note on the SQLite extensions
• 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 CockroachDB
  • Using SQLite
  • Using MySQL
  • Connecting using a Database URL
  • Run-time database configuration
  • Dynamically defining a database
  • Setting the database at run-time
  • Thread-Safety and Multiple Databases
  • Connection Management
  • Connection Pooling
  • Testing Peewee Applications
  • Async with Gevent
  • Framework Integration
  • Executing Queries
  • Managing Transactions
  • Database Errors
  • 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
  • Additional Features
• Playhouse, extensions to Peewee
  • Sqlite Extensions
  • 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
• Changes in 3.0
  • Backwards-incompatible
  • New stuff

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