Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Working with existing databases What next? Example app Running the example Diving into the particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use high-level overview of Peewee’s primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating

boost to certain operations, particularly if you use SQLite. • apsw: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 2.10.2 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating Row in a database table When starting a project with peewee, it’s typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db')

Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use

Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use

boost to certain operations, particularly if you use SQLite. • apsw: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.4.0 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating Row in a database table When starting a project with peewee, it’s typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db')

boost to certain operations, particularly if you use SQLite. • apsw: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.3.0 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating Row in a database table When starting a project with peewee, it’s typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db')

Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the 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 particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use

boost to certain operations, particularly if you use SQLite. • apsw: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.5.0 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating Row in a database table When starting a project with peewee, it’s typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db')

Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and much, much saner semantics than the standard library pysqlite. Use

dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the 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 particularly if you use SQLite. apsw [https://github.com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and comprehensive support for SQLite’s C APIs. Use with APSWDatabase