Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Heroku's HStore Promotes Faster Querying in PostgreSQL

DZone's Guide to

Heroku's HStore Promotes Faster Querying in PostgreSQL

· Cloud Zone
Free Resource

MongoDB Atlas is a database as a service that makes it easy to deploy, manage, and scale MongoDB. So you can focus on innovation, not operations. Brought to you in partnership with MongoDB.

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.  

 

MongoDB Atlas is the best way to run MongoDB on AWS — highly secure by default, highly available, and fully elastic. Get started free. Brought to you in partnership with MongoDB.

Topics:

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
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.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}