peewee

Peewee's main goal is to keep size as down as possible, while supporting as many features as possible.

What is new in this release:

• Better support for setting the character encoding on PostgreSQL database connections.
• Improved implementation of get_or_create().

What is new in version 2.6.1:

• Better support for setting the character encoding on PostgreSQL database connections.
• Improved implementation of get_or_create().

What is new in version 2.6.0:

• Better support for setting the character encoding on PostgreSQL database connections.
• Improved implementation of get_or_create().

What is new in version 2.5.1:

• Added support for CAST expressions.
• Added a hook for extending Node with custom methods.
• JOIN_<type> became JOIN.<type>, e.g. .join(JOIN.LEFT_OUTER).
• OP_<code> became OP.<code>.
• Allowed using + and - prefixes to indicate ascending/descending ordering.
• Added Database.initialize_connection() hook.
• Bind selected columns to a particular model.
• Support for swapping databases at run-time via Using.
• Support for SQLCipher and Python3.
• New RowIDField for sqlite_ext playhouse module. This field can be used to interact with SQLite rowid fields.
• Added LateralJoin helper to the postgres_ext playhouse module.
• New example blog app.

What is new in version 2.4.7:

• New and improved documentation
• Added aggregate_rows() method for mitigating N+1 queries.
• Query compiler performance improvements and rewrite of table alias internals.
• Added context-managers and decorators for counting queries and asserting query counts.
• Allow UPDATE queries to contain subqueries for values.
• Support for INSERT INTO / SELECT FROM queries.
• Allow SqliteDatabase to set the database's journal mode.
• Added method for concatenation.
• Moved UUIDField out of the playhouse and into peewee
• Added pskel script.

What is new in version 2.2.4:

• Rewrite of pwiz, schema introspection utility.
• Model.save() returns a value indicating the number of modified rows.
• Fixed bug with PostgresqlDatabase.last_insert_id() leaving a transaction open in autocommit mode.
• Added BM25 ranking algorithm for full-text searches with SQLite.