News for hackers. Stuff that matters.
Re:Graphs in the database: SQL meets social networks by nikcub on Friday March 16, 2012 @08:26AM (#3712986)
Twitter does this. Flockdb is built ontop of an RDBMS

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.)

Re:Graphs in the database: SQL meets social networks by einhverfr on Friday March 16, 2012 @09:20AM (#3713144)
I 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.......
Re:Graphs in the database: SQL meets social networks by PaulHoule on Friday March 16, 2012 @09:03AM (#3713094)
Neo4J 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.