Over a million developers have joined DZone.

Heroku's HStore Promotes Faster Querying in PostgreSQL

· Cloud Zone

Download this eBook outlining the critical components of success for SaaS companies - and the new rules you need to play by.  Brought to you in partnership with NuoDB.

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.  


Learn how moving from a traditional, on-premises delivery model to a cloud-based, software-as-a-service (SaaS) strategy is a high-stakes, bet-the-company game for independent software vendors. Brought to you in partnership with NuoDB.


Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

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