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

Graph path not visible in AGE Viewer

I am trying to visualize the queries of a graph created in AGE using AGE Viewer but I can't see the graph I created. This is the issue I followed the exact steps to visualizing a graph using npm run setup followed by npm run start. How can I solve…
Tito
  • 289
  • 8
1
vote
7 answers

Updating all the nodes with single cypher query

Consider that I'm working on a graph database and there are some nodes at some label i.e labe14 and now what I want to do is to update the properties of all the nodes and add the another one at once to each of them. How could it be done? To add or…
1
vote
11 answers

Getting "pg:ctl could not start server" error while installing Apache-Age

I am reinstalling Apache Age and when i am following the Age github doucmentation guide to install Apache Age. Everthing is working fine till that command. cd age/ install sudo make…
1
vote
13 answers

What is the SQL statement of the MATCH clause on Apache AGE?

If I understand this correctly, every query that is sent when using the Apache AGE extension is being parsed, analyzed, rewritten, and it eventually becomes an SQL statement that is being run in the backend process for postgres to actually execute…
1
vote
1 answer

Optimizing the performance in Apache Age

I have seen that AGE is good for graph projects but while doing something I was getting few performance issues with some Queries. Now I really want to really optimize the Apache age in order to minimize the usage of the resource and increase the…
1
vote
4 answers

Importing a CSV or JSON file into age viewer Apache

As I was working and seeing through the apache age viewer. This question regarding a data analysis project has come to my mind like how to use the apache age viewer to import this data in CSV or JSON format. What's the best method so that I can…
1
vote
1 answer

On PostgreSQL, how can I alter a table to make it an inheritor from multiple parents?

I am working on creating a function in C-language in Apache AGE extension that performs an ALTER TABLE command to inherit from a parent table. According to the PostgreSQL documentation for CREATE TABLE, the INHERITS keyword can take a list of parent…
Marco Souza
  • 296
  • 7
1
vote
2 answers

How is a vertex or edge assigned a graphid in Apache-Age

I was working on the internals or architecture of Apache-Age and i know that how graph, vertex, or edge is created in Apache-Age but i am confused how it's been assigned an graphid in the memory. For Graph Creation: SELECT…
1
vote
4 answers

How are properties of a vertex or edges stored in Apache AGE?

Where are the properties of the vertices and edges stored in the Apache AGE and what data structures are used for the purpose? I know that the vertex and edges are stored in their respective tables _ag_label_vertex and _ag_label_edge. These tables…
abhishek2046
  • 312
  • 1
  • 11
1
vote
1 answer

Function cypher(unknown, unknown) does not exist in Apache AGE

I am trying to execute a Cypher query on my Apache AGE graph database using the cypher function in PostgreSQL, but I am encountering an error. Here is the query I am trying to run: SELECT * FROM cypher('g1', $$ MATCH (n) return n $$); And here is…
Omar Saad
  • 349
  • 3
  • 8
1
vote
7 answers

Updating properties of an AGtype vertex without affecting other properties or connected entities in a social network graph using Apache AGE

I am currently working on a social network graph using Apache AGE with PostgreSQL, where I have vertices representing users and edges representing the relationships between them (e.g., "friend" or "follower"). Each vertex has several properties,…
1
vote
2 answers

How to Access Index of Array in the properties of AGE Vertex When passed to PG_Catalog Function

I have created a vertex student: test=# SELECT * FROM cypher('graph', $$ CREATE (s:student{name:"Muneeb", courses: ["OOP", "DS", "Programming", "Android"]}) RETURN s $$) as (student…
1
vote
4 answers

Executing an age Query using Npgsql and returning results in .NET application?

I'm working on a.NET 7.0 application that needs to query a PostgreSQL database using Apache Age. To connect to the database, I'm using the Npgsql package. I've successfully connected to the database with Npgsql, but I'm not sure how to run an Age…
1
vote
2 answers

Node.js ERR_OSSL_EVP_UNSUPPORTED error when running npm run start

I'm encountering an error when trying to run npm run start on my Node.js project. The error message I'm seeing is: ex.js:59:103 { opensslErrorStack: ['error:03000086:digital envelope routines::initialization error'], library: 'digital envelope…
AmrShams07
  • 96
  • 1
  • 7
1
vote
7 answers

Vertices and edges in apache age?

I have been working on Apache age and have a question on my mind. How are vertices and edges stored in Apache age i.e what kind of data structure is used by age to store vertices and edges and how can you actually retrieve all the vertices and edges…
Talha Munir
  • 121
  • 5