Over a million developers have joined DZone.

Heroku's HStore Promotes Faster Querying in PostgreSQL

DZone's Guide to

Heroku's HStore Promotes Faster Querying in PostgreSQL

· Cloud Zone
Free Resource

Deploy and scale data-rich applications in minutes and with ease. Mesosphere DC/OS includes everything you need to elastically run containerized apps and data services in production.

Heroku recently released hstore, a seamless key value pair that can be used in Rails 4.  This tool is used in the relational database PostgreSQL.  The creator compares this to hashes in Ruby.  Since hstore is a native data type, it promotes faster querying.  According to the video's creator, you'll need the most recent copy of Postgres in order to use this.  He also provides you with a walkthrough of the hstore demo provided by Heroku.  

You can find all the code necessary for getting started by heading over to Sheems blog.  


Discover new technologies simplifying running containers and data services in production with this free eBook by O'Reilly. Courtesy of Mesosphere.


Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}