DEV Community

Jawad Ali Abbasi
Jawad Ali Abbasi

Posted on

AGESQL | CLI Tool For AGE (Setup)

Hi Guyz!

This blog will cover a new topic of Apache AGE. In this one, we will learn about a command-line tool under development for Apache AGE, namely AGESQL.

Just psql is a command-line tool for postgresql to write queries for manipulating databases, agesql is a command-line tool that can be used to query the server with cypher queries without calling an additional function to parse the query to SQL syntax.

So, let's see how you can setup agesql on your system.

Note: To run agesql on your system, you must have postgresql 15 setup on your system and ready to go.

Now, first clone the AGE_CLI branch from age repository on your system. Open the respective folder from terminal and run the following commands:

-> cd age
-> export PATH="path to postgresql15/bin:$PATH"
-> export PGDATA="path to postgresql15/bin"
-> export USE_PGXS=TRUE
-> flex -b -Cfe -p -p -o ‘cypher.c’ cypher.l
-> bison -d cypher.y
->make

If make command is successful that means agesql is installed and ready to run on your system.

That's all for now. In the next blog, we will see how to run agesql and write cypher queries in it.

https://age.apache.org/
https://github.com/apache/age
https://github.com/apache/age/tree/AGE_CLI

GoodBye!

Top comments (0)