learn and intuitive to use. A small, expressive ORM 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 Django Integration Fields Generic foreign keys Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL CSV Utils Connection pool Read anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

and intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.6+ and 3.2+. • built-in support for sqlite, mysql and postgresql • numerous extensions available (postgres anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s

intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions 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 anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions 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 anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s

intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s

lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses support for special extensions like hstore [http://peewee.readthedocs.org/en/latest/peewee/playhouse.ht an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices and tables Index Module Index Search also share a connection across threads natively, so if you would prefer to use sqlite’s native support: native_concurrent_db = SqliteDatabase('stats.db', check_same_thread=False) Deferring initialization

intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s

learn and intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

querying interface over sql • uses sql concepts when querying, like joins and where clauses • support for special extensions like hstore and full-text search For flask integration, including an admin can also share a connection across threads natively, so if you would prefer to use sqlite’s native support: native_concurrent_db = SqliteDatabase(’stats.db’, check_same_thread=False) Deferring initialization The generated code is written to stdout. 1.3.5 Schema migrations Currently peewee does not have support for automatic schema migrations. Peewee does, however, come with a few helper functions: 14 Chapter