Stack Overflow
Stack Overflow

Questions tagged [apache-age]

Use this tag for programming, integration and configuration questions related to using Apache AGE in your software project. Apache AGE is a extension to PostgreSQL which provides graph database capabilities.

Apache AGE is an extension to PostgreSQL providing graph database capabilities.

A core objective of Apache AGE, from their overview, 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."

Resources:

420 questions
1
vote
3 answers

Apache AGE- How to read a CSV File

I am using apache age and I have a CSV file with a bunch of data in it. I want to populate my graph using the information in the csv file, so can anyone help me with this, and also tell me if I have to preprocess my CSV file so that it is readable…
Muhammad Zahid
  • 154
  • 8
1
vote
3 answers

How to change what appears on top of a vertex AGE Viewer

I have created two vertices, one with label "Book" and another with label "User". The "Book" vertex has a property called "title" and the "User" vertex has the properties "first_name" and "last_name". SELECT * FROM cypher ('goodreads_db', $$ MATCH…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
0 answers

Same query plan of AGE and different stacktrace (PostgreSQL version 15 & 16)

Currently I am working on an issue that happens on PostgreSQL server version 16 and does not happen with the 15 version (alongside Apache AGE). The issue happens when executing the OPTIONAL MATCH query which lead to a LEFT-JOIN Both queries have the…
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
0
votes
1 answer

AGE Cloud express Backend is not running: "Database Connection Failed: querySrv ENODATA _mongodb._tcp.cloud-express.le2yrog.mongodb.net"

While running the backend of the Apache AGE Cloud Express repository, link using the command node index.js It throws errors: <---Server is running on port 4000 ---> Database Connection Failed: querySrv ENODATA…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
12 answers

What would be the best result type for dates in AGE?

I'm adding temporal Cypher functions to AGE, and I've implemented the date() Cypher function. Currently, it works, and my result is printed in the output as a string. SELECT * FROM cypher('graph', $$ RETURN date() $$) as (date agtype); date…
Emmanuel Allison
  • 56
  • 1
  • 6
0
votes
3 answers

404 not found Error in AGEDB-INC/Cloud-Express signup and signup

I'm running the the AGEDB-INC/Cloud-Express Project on my system. I installed the necessary dependencies using the following command in root folder npm run setup using node version 20.3.1 and then run the project in node version 14.16.0 using the…
Muhammad Farooq
  • 204
  • 10
0
votes
5 answers

Optimization Help Needed: Complex PostgreSQL Query with Multiple Joins and Filters

I'm facing a performance issue with a complex SQL query in PostgreSQL and seeking your expertise to help optimize it. The query involves multiple tables and joins and seems to be taking longer to execute than expected. I believe there might be room…
mahmoud hossam
  • 68
  • 2
0
votes
2 answers

Resolving reduce/reduce conflicts when parsing AgeSQL clauses with optional parameters

I am working on a project to add support for Cypher clauses on Postgres psql. I am trying to improve the parser performance, resolving conflicts between the rules.I have created a minimal example to illustrate a frequent issue in the…
Carla
  • 326
  • 1
  • 7
0
votes
2 answers

why does this error "LNK1104 cannot open file 'C:\Program Files\PostgreSQL\14\lib.obj" occur when I compiled a c project which created from ECPG file

I was trying to compile a c project in visual studio which generated by ECPG file then I got this error LNK1104 cannot open file 'C:\Program Files\PostgreSQL\14\lib.obj even though I added this line C:\Program Files\PostgreSQL\14\lib in Additional…
mahmoud hossam
  • 68
  • 2
0
votes
9 answers

Modifying Regression Test Results for Benchmarking Apache AGE

I'm currently working on making modifications to the source code of the Apache AGE extension for PostgreSQL, and I'm interested in performing some benchmarks to evaluate the impacts of my changes. Apache AGE uses a series of regression tests, which…
Marco Souza
  • 296
  • 7
0
votes
2 answers

How do I fix FATAL error: role does not exist' in PostgreSQL

I tried to start my postgresql database after reinstalling WSL, I started the server successfully nnaemekaxjohn@Nnaemeka:/mnt/c/Users/HP/documents/the_age_project/postgresql-11.17$ bin/pg_ctl -D demo -l logfile start waiting for server to…
Nnaemeka Daniel John
  • 333
  • 1
  • 7
0
votes
2 answers

How to visualize the Apache-age graph schema at abstract level?

I am working on a task to visualize the schema of a graph inside a database in age viewer. So I need an abstract visualization that shows all the unique nodes inside a graph, and possible edges in between those nodes. For example in agCloud at…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
4 answers

Cannot access my PostgreSQL on Windows, Although I have postgreSQL and pgAdmin installed on system

I have installed PostgreSQL-15.3 and pgAdmin 4 on my system, and set up everything requires, but I am facing this error. This is the error I am facing I have data showing on pgAdmin
Vinay Kumar Talreja
  • 1
  • 1
  • 8
0
votes
7 answers

Time out error when connecting to my postgres enterprise manager server

I installed postgres enterprise manager,EDB extended server as well as PEM agent from their official website.I navigated to the web interface using my ip address.Each time I try to connect to the server I keep getting timeout error despite inputting…
Chidera Stella Onumajuru
  • 35
  • 5
0
votes
3 answers

Encountering error while trying to start postgresql server with a newly initialize database in a different location with pg_ctl command

When I run the following command to start the server with database in a different location: /bin/pg_ctl -D /path/to/db -l logfile start I face the following error : waiting for server to start..../bin/sh: 1: cannot create logfile: Permission denied…
Waleed Arif
  • 11
  • 2
1 2 3
…
27 28