PostgreSQL Multi-Model Graph Extension Announced
PostgreSQL Multi-Model Graph Extension Announced


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.
 
More Information
AGE Download 
AGE On Apache
Related Articles
Graph Query Language Gets Official Adoption 
PostgREST Turns PostGRE RESTful 
PostgreSQL 12 Released
The Enduring Influence Of Postgres 
PostgreSQL Improves Declarative Partitioning 
PostgreSQL Adds Parallel Query Support
GraphQL Foundation Gets Bigger 
RedisGraph Reaches General Availability 
Neo4j 2.0 A Dream Graph Database 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.





Comments

or email your comment to: comments@i-programmer.info
