Re:Apache Age: A Graph Extension for PostgreSQL
by ajankelo on Thursday March 04, 2021 @04:19PM
(#26348502)
Fantastic that they are using Cypher. Love that language, if one could say that about a Query language.
[ Parent
| on HN ]
Re:Apache Age: A Graph Extension for PostgreSQL
by hc-taway on Thursday March 04, 2021 @05:07PM
(#26349111)
Cypher's pretty much the only thing about Neo4j that I found to be both pleasant-to-use and... well, any good, really. Love seeing it borrowed by other graphDBs. I'm far from being a SQL hater, but being able to bounce into Cypher to replace (at least some large subset of) recursive CTEs would be a huge developer-experience improvement for PostgreSQL, for multi-model DBs.
Example from the n4j Cypher docs, for the curious:
MATCH (user:User { name: 'Adam' })-[r1:FRIEND]-()-[r2:FRIEND]-(friend_of_a_friend)
RETURN friend_of_a_friend.name AS fofName
Returns names of friends-of-friends (connected with FRIEND-labeled edges) User nodes having the "name" property "Adam". Stuff like "friend_of_a_friend" is set as an alias for the matched nodes, like in SQL. () denotes a node, [] an edge. (It's been a while, so this explanation may be subtly wrong, but it's close)
Re:Apache Age: A Graph Extension for PostgreSQL
by kebman on Thursday March 04, 2021 @08:00PM
(#26350972)
I love Cypher too. And PostgreSQL! I wonder how this project compares to Neo4j.
Re:Apache Age: A Graph Extension for PostgreSQL
by eurasiantiger on Friday March 05, 2021 @04:49AM
(#26354949)
Take a look at OrientDB’s OSQL.
Re:Apache Age: A Graph Extension for PostgreSQL
by simplify on Friday March 05, 2021 @01:29AM
(#26353528)
Agreed, Cypher was the thing I loved most about neo4j.
Re:Apache Age: A Graph Extension for PostgreSQL
by simonebrunozzi on Friday March 05, 2021 @03:26AM
(#26354318)
Ever tried 4GL on IBM? Way worse than most.