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


ACM Grace Murray Hopper Award 2020
09/07/2021

The 2020 ACM Grace Murray Hopper Award has gone to Shyamnath Gollakota of the University of Washington who is seen as a creative force in his field of wireless computer networks and is now p [ ... ]



JetBrains Releases Onsite Datalore For Enterprise
05/07/2021

JetBrains has released a new version of Datalore, its online data science notebook with smart coding assistance. Datalore Enterprise is designed to work on an organization's own secure networks.


More News

square

 



 

Comments




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