What is Apache AGE®
Tags: apacheage, postgres, graphdata
Published: 2023-02-17 18:47:53


In this blog I will demonstrate What is Apache Age.What is Grapgh Database.

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.
If You want to study more about Postgres [here](https://www.postgresql.org/about/)

**Grapgh Database**
A graph database stores nodes and relationships instead of tables, or documents. As we know that in relational Database data is stored in rows and column Data is stored just like you might sketch ideas on a whiteboard. Your data is stored without restricting it to a pre-defined model, allowing a very flexible way of thinking about and using it.

We live in a connected world, and understanding most domains requires processing rich sets of connections to understand what’s really happening. Often, we find that the connections between items are as important as the items themselves.

![Grapgh database Example ](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cf3n7epnpdfxlpk7uu4j.png)

1. Graph databases provide a much faster and more intuitive way to model and query your data.

Modeling Data in Grapgh vs SQL

**In Grapgh:**
![Grapgh](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0flmi20ia7j3yt5bafic.png)
**In SQL**

![SQL](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fr18udzmnre1hgbjduak.png)

**Now come to Point What is Apache AGE?**
Apache AGE® is a PostgreSQL extension that provides graph database functionality.

The goal of Apache AGE® is to provide graph data processing and analytics capability to all relational databases.

Through Apache AGE, PostgreSQL users will gain access to graph query modeling within the existing relational database.

Users can read and write graph data in nodes and edges. They can also use various algorithms such as variable length and edge traversal when analyzing data.

**What Is Apache AGE® Viewer ?**
Apache AGE® Viewer is a web user interface for Apache AGE that provides data visualization and exploration.

Users can enter complex graph queries and explore the results expressed in graph and table data.

Apache AGE® Viewer handles large graph data. Users will be able to discover meaningful insights with the help of various graph algorithms.

Apache AGE® Viewer will serve as a central graph data management & development platform for Apache AGE, a graph extension which will support all relational databases in the future.

Link to Installation of Apache Age on MacOS [here](https://www.youtube.com/watch?v=0-qMwpDh0CA&t=1s)

**Key Features:**

1. Graph Database Plugin for PostgreSQL
2. Hybrid Queries (OpenCypher And SQL)
3. Fast Graph QueryProcessing
4. Graph Visualizationand Analytics

**Source code:**
The source code can be found at https://github.com/apache/age

**AGE Architecture:**

![AGE](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6bkfkq4l8onffqgv1x1r.jpeg)