include apache age

[kindlychung]

Overview

Would be nice to include the apache age extension for graph database.

Apache AGE is an extension for PostgreSQL that enables users to leverage a graph database on top of the existing relational databases. AGE is an acronym for A Graph Extension and is inspired by Bitnine's AgensGraph, a multi-model database fork of PostgreSQL. The basic principle of the project is to create a single storage that handles both the relational and graph data model so that the users can use the standard ANSI SQL along with openCypher, one of the most popular graph query languages today.

Use Case

Useful for querying/analyzing data of graph nature.

Desired Behavior

CREATE EXTENSION age;
LOAD 'age';
SET search_path = ag_catalog, "$user", public;
SELECT create_graph('graph_name');
-- To create a single vertex, use the CREATE clause.
SELECT * 
FROM cypher('graph_name', $$
    CREATE (n)
$$) as (v agtype);

Environment

• Platform: Kubernetes k3s
• Platform Version: v1.27.5+k3s1
• PGO Image Tag ubi8-15.4-0
• Postgres Version 15
• Storage: hostpath
• Number of Postgres clusters: 1

[dsessler7]

@kindlychung, thank you for the suggestion! I have added a story to our backlog to look into this.

[flypenguin]

any updates here? we're comparing possible operators just now and are most probably in need for a graph database. that would be a big "pro" here :)