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

How can I implement Object-Graph Mapping (OGM) in a graph database using AGE?

I am using a AGE and its JDBC driver, and I want to implement Object-Graph Mapping (OGM) in my application. I have a graph database of employees where nodes represent Person, City, and Department. In my Java application, I want to map these nodes to…
Abdul Manan
  • 117
  • 5
2
votes
1 answer

Can't see the first property of a node on Age Viewer

I have created a Book node called Book as follow: Select * FROM cypher('graph_two',$$ CREATE (n:Book {title:'Something'}) $$) as (a agtype); And a person Node as follows: Select * FROM cypher('graph_two',$$ CREATE (n:User {Name:'Something'}) $$) as…
Muhammad Zahid
  • 154
  • 8
2
votes
2 answers

Is it possible to create a graph in AGE using existing table in the database?

I have just started with Apache AGE extension. I am exploring the functionalities of graph database. Is there a way to create a graph from existing tables/schema such that the table becomes the label and the attributes become the properties for the…
Abdul Manan
  • 117
  • 5
2
votes
3 answers

Apache AGE- How to Implement relationship between 2 graphs

If we have 2 graph databases 'A' and 'B' and currently there is no relationship between nodes A graph database and B graph database, and now I have to add a relationship between a node of A and a node of B then how woud I do that using AGE. E.g A…
Muhammad Zahid
  • 154
  • 8
2
votes
6 answers

How to return vertices from different graphs on a single query with ApacheAGE?

I wanted to retrieve all the vertices from two different graphs I've created (one is called family_tree and the other is taxonomy_biology) and used the following command to do so : SELECT * FROM cypher ('family_tree' AND 'taxonomy_biology', $$ MATCH…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
3 answers

How can I return dynamically created matrices in functions written in C for PostgreSQL?

I was developing a function for Apache AGE that allows us to store graphs, a PostgreSQL extension, to return an adjacency matrix from a given graph. I used SPI to connect to the database and to retrieve the data from some queries with it. The…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
1 answer

Resolving shift/reduce conflict in Cypher parser caused by SET clause defined in multiple rules

I'm working on a project to support Cypher clauses in Postgres psql. All PostgreSQL and Cypher commands will pass through Cypher's parser. For more details, see the following Q&A: How to differentiate a Cypher clause from an SQL clause in C?. In…
Carla
  • 326
  • 1
  • 7
1
vote
5 answers

ANTLR4 Python failed to install and cannot establish a connection

I am trying to install the requirements of Apache AGE Python driver. Whenever it comes to installing the antlr4-python3-runtime, it fails. I install the packages through: pip3 install -r requirements.txt This gets the following: Collecting…
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
1
vote
5 answers

Error when compiling libpq program in Docker: 'fatal error: libpq-fe.h: No such file or directory

I am trying to compile a C program that uses libpq library in a Docker container. Here's my Dockerfile: FROM ubuntu:latest RUN apt-get update && \ apt-get install -y build-essential libpq-dev WORKDIR /app # Copy the source files into the…
AmrShams07
  • 96
  • 1
  • 7
1
vote
3 answers

Inserting values of different types in an array, transforms them into wrong data

I've created a function in C language to AGE that converts a list of elements into a new list of string elements, based in toStringList of opencypher. When I insert diferent data types in an array in a C inside my AGE, the returned array modifies…
Marcos Silva
  • 115
  • 5
1
vote
7 answers

Install AGE & PSQL from Source

I am installing AGE by following this link: https://theundersurfers.netlify.app/age-installation/ All the rest steps are done successfully but I a facing an error while installing AGE from the repo; git clone https://github.com/apache/age.git.. Till…
saima ali
  • 133
  • 9
1
vote
1 answer

Improve execution time of SELECT * from table using psycopg2

I have a table with around 70000 rows, and I am trying to load the entire table in Python using the psycopg2 module. When I use this code, it takes around 110 seconds only to load the table. with conn.cursor() as cursor: …
abhishek2046
  • 312
  • 1
  • 11
1
vote
15 answers

How to Change Postgres Version using ubuntu 18.04

I have multiple versions of PostgreSQL installed in my ubuntu version 18.04 and my extensions are saved in Postgresql version 12 but when I run: sudo -u postgres psql command to enter Postgres and creating extensions by entering command create…
Pawan Kukreja
  • 3
  • 8
1
vote
6 answers

Error in make install while installing Apache-AGE from source missing PGXS

Error : Makefile:120: /usr/lib/postgresql/12/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory make: *** No rule to make target '/usr/lib/postgresql/12/lib/pgxs/src/makefiles/pgxs.mk'. I'm using pgenv for postgreSQL version management,…
Sarthak
  • 380
  • 7
1
vote
1 answer

How to create custom data types for AGE?

AGE has a custom data type called agtype, which, according to AGE's documentation, it is the only data type returned by AGE and it contains data like the JSON format. Vertices and Edges are store as follows: -- Vertex {id:1; label: 'label_name';…
Matheus Farias
  • 716
  • 1
  • 10
1 2
3
…
27 28