AgeSQL serves as a command-line interface (CLI) client tailored for PostgreSQL, enhancing its capabilities by seamlessly integrating Cypher queries alongside conventional SQL. This innovative tool harnesses the Age extension's power within PostgreSQL, enabling the execution of graph queries directly within the database.
The core objective of AgeSQL revolves around crafting a CLI tool that mirrors the user experience of the well-established PostgreSQL CLI (psql). It goes beyond by delivering comprehensive features for efficiently managing graph databases. Furthermore, AgeSQL encapsulates Cypher commands, simplifying their integration and utilization within the PostgreSQL environment.
Postgres-15
Install postgres v15 from source code in your system
https://github.com/postgres/postgres.git
make sure to checkout the v15 branch before installtion
then install age from the github and run it with postgres 11-12-13 version
https://github.com/apache/age.git
now clone AgeSQL repo
git clone https://github.com/AGEDB-INC/AgeSQL
then
cd AgeSQL
Export the path to PostgreSQL 15, replacing /path/to/postgresql with the path to your installation and enable PGXS:
export PATH=/path/to/postgresql/15/bin:$PATH
export USE_PGXS=TRUE
then run the script
sudo make
Apache-Age:-https://age.apache.org/
GitHub:-https://github.com/apache/age
Top comments (0)