where clauses support for special extensions like hstore [http://peewee.readthedocs.org/en/latest/peewee/playhouse.html#postgresql-extensions-hstore-ltree] and full-text search [http://peewee.readthedocs subclasses Playhouse, a collection of addons apsw, an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee this virtual table Postgresql Extensions (hstore, ltree) The postgresql extensions module provides a number of “postgres-only” functions, including: hstore support ltree support Warning In order to

with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code you will also want to install the HStore extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see:

with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code you will also want to install the HStore extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see:

with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code you will also want to install the HStore extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see:

you will also want to install the HStore extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: contains a Postgresql extension module which provides many postgres-specific features such as: Arrays HStore JSON Server-side cursors And more! If you would like to use these awesome features, use the PostgresqlExtDatabase

3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code you will also want to install the HStore extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see:

and 3.2+. built-in support for sqlite, mysql and postgresql numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more). Peewee’s source code contains a Postgresql extension module which provides many postgres-specific features such as: Arrays HStore JSON Server-side cursors And more! If you would like to use these awesome features, use the PostgresqlExtDatabase register_fields({'uuid': 'uuid'}) That is it! Some fields may support exotic operations, like the postgresql HStore field acts like a key/value store and has custom operators for things like contains and update. You

in your INSTALLED_APPS. 2. Setup the hstore extension in PostgreSQL. You’ll see an error like can't adapt type 'dict' if you skip the first step, or type "hstore" does not exist if you skip the second need to use the hstorefield.contains lookup instead. Warning Since any string could be a key in a hstore value, any lookup other than those listed below will be interpreted as a key lookup. No errors are database using a migration file. This example creates an hstore extension, but the same principles apply for other extensions. Set up the hstore extension in PostgreSQL before the first CreateModel or

in your INSTALLED_APPS. 2. Setup the hstore extension in PostgreSQL. You’ll see an error like can't adapt type 'dict' if you skip the first step, or type "hstore" does not exist if you skip the second need to use the hstorefield.contains lookup instead. Warning Since any string could be a key in a hstore value, any lookup other than those listed below will be interpreted as a key lookup. No errors are database using a migration file. This example creates an hstore extension, but the same principles apply for other extensions. Set up the hstore extension in PostgreSQL before the first CreateModel or

in your INSTALLED_APPS. 2. Setup the hstore extension in PostgreSQL. You’ll see an error like can't adapt type 'dict' if you skip the first step, or type "hstore" does not exist if you skip the second need to use the hstorefield.contains lookup instead. Warning Since any string could be a key in a hstore value, any lookup other than those listed below will be interpreted as a key lookup. No errors are database using a migration file. This example creates an hstore extension, but the same principles apply for other extensions. Set up the hstore extension in PostgreSQL before the first CreateModel or