Look Who it Was Random video

Wicked Good Ruby 2013 - Supercharging ActiveRecord with PostreSQL

2,360 views · Published 31 October 2013 · 22:57 · Indexed 12 November 2026

Channel: Confreaks · 2013 · Science & Technology

Watch on YouTube

By Dan McClain

You've been able to serialize Ruby objects with ActiveRecord in the past, but the database treats serialized objects as text. PostgreSQL has support for advanced data types, like arrays, hashes and ranges, natively, allowing the database to do the heavy work for you. You can query a table for records that contain an array with a specific element. You can build a reservation system in which the database makes sure that you don't double book a room. All of which happens in the database, preventing you from retrieving extra records and processing them in memory.

With Rails 4, ActiveRecord has been supercharged. The PostgreSQL adapter has been extended to support arrays and hashes, and was rewritten to make adding your own types easier than before. There are gems out there that allow you to leverage these datatypes in Rails 3 as well.

Help us caption & translate this video!

http://amara.org/v/FG6d/

More from this channel