graph-databases Questions

While installing Apache AGE 1.3.0 , fatal error: parser/cypher_gram_def.h: No such file or directory – Postgresql

April 8, 2023
Kamlesh Kumar
2 Answers

I have configured and installed PostgreSQL V13.5, using: wget https://ftp.postgresql.org/pub/source/v13.5/postgresql-13.5.tar.gz && tar -xvf postgresql-13.5.tar.gz && rm -f postgresql-13.5.tar.gz ./configure --enable-debug --enable-cassert --prefix=$(pwd) CFLAGS="-ggdb -Og -fno-omit-frame-pointer" make install Then I cloned Apache-age release/PG13/1.3.0 from: https://github.com/apache/age/tree/release/PG13/1.3.0 Now I am trying to configure…

VIEW QUESTION

How can I declare Primary Key in Apache AGE – Postgresql

April 1, 2023
Muneeb Khan
3 Answers

Here, I am creating a SoftwareEngineer node. I want to ensure that only one SoftwareEngineer can exist against one SocialSecurityNumber. How can I achieve this functionality using Apache AGE? test=# SELECT * FROM cypher('staff_details', $$ CREATE(e: SoftwareEngineer { name: 'Muneeb',…

VIEW QUESTION

How and where data is actually stored in Apache AGE? – Postgresql

March 23, 2023
Muneeb Khan
2 Answers

As Apache AGE is an extension to PostgreSQL. I am curious about how and where the data of vertices (nodes) and edges are stored in Apache AGE. Does it use PostgreSQL for this? If yes, then how.

VIEW QUESTION

Why size() runs faster than length() when querying for the length of the path between two distant vertices? – Postgresql

March 22, 2023
Matheus Farias
2 Answers

I have a graph with multiple vertices and each of them represent an article from Wikipedia. The edges represent which article the first link of the current article text leads to. The article that is related to every other article…

VIEW QUESTION

Count the number of edges between one vertex to another – Postgresql

March 22, 2023
Matheus Farias
2 Answers

I have a graph that represents how Wikipedia articles are related to one another following the "Getting to Philosophy" phenomena, which is based on clicking on the very first link in the main text of an article, and repeating this…

VIEW QUESTION

Two Edges are getting Created ; On creation of single Directed Edge – Postgresql

March 6, 2023
Muneeb Khan
2 Answers

When I create a single directed edge, two edges are getting created. I have a graph named, staff_details. I created two vertices. First Vertex: SELECT * FROM cypher('staff_details', $$ CREATE (:Employee {name: 'Geyoung Ha', title: 'Project Lead'}) $$) as (n…

VIEW QUESTION

Postgres extension AGE not getting loaded – Postgresql

January 28, 2023
Hrishikesh Mallick
3 Answers

After starting the Postgres server process for a cluster: bin/pg_ctl -D demo -l logfile start Starting a process for a database 'demo': bin/psql demo When I try to load AGE extension by LOAD 'age'; It shows error that access to…

VIEW QUESTION

Apache AGE- How to read a CSV File – Postgresql

January 17, 2023
Muhammad Zahid
4 Answers

I am using apache age and I have a CSV file with a bunch of data in it. I want to populate my graph using the information in the csv file, so can anyone help me with this, and also…

VIEW QUESTION

How to install AGE extension of postgresql from source code in ubuntu?

January 12, 2023
Moontasir Mahmood
3 Answers

As I want to try out Apache Age of postgresql, I got lost when reading the documentation. Is there any easy solutions ?

VIEW QUESTION

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

January 9, 2023
Matheus Farias
3 Answers

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…

VIEW QUESTION