I request adding support for the "age" extension in CloudSQL PostgreSQL instances.

This would help us to execute

CREATE EXTENSION age; 

and then load the extension for each connection as

LOAD 'age';

and

SET search_path = ag_catalog, "$user", public;

Vertex can be created and used as below

SELECT * 
FROM cypher('graph_name', $$
    CREATE (:label {property:value})
$$) as (v agtype);` 

SELECT * 
FROM cypher('graph_name', $$
    MATCH (v)
    RETURN v
$$) as (v agtype);

Apache AGE is a PostgreSQL extension that provides graph database functionality. The goal of Apache AGE is to enable Postgres users to gain access to graph query modeling in Postgres’ existing relational model.

The main advantages are:

• Develop a unified storage system capable of accommodating both relational and graph model data. This will enable users to seamlessly utilize standard ANSI SQL in conjunction with openCypher, the Graph query language.
• AGE inherits PostgreSQL's scalability and reliability features, making it suitable for handling large-scale graph datasets.
• AGE extension is optimized for handling graph data efficiently. This extension helps data retrieval of associated entities by approximately 30% faster than traditional relational data handling .

Other Information

AGE