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

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

..............2581 F.16. hstore .........................................................................................................................2581 F.16.1. hstore External Representation.. ................................................................2581 F.16.2. hstore Operators and Functions .................................................................2582 F.16.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

.................2440 F.16. hstore ..................................................................................................................2440 F.16.1. hstore External Representation...... .....................................................2440 F.16.2. hstore Operators and Functions ..........................................................2441 F.16.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

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

..................................................................................... 2794 F.16. hstore ................................................................................................ ....................... 2791 F.7. hstore Operators .................................................................................................. 2798 F.8. hstore Functions ....................... json_object('{a,b}', '{1,2}') → {"a": "1", "b": "2"} a For example, the hstore extension has a cast from hstore to json, so that hstore values converted via the JSON creation functions will be represented

fuzzystrmatch .................................................................................. 2647 F.16. hstore ............................................................................................. 2650 ......................... 2645 F.7. hstore Operators ............................................................................................. 2651 F.8. hstore Functions .......................... json_object('{a,b}', '{1,2}') → {"a": "1", "b": "2"} a For example, the hstore extension has a cast from hstore to json, so that hstore values converted via the JSON creation functions will be represented