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

Order by attribute that contains a date

I have a graph with about 20 vertices and 60 edges. There are two labels for the vertices: one is labelled as Person and the other Merchant. The edges between them represent a transactions and it stores the status of it and the date of the…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
4 answers

How to send a SQL command inside a C-language function on a PostgreSQL extension (Apache AGE)?

I’m working on a PostgreSQL extension (Apache AGE) and need to execute a SQL command from within a C-language function. How can I achieve this? For context, I’m developing an extension that modifies some tables in a database, and I need to run some…
Marco Souza
  • 296
  • 7
1
vote
1 answer

How do I get all Child Lables of a Parent Label

I am working on Apache AGE, and I want all the child labels of a given Parent Label. Example: I have an edge named PARENT, and GRANDCHILD, CHILD inherits this PARENT. I want all the edges which inherit PARENT from the PostgreSQL table. Given I have…
Muhammad Zahid
  • 154
  • 8
1
vote
8 answers

After successful installation, age-viewer showing error?

I have successfully installed postgresql, age and age-viewer on my m1 mac. But today it shows connection error "Database Connection Failed Failed to connect to the database. Are you sure the database is running on the server? []:(ECONNREFUSED)…
Maruf31
  • 17
  • 8
1
vote
1 answer

Why doesn't the != operator work in my query in AGE?

I am facing a problem when I try to use STACK_MATCH relationships to connect Person nodes having the 'backend' title, while avoiding Person nodes ending up being related to themselves. SELECT * FROM cypher('devbook', $$ MATCH (a: Person), (b:…
Marcos Silva
  • 56
  • 4
1
vote
2 answers

Apache AGE - How to use LIMIT to return a random number of rows?

I'm trying to use the LIMIT clause in Apache AGE to return a random number of rows from my graph database. Specifically, I want to return one to three rows at random, instead of a fixed number. I've tried using the toInteger(3 * rand()) + 1…
Abdul Manan
  • 117
  • 5
1
vote
2 answers

Clarification regarding Apache AGE documentation 'Orderability Between different Agtypes'

On the page regarding compatibility (here) It is mentioned that:- The ordering of different Agtype, when using <, <=, >, >= from smallest value to largest value is: 1 Edge 2 Path 3 Map 4 Vertex 5 Edge 6 Array 7 String 8 …
Bhaskar Sharma
  • 158
  • 8
1
vote
14 answers

Apache AGE System cannot find pg_config command

I'm trying to run the Apache AGE extension on Ubuntu 22. I have postgres 12.14 installed, and I've cloned the AGE repository as instructed in the documentation. However, when I try running the pg_config command, bash says that this command does not…
tokamak32
  • 27
  • 7
1
vote
2 answers

Why is my PostgreSQL server crashes when I use a specific query with apacheAGE?

The data setup doesn't matter in this case. If I run this query select * from cypher('test', $$ match (a)-[]->(b) with a, count(*) as c return b $$) as (b agtype); I get this server closed the connection unexpectedly This probably means the server…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
1
vote
4 answers

Date and time functions in apache-age database

I was designing a database for a social network. So needed a time stamp and Date when a user creates a post or comments. Is there any function using the built-in function provided by apache-age to fetch the data and time from the system?
Kamlesh Kumar
  • 351
  • 1
  • 7
1
vote
9 answers

Using GDB with Apache AGE

I am starting the database cluster by typing this in the terminal: bin/pg_ctl -D -l logfile start Then moving into a particular database: bin/psql I am getting the process id of the PostgreSQL Backend process by SELECT…
Hrishikesh Mallick
  • 9
  • 2
1
vote
1 answer

How do I alter a table to inherit from other tables with PostgreSQL C source functions?

In Apache AGE source code, we can see that vertices and edges can inherit from multiple labels. For this, it uses functions called create_label, create_table_for_label and, depending if it is a vertex or an edge, create_vlabel and create_elabel. All…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
1 answer

What arguments can the Cypher() function take in the ApacheAGE extension?

After reading the documentation i didn't find what the Cypher() function does if NULL arguments are provided. From my understanding if there is a correctly prepared statement it should exectute that. Is that correct? Also on what graph? Because the…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
1
vote
1 answer

How to sum every property from a variable length edge

I have a graph that has vertices as cities and it also has edges that connect each city. These edges contain a property called travelTime that represents the time to got from one city to another. SELECT * FROM cypher('Saxeburg', $$ MATCH…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
6 answers

How to change the graph name in Apache-AGE?

I have a Graph with the name people created inside my apache database. But now I want to update it to population How can I do that?
Kamlesh Kumar
  • 351
  • 1
  • 7
1 2 3
…
27 28