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 metadata

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.6 Managing your Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.7 Models build_sqlite_ext -i Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. 1.1.2 Running tests You can test your installation by running the test suite. python setup py test # Or use the test runner: python runtests.py You can test specific features or specific database drivers using the runtests.py script. By default the test suite is run using SQLite and the playhouse

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 Connection 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 and

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 Connection with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Field-naming conflicts Creating model tables

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 Connection Applications 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

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 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would like to build the SQLite extension in a git checkout, you can run: # Build 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would like to build the SQLite extension in a git checkout, you can run: # Build 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

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 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would like to build the SQLite extension in a git checkout, you can run: # Build 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