3 ms·
Twitter does this. Flockdb is built ontop of an RDBMS http://github.com/twitter/flockdb http://github.com/twitter/flockdb the downside is that unlike a proper
by nikcub 15y ago
Twitter does this. Flockdb is built ontop of an RDBMS
http://github.com/twitter/flockdb http://github.com/twitter/flockdb
the downside is that unlike a proper graph database (such as neo4j) you can only query a single hop per SQL query (which is fine for twitter, since there is no requirement for 'followers of followers' etc.)
- PaulHoule 15y agoNeo4J is proper? What I see is that Neo4J attracts noobs and leaves behind a trail of tears and failed projects. Something like OWLIM or Virtuoso Open Link handles databases that are 20x bigger.
- einhverfr 15y agoI thought their use of WITH RECURSIVE in the demos on the article linked was interesting. It should allow you to recurse to an arbitrary depth. The only problem there is that if you don't set a max depth in your recursive query and you have a closed cycle.... you might end up with an infinite loop.......