I’m using a neo4j for tracking simple relationships and querying a node’s neighbours recursively. However, I’m unsure if I need a full-fledged graph database like neo4j, which offers a lot more complex graph querying capabilities.
Apache AGE seems like a potential alternative, as it can be used as an extension on an existing PostgreSQL database, which I have, allows the use of both SQL and Cypher for querying. This interoperability might provide powerful querying options in the future for the use case.
My main concern with neo4j is maintainability. Finding experienced neo4j developers can be challenging, and debugging neo4j related issues often requires a deep dive of its inner workings.
Given my requirements, would Apache AGE be a more suitable choice compared to neo4j?
link to repo for more context: https://github.com/getmomentum/momentum-core/issues/26
I would prototype a solution in AGE. It will eliminate the barrier between "graph" and "relational". Postgres also scales rather well.