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.

postgresqlsq

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.

postgresqlsq 

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.

Banner


Dart Adds WebAssembly Support
20/02/2024

Google has released Dart 3.3 with experimental support for applications compiled to WebAssembly, along with new extension types and a revamped JavaScript interop model.



Android Studio Iguana With Crash Reports
05/03/2024

Google has announced that the latest version of Android Studio, Iguana, is now stable. It has version control system support in App Quality Insights and new built-in support for creating baseline prof [ ... ]


More News

raspberry pi books

 

Comments




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