Menu

Recent Posts

Optimizing a Big RethinkDB Query, and a Correction

Yesterday I wrote a post about how much I liked RethinkDB and people seemed to like it a lot. Particularly the claim I made about optimizing a fuzzy text search over 200,000 records down to 9ms. That claim was wrong. I’ll walk through the various bubble and squeak below, but for now know that a) […]

RethinkDB 2.0 Is Amazing

I just turned in my next course for Pluralsight: RethinkDB Fundamentals – almost in time for their announcement that 2.0 has been released. This is very exciting – it’s a “production-ready” release which means that all the work they’ve done over the last 3+ years is ready to go, and it’s mind-blowing. Dabbling I have […]

Tree structure query with PostgreSQL

When dealing with hierarchical data, we usually use recursion for constructing the tree structure. It would be a performance problem if you query the tree node data from the database every time the recursion happens. Also, if you work with languages which are heavily based on callback like Javascript, you will find it is very […]

© 2015 All rights reserved. | Home | Top