HStore Lightning Talk

The lightning talk I did at the May 1st, 2012 Dallas Ruby Brigade about HStore.

Transcript

1. Yo dawg... I put NoSQL in your SQL Tuesday, May 1, 12
2. Yo dawg... I put NoSQL in your SQL So you can SQL while you NoSQL Tuesday, May 1, 12
3. NoSQL N(ot) O(nly) SQL MongoDB (document store) Redis (Key-Value) Couch (Key-Value) Tuesday, May 1, 12
4. I don’t need a full NoSQL solution Can’t I just put a hash in my RDBMS? Tuesday, May 1, 12
5. I don’t need a full NoSQL solution Can’t I just put a hash in my RDBMS? Tuesday, May 1, 12
6. If you’re going to tell me to marshal... • Marshal.dump • Marshal.load Tuesday, May 1, 12
7. If you’re going to tell me to marshal... • Marshal.dump • Marshal.load Tuesday, May 1, 12
8. If you’re going to tell me to marshal... • Marshal.dump • Marshal.load Tuesday, May 1, 12
9. NoSQL is hard...let’s go shopping • A full NoSQL DB is another tech to learn • A full NoSQL DB is another server to maintain • What do you need to do that would benefit from lack of a schema? Tuesday, May 1, 12
10. Shop smart! Tuesday, May 1, 12
11. HStore In Postgres-contrib 9.0 Column type Indexable Tuesday, May 1, 12
12. Operators Source: http://www.postgresql.org/docs/9.0/static/ hstore.html#AEN123107 Tuesday, May 1, 12
13. How to use this in Ruby gem install ‘activerecord-postgres-hstore’ Store hashes in a column hstore type in AR migrations Performance! Tuesday, May 1, 12
14. How to use this in Ruby gem install ‘activerecord-postgres-hstore’ Store hashes in a column hstore type in AR migrations Performance! Tuesday, May 1, 12
15. Tuesday, May 1, 12
16. Watch out! • Not a full NoSQL store, cannot do atomic operations (upsert, increment, etc.) • Must re-set the whole hash (using the gem) • model.hstore_col = { :foo => ‘bar’} • To access values in Ruby I had to call #symbolize_keys! • model.hstore_col.symbolize_keys! Tuesday, May 1, 12
17. THANKS! Jesse Dearing @JesseDearing Tuesday, May 1, 12