2486 F.14.4. Double Metaphone ..... 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 Examples To update the hstore extension to version 2.0: ALTER EXTENSION hstore UPDATE TO '2.0'; To change the schema of the hstore extension to utils: ALTER EXTENSION hstore SET SCHEMA util; To

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 • Playhouse, a collection of addons • apsw, an advanced sqlite driver ○ Postgresql Extensions (hstore, ltree) • pwiz, a model generator ☐ Signal support ☐ Slite Extensions Swee'pea, syntactic 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

• Built-in support for SQLite, MySQL and Postgresql. - numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). . db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions

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; 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

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; 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:

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; 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). . db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions

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: 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

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 PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions 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

• Built-in support for SQLite, MySQL and Postgresql. - numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). . db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions