Overview
Apache AGE, a PostgreSQL extension, delivers robust graph database capabilities. Representing "A Graph Extension" (AGE), it draws inspiration from Bitnine's variant of PostgreSQL 10, AgensGraph—a versatile multi-model database. The project aims to establish a unified storage solution capable of managing both relational and graph model data. This empowers users to seamlessly leverage standard ANSI SQL alongside openCypher, the designated Graph query language.
Graphs
A graph is made up of vertices and edges, and every node and edge has a unique set of attributes associated with it. The fundamental unit of a graph is a vertex, which is independent of all other nodes in the graph. A directed link between two vertices is formed by an edge.
To create a graph, use the create_graph
function, located in the ag_catalog
namespace.
Syntax: create_graph(graph_name);
Returns:
void
To delete a graph, use the drop_graph
function, located in the ag_catalog
namespace.
Syntax: drop_graph(graph_name, cascade);
Returns:
void
Simple Datatype
Null
SELECT *
FROM cypher('graph_name', $$
RETURN NULL
$$) AS (null_result agtype);
Integer
SELECT *
FROM cypher('graph_name', $$
RETURN 1
$$) AS (int_result agtype);
Float
SELECT *
FROM cypher('graph_name', $$
RETURN 1.0
$$) AS (float_result agtype);
Numeric
SELECT *
FROM cypher('graph_name', $$
RETURN 1.0::numeric
$$) AS (numeric_result agtype);
Bool
SELECT *
FROM cypher('graph_name', $$
RETURN TRUE
$$) AS (boolean_result agtype);
String
SELECT *
FROM cypher('graph_name', $$
RETURN 'This is a string'
$$) AS (string_result agtype);
Top comments (0)