(developed with 3.6) supports sqlite, mysql and postgresql tons of extensions Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? These may help: Quickstart Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using 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

Peewee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 1.13 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253 1 (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: • Quickstart • Example twitter app • Models and framework. In the projects examples/ folder you can find more self-contained Peewee examples, like a blog app. I strongly recommend opening an interactive shell session and running the code. That way you can get

Peewee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 1.12 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 1 (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. 1.2.1 Model Definition Model classes, fields

hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents Working with existing databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Database Initializing a Database Using Postgresql Using 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1 (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. 1.2.1 Model Definition Model classes, fields

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1 (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. 1.2.1 Model Definition Model classes, fields

hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. Model Definition Model classes, fields and model

hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. Model Definition Model classes, fields and model

hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents Working with existing databases What next? Example app Running the example Diving into the code More examples Additional Resources Contributing Patches Bugs Questions Managing your Database Creating Management Using multiple databases Database Errors Automatic Reconnect Logging queries Generating skeleton code Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table

hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents databases What next? Example app Running the example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries and the Flask framework. I strongly recommend opening an interactive shell session and running the code. That way you can get a feel for typing in queries. Model Definition Model classes, fields and model