.................2344 F.15. hstore ..................................................................................................................2344 F.15.1. hstore External Representation...... .....................................................2344 F.15.2. hstore Operators and Functions ..........................................................2345 F.15.3. Indexes ........................ individual value converted by the other JSON creation functions. Note: The hstore extension has a cast from hstore to json, so that hstore values converted via the JSON creation functions will be represented

..............2487 F.15. hstore .........................................................................................................................2487 F.15.1. hstore External Representation.. ................................................................2487 F.15.2. hstore Operators and Functions .................................................................2488 F.15.3. Indexes ...... individual value converted by the other JSON creation functions. Note: The hstore extension has a cast from hstore to json, so that hstore values converted via the JSON creation functions will be represented

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: