records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query Autocommit Mode Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql Extensions DataSet Types Misc Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

with two C extensions that can optionally be compiled: • Speedups, which includes miscellaneous functions re-implemented with Cython. This module will be built automatically if Cython is installed. • Sqlite Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. This module should be built using run: 3 peewee Documentation, Release 2.10.2 # Build the sqlite extension and place the shared library alongside the other modules. python setup.py build_sqlite_ext -i Note: On some systems you may need

records Paginating records Counting records Aggregating records Retrieving Scalar Values Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Foreign Keys and Joins Implementing Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes queries More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text Optional dependencies Note: To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use with APSWDatabase. • gevent is an optional dependency for SqliteQueueDatabase (though

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text Optional dependencies Note: To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use with APSWDatabase. • gevent is an optional dependency for SqliteQueueDatabase (though

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 Additional Features Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text Optional dependencies Note: To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use with APSWDatabase. • gevent is an optional dependency for SqliteQueueDatabase (though