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
4
votes
2 answers

How to do a 'for' loop in tables for a PostgreSQL function in C

I was thinking of developing a function for AGE that returns a graph's adjacency matrix. An adjacency matrix stores the number of edges between two nodes. The complexity to check if an edge exists within an adjacency matrix is O(1), while the space…
Matheus Farias
  • 716
  • 1
  • 10
4
votes
1 answer

How does the SQL file link to the C functions?

While going through the AGE code, I found this age-1.3.0.sql file where I believe all tables are created and all functions are declared. For example line number 94 CREATE FUNCTION ag_catalog.create_graph(graph_name name) RETURNS void LANGUAGE c AS…
Bhaskar Sharma
  • 158
  • 8
4
votes
6 answers

How do I find the data type of a cypher query result in Apache AGE?

Assuming I have a customer graph in apache AGE, and I make the following query: SELECT * FROM cypher("customers", $$ MATCH (p:person) RETURN p.first_name, p.last_name $$ ) as (first_name agtype, last_name…
moeed865
  • 304
  • 1
  • 6
3
votes
11 answers

Why I'm not able to run my Application server using "npm start" command and getting the error message related to start script.I am using Ubuntu OS

I am making a PERN stack(PostgreSQL, Express,React.JS,Node.JS) application. I downloaded the file from github repo, opened it in VS code and tried to run the server using the following command. Command: npm start But I am getting this error…
Maimoona Abid
  • 567
  • 4
3
votes
3 answers

Why I am getting error of " nodemon command not found" while setting the server of my PERN Stack Application

I am making a crud application on PERN Stack (PostgreSQL, Express,React.JS,Node.JS). In the step of setting up the server I tried to run the following command but it is not working,I installed the nodemon first using "npm install nodemon" command…
Maimoona Abid
  • 567
  • 4
3
votes
17 answers

How to create an Auto Incremented (Serial) attribute in Apache AGE?

How to create an Auto Incremented (Serial) attribute in Apache AGE ? For example in the following query I want to add a new attribute order_id that is unique and auto incremented every time I add a new order. SELECT * FROM cypher('online_orders',…
Omar Saad
  • 349
  • 3
  • 8
3
votes
1 answer

npm ERR! while running wails dev or wails build command for age-viewer-go

I need to run the age-viewer-go project when I run wails dev or wails build command in the main directory it run well but only one page is shown up with start button and that button does not work. I asked a friend he told me to run waisl dev…
Muhammad Farooq
  • 204
  • 10
3
votes
5 answers

Storing different types in vertex properties with the same name on Apache AGE

Apache AGE allows me to store values of different types in vertex properties with the same name. For example: Creating a vertex with pages = 10: SELECT * FROM cypher('books', $$ CREATE (v:Book {title: 'A book', pages: 10}) RETURN v $$) as (v…
Carla
  • 326
  • 1
  • 7
3
votes
15 answers

How to implement shortest path algorithm in Apache Age using Python and Cypher?

I'm working on a Python project that uses Apache age as the graph database, and I need to find the shortest path between two possible nodes. How do I implement this using Python? The code for node creation and the graph structure is as follows: #…
Muhammad Awais Bin Adil
  • 51
  • 4
3
votes
1 answer

Startup cost of the index scan at postgres (the internals of postgresql book)

During my reading to the book [The internals of PostgreSQL] I have been in the chapter 3 Book chapter link: https://www.interdb.jp/pg/pgsql03.html at 3.2.2. Index Scan specifically at 3.2.2.1. Start-Up Cost The following query is being explained and…
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
2
votes
11 answers

Cannot set path in Apache age

I am trying to install age with pg12 but couldnt set age path postgres=# LOAD 'age'; LOAD postgres=# SET search_path = ag_catalog, "$user", public; Output: HINT: No function matches the given name and argument types. You might need to add explicit…
MOIEZ IBRAR
  • 39
  • 5
2
votes
9 answers

error in npm start while running AGCloud Project in windows

I'm trying to run the AGCloud project on windows 10. the project is built with React JS. I cloned the main branch of the repository in my system, and then installed dependencies in both front-end and back-end using npm i command and then moved to…
Muhammad Farooq
  • 204
  • 10
2
votes
9 answers

Newly Created age_date() Function Not Recognized in Cypher Query

I created a new age_date() function using the following SQL and C code: SQL: CREATE FUNCTION ag_catalog.age_date() RETURNS cstring LANGUAGE c STABLE PARALLEL SAFE AS 'MODULE_PATHNAME'; C Code: Datum age_date(PG_FUNCTION_ARGS) { // Program…
Muhammad Abdullah
  • 1
  • 5
2
votes
7 answers

Could not deserialize ATN with version (expected 4) while using python age driver

I am trying to use python drive for age. For this, I directly imported from the age file in the driver code using from age import *. But when I ran the code, I encountered the following error: File…
abhishek2046
  • 312
  • 1
  • 11
2
votes
2 answers

How to create and iterate over a List of graphids (Apache AGE)?

I'm creating a function for Apache AGE, and I need to iterate over a List of graphids, how should I do it properly? The List I'm referring to is the PostgreSQL defined struct in this file -> Postgres' GitHub repository Link graphid is just an…
MarkSoulz
  • 33
  • 4
1
2 3
…
27 28