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