Skip to content

A Purpose-Built IDE for Apache AGE Developers

Apache AGE is a project developed by the Apache Software Foundation. It’s an extension to PostgreSQL that delivers graph processing capability using the Cypher query language. This gives users the ability to manage relational and graph workloads within a single, powerful database system.

gdotv is here to help you manage your Apache AGE database, from both the graph database and relational database point of view. Cypher query writing is seamless in gdotv as it automatically wraps your Cypher query with the necessary SQL code. But don’t worry: you can still query your database directly using SQL too.

With gdotv, you get access to both query languages, interactive graph visualization, graph schema tracking, the ability to modify your data on the fly with an intuitive UI, and much more!

Apache AGE graph databaseApache AGE

Apache Software Foundation.


Query languages supported by gdotv: Cypher and SQL


Learn more about Apache AGE

Feature image for Apache AGE.

An Overview of Apache AGE

AGE literally stands for A Graph Extension. But what does that mean?

Apache AGE is a PostgreSQL extension that brings graph power to relational databases. That means your Postgres database leverages the power of both graph and relational simultaneously. In addition, you query your data using either SQL or Cypher, where the Cypher queries are parsed and wrapped in SQL.

 
Apache AGE an open source software, free to all users. For those who want to take advantage of both the efficiency and reliability of PostgreSQL, while also conducting the complex data analyses allowed by graph databases, Apache allows all of this to take place from a single, powerful system. 

 

https://github.com/apache/age/blob/master/img/age-02.png?raw=true
Apache AGE offers drivers for Python, Java, Nodejs, and Go

Popular use cases of Apache AGE include fraud detection, telecommunications, finance, logistics, healthcare data, and route optimization.

Don't Take Our Word for It

Try out gdotv for yourself

Need More Details?

Dive into the docs

What’s Possible with Apache AGE + gdotv

Easy Installation and Setup

Effortlessly integrate gdotv with your Apache AGE graph database with a simplified plug-and-play database connector. The gdotv database client provides straightforward database connection and configuration instructions to get you started in less than a minute.

This Apache AGE IDE is available to download for Windows, macOS and Linux with a one-click installer to get you started instantly.

Connecting to Apache AGE with the gdotv database visualization tool is easy as 1-2-3!
Connecting to Apache AGE with the gdotv database visualization tool is easy as 1-2-3!
Manage all your database connections and queries from one central console.
Manage all your database connections and queries from one central console.

Centralized Connection Management

gdotv can be used to query and compare data from a huge range of database vendors simultaneously! We don’t just work with Apache AGE: gdotv data visualization tools fully integrate with various other graph databases, including all Apache TinkerPop™ compatible graph databases and most LPG and RDF providers.

gdotv is fully compatible with query languages like Gremlin, Cypher, Google SQL, SQL:2023, SPARQL and more. Using an intuitive UI, you’ll be able to switch between your connections and queries seamlessly.

Query with Both Cypher & SQL

The great strength of Apache AGE is the option to approach your data from both a relational and graph perspective at once.

This is why gdotv users can query their data using either SQL or Cypher. Switching between them is as easy as the click of a button!

Seamlessly switch between Cypher and SQL query editors
Seamlessly switch between Cypher and SQL query editors

Also Available for Azure Database for PostgreSQL

Did you know that Apache AGE is available directly on Azure Database for PostgreSQL? It’s the easiest and cheapest way to deploy Apache AGE as a managed database service on Azure!

gdotv is fully compatible with Azure Database for PostgreSQL and supports both username/password authentication as well as EntraID authentication via the Azure CLI. To learn more, dive into the documentation here.

A sample graph display in gdotv using loading custom image file url from vertex properties
A sample graph display in gdotv using loading custom image file url from vertex properties

Customizable Data Visualization

You can create custom visualization rules for your graph database with gdotv to determine the look and feel of your data.

The gdotv database client boasts easy-to-configure style options that you can use to customize vertices and edges based on their labels and property values.

You can choose any color, size, or background image and adjust other elements to match your preference.

No-Code Data Exploration with the gdotv Graph Data Explorer

Use the built-in gdotv Graph Data Explorer to navigate your Apache AGE data without using queries.

The Graph Data Explorer allows you to define path patterns to query from your data, using filters on both your vertices and edges. Elements in the declared path can be filtered according to their label, direction, and property values, allowing you to perform complex path pattern searches with no code.

The Graph Data Explorer enables no-code path exploration directly against your Apache AGE graph database in just a few clicks
The Graph Data Explorer enables no-code path exploration directly against your Apache AGE graph database in just a few clicks
Access your data model
Access your data model

Instantly Load & View Your Data Model

Good graph management requires understanding and verifying your data schema. That’s why gdotv provides an overview of your data structure with the data model view. 

For Apache AGE, the data model is retrieved using the Apache AGE Schema API, ensuring full consistency with your database’s native schema. 

This is always just a click away, meaning that you always have a bird’s-eye view of your vertices, edges, and properties right at your fingertips.

Retrieve & Review Query Execution Plans in 1 Click

A query execution plan provides a roadmap for how your query will be executed, ensuring efficient use of your graph database. 

gdotv pulls the query plan from your Apache AGE database’s own functionality and displays the results, giving you instant feedback on query execution and performance.

Anticipate how your query will be executed to optimize efficiency
Anticipate how your query will be executed to optimize efficiency
Create, update or delete vertices, edges, and properties interactively
Create, update or delete vertices, edges, and properties interactively

Modify Your Apache AGE Graph Data Directly within gdotv

Want to adjust something in your graph? Take a hands-on approach and manage your Apache AGE graph directly. Using gdotv, you can directly create, modify, and delete the edges and vertices – as well as modify the properties associated with them – allowing you to make changes on the fly.

Take Advantage of Syntax Validation

Using gdotv language highlighting and syntax checking for Cypher and SQL makes your code easier to understand and visually parse, warning you of any error that would prevent it from executing against your Apache AGE instance.

Intuitive interface with syntax highlighting and validation
Intuitive interface with syntax highlighting and validation
gdotv's built-in documentation for Cypher and SQL, right at your fingertips
gdotv’s built-in documentation for Cypher and SQL, right at your fingertips

State-of-the-Art Cypher Editor

The gdotv Cypher code editor is the most powerful available – it offers data schema-accurate auto completion and embedded official documentation for Cypher to give you all the information and suggestions you need to write your Apache AGE queries faster and more effectively.

Frequently Asked Questions (FAQs)

gdotv: The Apache AGE IDE

Turn your graph data into connected insights when you use gdotv to query, explore, and visualize your Apache AGE graph database. 

Sign up for a free trial today and discover how gdotv amps up your productivity as the perfect Apache AGE IDE and graph visualization tool. 

Stay in Touch

Want to stay connected with everything happening at gdotv? Sign up for the monthly gdotv Newsletter to get product updates, fresh blog posts, in-person events, and (sometimes) bad jokes straight to your inbox.

Or, prefer to talk with the gdotv team directly? Use the form below to get in touch.