Support AgensGraph

[jasperblues]

It would be cool to support AgensGraph.

For the most part the regular Postgres JDBC driver will work, except for returning some graph specific types like paths, which a visible to the regular driver as strings. The one from Bitnine will will parse these.

The CYPHER support by AgensGraph is a limited subset of that provided by Neo4j, but continues to evolve.

[robertsluksa]

Great idea! We will put and prioritize it in our backlog. Do you have any information on AgensGraph usage statistics or any specific use cases to have in mind?

[jasperblues]

Do you have any information on AgensGraph usage statistics

Inviting a team members to comment here, and provide that info.

Or any specific use cases to have in mind?

@Injectable()
export class RouteRepository {
    public constructor(
        public readonly persistenceManager: TransactionalPersistenceManager,
        @InjectCypher('@/business/traffic/routesBetween') public readonly routesBetween: string
    ) {}

    @Transactional()
    public async findRouteBetween(start: string, destination: string): Promise<Route[]> {
        return this.persistenceManager.query(
            new QuerySpecification<Route>()
                .withStatement(this.routesBetween)
                .bind([start, destination])
                .transform(Route)
        );
    }
}

^-- I'm releasing a driver/OGM tool for Nodejs and TypeScript that supports multiple graph databases, including AgensGraph. On of the features is to inject queries into repositories, so that they can be formatted, debugged, profiled, etc using your tool.

https://www.linkedin.com/posts/jasper-blues-7781638_agensgraph-webinar-7-building-highly-scalable-activity-6589433967877939200-P_6r ^-- If you'd like to join a webinar to find out about the framework.

[ex3m1024]

Great! We'll look into it. No specific promises on release dates for now, but we'll keep you updated. Any further suggestions - let us know!

[jasperblues]

https://github.com/liberation-data/drivine. ^-- here is the framework that I mentioned.

EDIT: http://drivine.org/ ^-- And here's the website (on the site I mention my personal appreciation for this plugin).