a small, expressive ORM python 2.7+ and 3.4+ (developed with 3.6) supports sqlite, mysql and postgresql tons of extensions Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee] code More examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support

Written in python with support for versions 2.6+ and 3.2+. built-in support for sqlite, mysql and postgresql numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations Patches Bugs Questions Managing your Database Creating a database connection and tables Using Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded applications Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql Extensions DataSet Django Integration Fields Generic foreign keys Hybrid Attributes Key/Value Store

support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations essentials. It will take you between 5 and 10 minutes to go through it. Example queries taken from the PostgreSQL exercises website [https://pgexercises.com]. Guide to the various query operators describes how Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically

support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations code More examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support

Written in python with support for versions 2.7+ and 3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Shortcuts Signal support pwiz, a model generator Schema

support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations essentials. It will take you between 5 and 10 minutes to go through it. Example queries taken from the PostgreSQL exercises website [https://pgexercises.com]. Guide to the various query operators describes how Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically

small, expressive ORM • python 2.7+ and 3.4+ (developed with 3.6) • supports sqlite, mysql and postgresql • tons of extensions Peewee’s source code hosted on GitHub. New to peewee? These may help: models using pwiz, a model generator. For instance, if I have a postgresql database named charles_blog, I might run: python -m pwiz -e postgresql charles_blog > blog_models.py 1.2.6 What next? That’s it , user='postgres', register_hstore=True) For more information on database extensions, see: • Postgresql Extensions • SQLite Extensions • Sqlcipher backend • apsw, an advanced sqlite driver • SqliteQ

Written in python with support for versions 2.6+ and 3.2+. • built-in support for sqlite, mysql and postgresql • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema models using pwiz, a model generator. For instance, if I have a postgresql database named charles_blog, I might run: python -m pwiz -e postgresql charles_blog > blog_models.py 1.2.5 What next? That’s it Peewee will pass back unrecognized parameters directly to the database driver. For instance, with Postgresql it is common to need to specify the host, user and password when creating your connection. These

support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema It will take you between 5 and 10 minutes to go through it. • Example queries taken from the PostgreSQL exercises website. • Guide to the various query operators describes how to construct queries and models using pwiz, a model generator. For instance, if I have a postgresql database named charles_blog, I might run: python -m pwiz -e postgresql charles_blog > blog_models.py 1.2.6 What next? That’s it

support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema models using pwiz, a model generator. For instance, if I have a postgresql database named charles_blog, I might run: python -m pwiz -e postgresql charles_blog > blog_models.py 1.2.6 What next? That’s it , user='postgres', register_hstore=True) For more information on database extensions, see: • Postgresql Extensions • SQLite Extensions • Sqlcipher backend • apsw, an advanced sqlite driver • SqliteQ