records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes queries More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

records Paginating records Counting records Aggregating records Retrieving Scalar Values Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Foreign Keys and Joins Implementing Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet

records Paginating records Counting records Aggregating records Retrieving Scalar Values Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Common Table Expressions Foreign Keys and Joins Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection Relationships and Joins Model definitions Performing simple Additional Features Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text print(' *', pet.name) # prints: # Bob # * Kitty # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an session when a user successfully logs in. The decorator login_required can be used to wrap view functions, checking for whether the session is authenticated and if not redirecting to the login page. def

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text print(' *', pet.name) # prints: # Bob # * Kitty # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an session when a user successfully logs in. The decorator login_required can be used to wrap view functions, checking for whether the session is authenticated and if not redirecting to the login page. def

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text print(' *', pet.name) # prints: # Bob # * Kitty # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an session when a user successfully logs in. The decorator login_required can be used to wrap view functions, checking for whether the session is authenticated and if not redirecting to the login page. def

which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text print(' *', pet.name) # prints: # Bob # * Kitty # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an session when a user successfully logs in. The decorator login_required can be used to wrap view functions, checking for whether the session is authenticated and if not redirecting to the login page. def

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query Autocommit Mode Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql Extensions DataSet Types Misc Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please