Top "Hstore" questions

hstore is data type for storing sets of key/value pairs in Postgres, similar to hashes in Ruby and Perl, associative arrays in PHP or dictionaries in Python.

Storing nested Hashes in PostgreSQL with Rails 4 (and Hstore)

I have a Rails app that aggregates a lot of data from Google API's. I store the JSON responses in …

Read More
ruby-on-rails postgresql ruby-on-rails-4 hstore
Rails/postgres: What is the best way to store list of phone numbers for one user

So I am little confused on how to store a list of phone numbers in one column. Here are the …

Read More
ruby-on-rails postgresql activerecord hstore
Missing hstore extension

I am running postgresql-9.5.3 and I tried to create extension: CREATE EXTENSION IF NOT EXISTS hstore; but I got this …

Read More
postgresql hstore
Rails 4 + PostgreSQL hstore, can't execute "CREATE EXTENSION hstore"

I have RubyOnRails 4.1.4 and PostgreSQL installed on my MacOS X by: brew install postgresql When I'm trying to migrate this …

Read More
ruby-on-rails postgresql rvm pg hstore