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


Cockroach Creates Pebble
28/09/2020

Cockroach Labs has introduced Pebble, which is described as a RocksDB inspired and RocksDB compatible key-value store. Until now, CockroachDB has used RocksDB as its key-value store, but Pebble provid [ ... ]



Analytic SQL for Developers
29/09/2020

Introducing a free, self-paced, quick and official course, one of of Oracle's Dev Gym quizzes, about the concepts and syntax behind SQL's Analytic functions.


More News

square

 



 

Comments




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