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
2
votes
8 answers

How do I run and switch between different versions of postgreSQL on Ubuntu?

I am working on two different projects that require two different versions of postgres (12 and 14), both of which are built from source during installation. How can I configure my system to have both versions installed on the same machine, and how…
tokamak32
  • 27
  • 7
2
votes
3 answers

Create Bi-directional relation between two vertices using OpenCypher with Apache AGE

In the below example I create a one-direction relation between two vertices (from b to a), is there a way I can create a relation from (a to b) at the same time? SELECT * FROM cypher('test_graph', $$ MATCH (a:Person), (b:Person) WHERE a.name =…
ahmed_131313
  • 142
  • 6
2
votes
2 answers

Age Go Driver Error on Windows: function age_prepare_cypher(unknown, unknown) does not exist

I'm trying to use the golang driver for apache age to run cypher queries on Windows. For the postgres server I'm using the the Apache-Age docker image. While running the sample, I get the following error: ahmar> go run main.go age_wrapper_sample.go…
Ahmar
  • 584
  • 2
  • 7
2
votes
1 answer

problem to access of the properties of an edge when using plpython3u in PostgreSQL to create functions

I implement python function for for the following query and i get correct answer, but when i try to create functions in postgreSQL by using plpython3u extension, it doesn't have any error but still doesn't return the results to the table. Also, I…
Jaber
  • 23
  • 4
2
votes
2 answers

How should I call the builtin Apache AGE function _agtype_build_vertex from psql terminal?

From the psql terminal, I'm trying to use an Apache AGE builtin function with the following signature: Datum _agtype_build_vertex(PG_FUNCTION_ARGS) the function is located here:…
Marco Souza
  • 296
  • 7
2
votes
9 answers

Connect to an Apache Age Database using Python

I am trying to connect to an Apache Age database using Python and getting a “connection refused” error.How can I resolve this? I have installed Apache Age and Python on my local machine. In my Python script, I'm using the psycopg2 library to connect…
Prachi
  • 39
  • 3
2
votes
1 answer

How to find vertices with a property which contains a value inside a curly braces and it follows a pattern?

I created some vertices to represent MTG cards. Each card has a property called mana_cost, which is the cost to play that card in the game. The mana_cost value is stored between curly braces in a string. For example, "{G}{G}" would represent two…
Matheus Farias
  • 716
  • 1
  • 10
2
votes
5 answers

Why does PostgreSQL need both WAL buffer and WAL segment file?

I'm trying to understand more about the apacheAGE extension therefore I'm reading the inner workings of PostgreSQL. From what I understand every operation that alters the table is written at the WAL buffer, but after it is commited/aborted it is…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
2
votes
1 answer

How to send a NULL argument through a DirectFunctionCall?

I'm modifying the function Datum create_vlabel(PG_FUNCTION_ARGS), within Apache AGE. But sometimes it's needed that one of the arguments to this function be NULL, and there's a check to that, like this: if (!PG_ARGISNULL(2)) { ... } The thing is,…
Marco Souza
  • 296
  • 7
2
votes
2 answers

AGE Graph is actually stored as a postgreSQL Table, Right ? How to retrieve that Table (not Graph)?

When we create a postgreSQL Table, we are able to see its rows and cols with SELECT * FROM . When we create an AGE Graph, it is also actually a postgreSQL Table. What query should I run to retrieve the original graph's Table data.
Mohayu Din
  • 433
  • 9
2
votes
11 answers

Is there any way to add multiple labels to a node?

Let's say I'm creating a database about food and in it, I want to add Dal which would be both Curry and Lentil. SELECT * FROM cypher('menu', $$ CREATE (:LENTIL:CURRY {name:"Dal"}) $$) AS (dal agtype); 2023-02-20 06:49:01.568 IST…
Bhaskar Sharma
  • 158
  • 8
2
votes
4 answers

Im having diffuclty installing Apache-age

Im follow the tutorial from https://age.apache.org/age-manual/master/intro/setup.html to install the apache-age. The first path on my $PATH variable is not the one from the pg_config so i used the make PG_CONFIG=/path/to/postgres/bin/pg_config…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
2
votes
3 answers

What is the difference between building cypher and executing the prepared statement in the following code

I am unable to understand why there are two queries being executed. First we are executing the prepared statement and we are using the build cypher function. The code can be found…
Fahad Zaheer
  • 47
  • 1
  • 7
2
votes
3 answers

Changing function so that it retrieves an array type argument causes ERROR: FUNCTION DOES NOT EXIST

I changed a function so that it receives three arguments instead of only two. In the age--1.2.0.sql file, it was set before as: CREATE FUNCTION ag_catalog.create_vlabel(graph_name name, label_name name) RETURNS void LANGUAGE c AS…
Matheus Farias
  • 716
  • 1
  • 10
2
votes
3 answers

create apache age graph from networkx graph

I've started using apache age and was wondering if there is a cool way to directly put networkx graph into the apache age database? I'm using a workaround to get the edged and nodes associated with their attributes to insert them in the apache age…
Amgad Abdallah
  • 23
  • 2
1
2
3
…
27 28