the database 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 SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table

Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and

tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Management Connection Pooling Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options, use: python runtests MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install the HStore extension in the postgres test database: -- install the hstore extension

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options, use: python runtests MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install the HStore extension in the postgres test database: -- install the hstore extension

tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What next? Example app Running the example Diving into the code Recursion Database Initializing a Database Using Postgresql Using SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Management Connection Pooling Testing Peewee Applications Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options, use: python runtests MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install the HStore extension in the postgres test database: -- install the hstore extension

the database 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 SQLite Using MySQL Connecting using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.5 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options, use: python runtests MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install the HStore extension in the postgres test database: -- install the hstore extension

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 Run-time database configuration defining a database Connection Pooling Read Slaves Schema migrations Generating Models from Existing Databases Adding Request Hooks Additional connection initialization Advanced Connection Management Using 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