Schemaless SQL — The Best of Both Worlds

A session at RailsConf 2012

Tuesday 24th April, 2012

1:30pm to 2:15pm (CST)

Schemaless database are a joy to use because they make it easy to iterate on your app, especially early on. And to be honest, the relational model isn't always the best fit for real-world evolving and messy data.

On the other hand, relational databases are proven, robust, and powerful. Also, over time as your data model stabilizes, the lack of well-defined schemas becomes painful.

How are we supposed to pick one or the other? Simple: pick both. Fortunately recent advances in Postgres allow for a hybrid approach that we've been using at Heroku. The hstore datatype gives you key/value in a single column, and PLV8 enables JavaScript and JSON in Postgres. These and others in turn make Postgres the best document database in the world.

We will explore the power of hstore and PLV8, explain how to use them in your project today, and examine their role in the future of data.

About the speaker

This person is speaking at this event.
Will Leinweber


As a member of Heroku's incomparable Department of Data, Will runs the world's largest Postgres service. He enjoys improving experiences, pushing boundaries, and simplifying everything.

Next session in Salon K

2:30pm Evented Ruby vs Node.js by Jerry Cheung

Coverage of this session

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 1:30pm2:15pm CST

Date Tue 24th April 2012


Salon K, Hilton Austin Downtown

Short URL


Official session page


View the schedule



See something wrong?

Report an issue with this session