Apache AGE, a PostgreSQL extension with graph database functionality
1–10 of 77 posts
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#2What subset of the openCypher dialect specification will Apache Age support?
Every implementation is all over the place and completely non-portable. And neo4j performance leaves much to be desired.
My personal go-to is RedisGraph paired with RedisInsight for the instant visualizations. It just feels "right" and, while not perfect, is overall intuitive.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#3What subset of the openCypher dialect specification will Apache Age support? Every implementation is all over the place and completely non-portable. And neo4j performance leaves much to be desired. My personal go-to is RedisGraph paired with RedisInsight for the instant visualizations. It just feels "right" and, while not perfect, is overall intuitive.
I've been following RedisGraph with great interest since I first heard about it. Fell in love with cypher but not a big fan of neo4j. Most recently I've been playing with EdgeDB (not cypher-based) which scratches my graphDB itch pretty well but it's still a little too early for me to consider adopting it in a serious project.
I'm glad there seems to be continued interest in graphDBs, I think there's a lot of potential in that space and I'm eagerly awaiting a clear winner to emerge.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#4What subset of the openCypher dialect specification will Apache Age support? Every implementation is all over the place and completely non-portable. And neo4j performance leaves much to be desired. My personal go-to is RedisGraph paired with RedisInsight for the instant visualizations. It just feels "right" and, while not perfect, is overall intuitive.
The Apache AGE is inspired by AgensGraph, a multimodel database fork of PostgreSQL. So it uses AgensGraph dialect.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#5Anyone tried this? How does the performance compare to neo4j and RedisGraph?
I’m about to give RedisGraph a try and I guess I will try this one a go as well.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#6I’ve been waiting to see Apache AGE on HN. Looks amazing, thanks for all the great work!
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#7How are graph edges and nodes exposed to the Postgresql type system?
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#8Related:
Apache Age: A Graph Extension for PostgreSQL - https://news.ycombinator.com/item?id=26345755 - March 2021 (45 comments)
Apache AGE: PostgreSQL-based graph database - https://news.ycombinator.com/item?id=26309560 - March 2021 (11 comments)
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#9Could it be efficient to use Apache AGE for e.g. retrieving all comments on an article?
Currently I’m using materialized paths to efficiency return all commments but would be keen to know if AGE can help query comments for an article more powerfully.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#10How are graph edges and nodes exposed to the Postgresql type system?
There is a documentation for AGE that has some basic examples on how cypher and sql can be mixed. Regarding nodes and edges: they are sub-types to a type called Agtype. More details are in the documentation.