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
0
votes
3 answers

Apache AGE-How to create a directed Edge

I have created a graph named 'family tree' and have added three persons with the label Persons. Now i'm adding an edge between Andrew James and Timathy James such that, Andrew is the son of Timathy using the following command: Now when I display…
0
votes
2 answers

Apache AGE - Creating Functions With Multiple Parameters

I was looking inside the create_vlabel function and noted that to get the graph_name and label_name it is used graph_name = PG_GETARG_NAME(0) and label_name = PG_GETARG_NAME(1). Since these two variables are also passed as parameters, I was…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
2 answers

Apache AGE - Creating Materialized View Error

I wanted to create a materialized view from a label table and then create indexes on it. However, when I type the query to create this view, postgres pops an error. Here is the query that I type to return all the vertices containing the "Book" label…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
10 answers

How can I ensure that all nodes in a graph database like AGE are unique?

I am using AGE to create a graph database, and I want to ensure that all nodes in my database are unique. I want to avoid having multiple nodes with the same properties and labels in my graph. For example, if I have a node with label Person and…
Abdul Manan
  • 117
  • 5
0
votes
2 answers

How to specify multiple versions of same driver/library in the dependency field of control file in debian packaging

I'm trying to make a debian package of Apache-Age and it can successfully build either with "postgresql-server-dev-11" or "postgresql-12" I've made my control file in the following way : Source: age Section: database Priority:…
Sarthak
  • 380
  • 7
0
votes
5 answers

Unable to create graph in PostgreSQL using "age" extension despite following all steps

I am trying to create a graph in PostgreSQL using the "age" extension, but I am encountering an issue. Can anyone assist me in resolving this problem? i have searched the catalog but still cant find the solution select * from pg_proc where proname…
0
votes
1 answer

segmentation fault and agtype array error

If I execute the following query SELECT * FROM ag_catalog.cypher('graph', $$ match (p:Project)-[:Has]->(t:Task)-[:AssignedTo]->(u:Person) with distinct t, {tn: t.name, user: collect(u)} as task with distinct p, {pn: p.name, task: collect(task)} as…
M Jin
  • 11
  • 1
0
votes
1 answer

How to define rule file in debian packaging of a project which have a make file to build from source?

I'm new to stackoverflow so correct me if I made any mistake in providing the details. So I'm trying to make a deb file for Apache-Age, and going by the documentation, if we try to install AGE from source then we can simply do it by : make install…
Sarthak
  • 380
  • 7
0
votes
1 answer

Does Apache AGE support Indexing on Nodes/Relationships?

Is it possible to create an index on the nodes/relationships of a graph in AGE? If so, what is the syntax? I was unable to find anything about it in the documentation.
moeed865
  • 304
  • 1
  • 6
0
votes
3 answers

AGE question: WITH clause doesn't work with MATCH/WITH

If I have the following query select * from cypher('agload_test_graph', $$ match (n) with n where n.name='A' return n $$) as (sp agtype) then n.name='A' doesn't work. but if I remove with clause, then it works: select * from…
M Jin
  • 11
  • 1
0
votes
2 answers

PostgreSQLClientKit querying database

Is there a short way to prepare the statements and execute them, if you are trying to run multiple queries and you are not concerned with the results that are generated by those statements. Forexample I want to execute these two statements, is there…
Fahad Zaheer
  • 47
  • 1
  • 7
0
votes
2 answers

"Fixing missing packages and vulnerabilities in age-viewer package when installing from GitHub"

I am trying to install the age-viewer from GitHub by following these steps: Cloning the repository Changing directory to age-viewer Running "npm run setup" However, I am encountering issues with missing packages and 34 vulnerabilities (3…
0
votes
3 answers

Error while installing apache age viewer?

I was recently installing the apache age-viewer and I faced this issue. I have tried most of the things and nothing has worked so far. The error came up when I ran the command npm run setup Can you actually tell me what have I done wrong while…
Talha Munir
  • 121
  • 5
-1
votes
2 answers

Retrieving the graph's adjacency matrix

In graph theory, an adjacency matrix stores ones and zeros to represent edges between nodes. The number of rows and columns represents the number of vertices in the graph. The complexity to check if an edge between two nodes exists with this matrix…
Matheus Farias
  • 716
  • 1
  • 10
-1
votes
6 answers

Cannot read property 'map' of undefined when creating a graph in AGE Viewer

I have PostgreSQL 15 running with the Apache AGE extension installed on it. I can view graphs and run queries using AGE Viewer, but I get the following error when creating a new graph from AGE Viewer. I restarted AGE Viewer, but still, it didn't…