|PostgreSQL Multi-Model Graph Extension Announced|
|Written by Kay Ewbank|
|Monday, 13 July 2020|
AGE, a multi-model graph database extension for PostgreSQL has been announced. AGE is the successor to AgensGraph, and is an Apache Incubator project.
When AGE was proposed as an incubator project, the developers said its purpose is to provide an extension for PostgreSQL to give users the ability to use graph database on top of the existing relational database with minimal effort. The project aims to create single storage that can handle both relational and graph model data so that the users can use the standard ANSI SQL along with openCypher, the Graph query language.
AGE is a successor to AgensGraph, the multi-mode database that added a standard graph query language to PostgreSQL. It keeps many of the original features while improving the ability to scale and maintaining performance. AgensGraph was released in 2017 by Bitnine Global. AGE will offer the same integration of SQL and Cypher without users having to discard their existing solutions, allow for a cleaner integration of AGE with PostgreSQL’s other extensions.
The AGE developers say that users with a relational background and data model who are in need of having a graph model on top of their existing relational model can use this extension with minimal effort because they can use existing data without migration.
AGE is optimized for handling complex connected graph data and includes database features such as support for ACID transactions, multi-version concurrency control, stored procedure, triggers, constraints, sophisticated monitoring and a flexible data model (JSON). Because AGE is a PostgreSQL extension, it can itself be extended with PostgreSQL external modules such as PostGIS.
The AGE developers plan a complete implementation of openCypher language specification in a PostgreSQL extension, including an openCypher parser, internal AgensGraph data types, and Cypher language Clauses such as Return, Create, Delete, Update, and Match.
Version 0.2 of the extension is now available for download.
or email your comment to: email@example.com