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

• 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 hosted 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; 1.1.3 Optional dependencies Note: import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see:

• 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 hosted 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; 1.1.3 Optional dependencies Note: import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) 1.6. Database 39 peewee Documentation, Release 3

• 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 hosted 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; 1.1.3 Optional dependencies Note: 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; 1.1.3 Optional dependencies Note: import PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: 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

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: