Schemaless SQL — The Best of Both Worlds

A session at MountainWest RubyConf 2012

Friday 16th March, 2012

1:30pm to 2:00pm (MST)

Schemaless database are a joy to use because they make it easy to iterate on your app, especially early on. The relational model isn't always the best fit for evolving and messy data in the real world. And let's be honest—it's painful to persist rich domain models across millions of little tables. However as your data model stabilizes, the lack of well-defined schemas becomes painful. On the other hand, relational databases are proven, robust, and powerful. How are we supposed to pick one or the other? Simple: pick both.

Recent advances in Postgres allow for a new hybrid approach. The hstore datatype brings key/value pairs to Postgres, and PLV8 embeds the super-fast V8 JavaScript engine into Postgres. These in turn make Postgres the best document database in the world. This talk will explore when and how to take advantage of them, and how we use these techniques at Heroku.

About the speaker

This person is speaking at this event.
Will Leinweber

i dont want the world, i just want your half bio from Twitter

Coverage of this session

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

Tell your friends!


Time 1:30pm2:00pm MST

Date Fri 16th March 2012

Short URL


View the schedule



See something wrong?

Report an issue with this session