Apache AGE is a PostgreSQL Extension that provides graph database functionality. AGE is an acronym for A Graph Extension, and is inspired by Bitnine's fork of PostgreSQL 10, AgensGraph, which is a multi-model database. The goal of the project is to create single storage that can handle both relational and graph model data so that users can use standard ANSI SQL along with openCypher, the Graph query language.
A graph consists of a set of vertices (also called nodes) and edges, where each individual vertex and edge possesses a map of properties. A vertex is the basic object of a graph, that can exist independently of everything else in the graph. An edge creates a directed connection between two vertices. A graph database is simply composed of vertices and edges. This type of database is useful when the meaning is in the relationships between the data. Relational databases can easily handle direct relationships, but indirect relationships are more difficult to deal with in relational databases. A graph database stores relationship information as a first-class entity. Apache AGE gives you the best of both worlds, simultaneously.
Apache AGE is:
Powerful -- AGE adds graph database support to the already popular PostgreSQL database: PostgreSQL is used by organizations including Apple, Spotify, and NASA. Flexible -- AGE allows you to perform openCypher queries, which make complex queries much easier to write. Intelligent -- AGE allows you to perform graph queries that are the basis for many next level web services such as fraud & intrusion detection, master data management, product recommendations, identity and relationship management, experience personalization, knowledge management and more.
Also, while the technology can be integrated against many data layers, a graph database is also the perfect companion for a GraphQL API! Since the information is already in a native format, it simplifies many factors and even allows many operations to be generated automatically. GraphQL is rapidly superceeding REST as the standard for cloud applications.
- Apache AGE is currently being developed for the PostgreSQL 11 release and will support PostgreSQL 12, 13 and all the future releases of PostgreSQL.
- Apache AGE supports the openCypher graph query language.
- Apache AGE enables querying multiple graphs at the same time.
- Apache AGE will be enhanced with an aim to support all of the key features of AgensGraph (PostgreSQL fork extended with graph DB functionality).
- Latest Apache AGE release, Apache AGE 1.1.0.
- The latest Apache AGE documentation is now available at here.
- The roadmap - Apache AGE website.
- Send all your comments and inquiries to the user mailing list, [email protected].
- To focus more on implementing the openCypher specification, the support for PostgreSQL 12 will be added in the Q4 2022.
Apache AGE Viewer is a user interface for Apache AGE to provide visualization and exploration of data. It provides a simple web visualization tool for users to enter complex graph queries and explore the results in graph and table forms. Apache AGE Viewer is enhanced to proceed with large graph data and discover the insights through various graph algorithms. Apache AGE Viewer will become a graph data administration and development platform for Apache AGE to support multiple relational databases: https://github.com/apache/age-viewer.
- This is a visualization tool. After AGE Extension Installation You can use this tool to use the visualization features.
- Follow the instructions on the link to run it. Under Connect to Database , select database type as "Apache AGE"
Here is the link to the latest Apache AGE documentation. You can learn about how to install Apache AGE, its features and built-in functions and how to use various Cypher queries.
You can improve ongoing efforts or initiate new ones by sending pull requests to this repository. Also, you can learn from the code review process, how to merge pull requests, and from code style compliance to documentation, by visiting the Apache AGE official site - Developer Guidelines.