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
1 answer

Appending data to an array

I created a vertex with a property called interests and it should store an array of strings. SELECT * FROM cypher('DatingApp', $$ CREATE (v:Person { name: 'Alex', age: 27, occupation: 'Graphic Designer', …
Matheus Farias
  • 716
  • 1
  • 10
1
vote
1 answer

How to combine two or multiple existing graphs

Is there a way or query to combine data that exists within two or more existing graphs? If so, what would be the appropriate terminology to use for this?
M Jin
  • 11
  • 1
1
vote
7 answers

Apache AGE - Server terminated abnormally on missing arguments of cypher function

I ran a query on my graph using the following code: SELECT * FROM cypher('demo_graph') as (v agtype); However, I forgot to include the query argument for the Cypher function. As a result, the server closed the connection unexpectedly, and I…
Abdul Manan
  • 117
  • 5
1
vote
8 answers

Difference between oid and relfilenode

I am reading Internals of postgreSQL chp 1 and I am unable to understand the difference between object identifier and relfilenode. Tables and indexes as database objects are internally managed by individual OIDs, while those data files are managed…
Zainab Saad
  • 728
  • 1
  • 2
  • 8
1
vote
2 answers

What is the seq_name column in the ag_label table?

I'm working on a new feature that involves labels for Apache AGE and I'm looking for tools with which I can work with. In psql interface, when you input the command SELECT * FROM ag_catalog.ag_label; the following output is shown: name …
Marco Souza
  • 296
  • 7
1
vote
2 answers

Select All graphs from Apache Age

How do I choose all of the graphs in Apache Age? I am encountering difficulty in selecting all of the graphs in Apache AGE. I have attempted to do so but have been unsuccessful
Fahad Zaheer
  • 47
  • 1
  • 7
1
vote
1 answer

Adding a existing label to parent list on create_vlabel function throws ERROR : column "id" inherits conflicting default values

I changed the create_vlabel function so that the new vertex label inherits from an existing label. Here is the block of code that allows this inheriting functionality: // checking if user has provided the parent's name list. if…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
6 answers

How can we create undirected edge between two nodes in apache age graph database

How do I connect undirected edge between these 2 nodes as follow : SELECT * from cypher( 'munmud_graph', $$ CREATE (v:Country {"name" : "Bangladesh"}) RETURN v $$ ) as (v agtype); SELECT * from cypher( 'munmud_graph', $$ CREATE…
Moontasir Mahmood
  • 107
  • 5
1
vote
0 answers

Rerender a QT library GUI component in Golang when new data is inserted in to postgresql database

I have created a desktop application in Golang which I call a function handleSection(layout *widgets.QVBoxLayout) which reads rows from a table in postgresql database, and for each row it creates a new `widgets.NewQGroupBox2` and then add…
Kamlesh Kumar
  • 351
  • 1
  • 7
1
vote
1 answer

APACHE AGE index creation understanding

where are indexes created in AGE extension on Postgres since normally indexes are created on every column where we create index. But in case of AGE since its graph-based so there are nodes and edges so how does indexes work in this scenario ?? Since…
umerFreak
  • 9
  • 2
1
vote
1 answer

Apache AGE - How to delete a label table properly?

From AGE's source code, there is a function from the label_commands.c file which is called drop_label and I suppose that it deletes the table containing the label name. However, when I delete a vertex that is the only vertex of a label, it's table…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
1 answer

How can I create a table using a query on a graph database such that the node properties become the fields in the table?

I am using AGE and I want to create a table from the data stored in the nodes. The nodes in my graph database have properties that store data about the node. I need to write a query that returns the node data in a tabular format, with each property…
Abdul Manan
  • 117
  • 5
1
vote
2 answers

Can we get graphID(Oid) of a graph on postgresql terminal

I have created a graph called 'cyc_graph', Now I'm testing to see if I can insert some vertices in this graph using the agtype_build_map function, but this function requires graphID as a parameter. So How can I get the graphID of a graph already…
Kalyan Kumar
  • 48
  • 6
1
vote
1 answer

How Apache AGE simultaneously performs the queries for relational data and graph data?

It is mentioned as a feature of Apache AGE that it simultaneously performs the queries for relational data and graph data. I went through Apache AGE Website and seen this as a feature on Apache-AGE that it is Hybrid query technology which…
fatima raza
  • 13
  • 6
1
vote
3 answers

Implement Dijkstra Algorithm using cypher query in apache age

I have a graph named "CITIES" which contains vertices which are cities themselves and edges between those cities and there is one property on those edges which is the distance between the edges. I want to find shortest path between any 2 cities…
Muhammad Zahid
  • 154
  • 8
1 2 3
…
27 28