I recently just made what I think is a pretty neat pattern for reporting on a project that we need time series data calculations for.<p>Essentially I already have a giant precalculation service for all the needed calculations on all the data underneath a parent entity. So, I serialize that using ruby marshall and then use lz4 to compress it before storing to db.<p>Its actually faster and smaller than using json strings in ruby. The whole tree structure for each entity was 200-400k as raw json strings. It took something like 300ms to serialize to json. I was able to do the ruby marshal and the LZ4 HC compression in something like 20-40ms and it drops the size down to more like 15-30k.<p>JSON is a pretty cool format, but it's a lot slower in ruby than you might realize and it takes up a lot of space.
Thanks for posting this. For what it's worth, I'm the author of this talk and the one pictured in the video.<p>I'm flattered it's getting so much attention (I like having my ideas spread!), although there's one thing that confuses me. I've never heard of Hakka Labs, nor did I post the talk, video, or my bio on their site (although their treatment sure looks like I did) -- as far as I can tell, they grabbed it from the site of the SFRails Meetup at which I gave it and posted it online. I'm grateful for the exposure, but some notification or clear notice that I'm not affiliated with Hakka Labs (whatever/whoever they are) would have been nice.
The Memcache plugin in MySQL 5.6 provides a neat way to do NoSQL into RDBMS storage: <a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.html</a>
For any that are interested, Couchbase Mobile is essentially, in its current form, a NoSQL database in SQLite. They might port to ForestDB in the future though, but that's an implementation detail.
It's always interesting to observe my bad developer practices (such as stuffing JSON in SQL table columns) become flexible "architectural patterns" for building "schema-free, scalable data storage".