Could 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.
Apache AGE, a PostgreSQL extension with graph database functionality
21–30 of 77 posts
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#22Interesting. What are some good extensions for pg? I have only used UUID and postgis.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#23Anyone 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
#24Interesting. What are some good extensions for pg? I have only used UUID and postgis.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#25Anyone 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.
Did you try dgraph? For our use cases it won over neo4j. Didn’t try redisgraph.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#26Anyone 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.
Did you try dgraph? For our use cases it won over neo4j. Didn’t try redisgraph.
A product which lived up for VC money and little more.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#27What 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 potentia…
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#28Earlier quoted context omitted.
Did you try dgraph? For our use cases it won over neo4j. Didn’t try redisgraph.
Didn't dgrapgh dissolve? Based on open functionality discussed on their help forum and stbility issues I wouldn't touch it any more. A product which lived up for VC money and little more.
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#29how do you do this at scale ?its generally a NP hard problem, but wondering whether something like AGE helps.
not sure how Google, etc or even someone on fraud detection does this at scale
Re: Apache AGE, a PostgreSQL extension with graph database functionality
#30I'm somewhat wary of using nontrivial C extensions, having seen so many of them sometimes seg fault the backend (eg PostGIS). There seem to be PG backend crashes described in this projects issues as well.