PostgreSQL module hstore allows to store sets of key/value pairs within a single PostgreSQL value. More about it here.

The HStore Extension contains DBAL type hstore and registers Doctrine type hstore.

To install this library, run the command below and you will get the latest version:

composer require intaro/hstore-extension

If you want to run the tests:

./vendor/bin/phpunit

You can find an example configuration for using HStore extension in Symfony2 in config/hstore.yml. You can just include in you config.yml:

imports:
    - { resource: ../../vendor/intaro/hstore-extension/config/hstore.yml }

To speed up encoding/decoding of strings you can install C extension shipped in ext/hstore directory.

To compile extension you must install php-dev package.

phpize
./configure
make
sudo make install

Finally, enable the extension in your php.ini configuration file:

extension = hstore.so