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 Context manager Decorator Nesting Transactions Explicit transaction Autocommit Mode Changes in 3.0 Backwards-incompatible New stuff API Documentation Database Query-builder Fields Schema Manager Model

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 Context manager Decorator Nesting Transactions Explicit transaction Autocommit Mode Changes in 3.0 Backwards-incompatible New stuff API Documentation Database Query-builder Fields Schema Manager Model

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 Context manager Decorator Nesting Transactions Explicit transaction Autocommit Mode Changes in 3.0 Backwards-incompatible New stuff API Documentation Database Query-builder Fields Schema Manager Model

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') class using the singular form. There are lots of field types suitable for storing various types of data. Peewee handles converting between pythonic values those used by the database, so you can use Python

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') class using the singular form. There are lots of field types suitable for storing various types of data. Peewee handles converting between pythonic values those used by the database, so you can use Python

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 Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions Context manager Decorator Nesting Transactions Explicit transaction Autocommit Mode Playhouse, extensions to Peewee 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

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 Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional 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

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') class using the singular form. There are lots of field types suitable for storing various types of data. Peewee handles converting between pythonic values those used by the database, so you can use Python

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') class using the singular form. There are lots of field types suitable for storing various types of data. Peewee handles converting between pythonic values those used by the database, so you can use Python

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 Implementing Many to Many Avoiding the N+1 problem API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional 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