Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded applications Run-time database configuration Dynamically defining a database Connection Pooling Read Slaves Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions 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 with APSWDatabase. pycrypto

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 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 with APSWDatabase. • pycrypto you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. I strongly recommend opening an interactive shell session

configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Queries Managing Transactions Database Errors dictionaries / namedtuples Returning Clause Foreign Keys and Joins Implementing Many to Many Self-joins Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions 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 with APSWDatabase. gevent

configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Queries Managing Transactions Database Errors Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions 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 with APSWDatabase. gevent

configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions 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 with APSWDatabase. sweepea

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 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 with APSWDatabase. • gevent you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. I strongly recommend opening an interactive shell session

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 1.11 Performance Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 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 with APSWDatabase. • gevent you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. I strongly recommend opening an interactive shell session

configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Queries Managing Transactions Database Errors 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. gevent [http://www.gevent you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. In the projects examples/ folder you can find more self-contained

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 with APSWDatabase. • gevent you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. I strongly recommend opening an interactive shell session first query is executed. It is also good to close the connection when you are done – for instance, a web app might open a connection when it receives a request, and close the connection when it sends the

Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over lots of rows Speeding up Bulk Inserts Transactions 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 with APSWDatabase. sweepea you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app using peewee and the Flask framework. I strongly recommend opening an interactive shell session