Ask HN: Why are relational DBs are the standard instead of graph-based DBs?

Re:Ask HN: Why are relational DBs are the standard instead o... by angelzen on Sunday October 03, 2021 @10:01AM (#28737199)

Would be nice though to have an example that does demonstrate the power of Cypher.

[ Parent | on HN ]

Re:Ask HN: Why are relational DBs are the standard instead o... by clpm4j on Sunday October 03, 2021 @10:34AM (#28737479)

SELECT p.ProductName FROM Product AS p JOIN ProductCategory pc ON (p.CategoryID = pc.CategoryID AND pc.CategoryName = "Dairy Products")

JOIN ProductCategory pc1 ON (p.CategoryID = pc1.CategoryID) JOIN ProductCategory pc2 ON (pc1.ParentID = pc2.CategoryID AND pc2.CategoryName = "Dairy Products")

JOIN ProductCategory pc3 ON (p.CategoryID = pc3.CategoryID) JOIN ProductCategory pc4 ON (pc3.ParentID = pc4.CategoryID) JOIN ProductCategory pc5 ON (pc4.ParentID = pc5.CategoryID AND pc5.CategoryName = "Dairy Products");

-----------------------------------------------

MATCH (p:Product)-[:CATEGORY]->(l:ProductCategory)-[:PARENT*0..]->(:ProductCategory {name:"Dairy Products"}) RETURN p.name

[ Parent | on HN ]

Re:Ask HN: Why are relational DBs are the standard instead o... by somewhereoutth on Sunday October 03, 2021 @05:18PM (#28740586)

So basically allow 'named joins' in SQL and we are done.

[ Parent | on HN ]