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
votes
11 answers

How to perform a wildcard search in PostgreSQL

I am working with a PostgreSQL database and I need to perform a wildcard search in a specific column. How can I write a query to achieve this? I have a table called customers with a column name that stores customers names. I want to search for…
Prachi
  • 39
  • 3
-1
votes
5 answers

Retrieving OID values for label relations in Apache-age graph using Postgres

I'm currently working on an Apache-age graph and need to retrieve the OID values for the label relations in the graph. I'm using Postgres to manage my database and have tried querying the ag_labels schema, but it doesn't seem to contain the OID…
Mahina Sheikh
  • 43
  • 5
-1
votes
2 answers

failed to find Vite server URL while running front end of apache age viewer Desktop (Go)

I'm trying to run front end of the Age-viewer-go on ubuntu 22.04 using the wails dev command in age-viewer folder of the project. but it gives the following error as shown in the image failed to find the Vite server URL
Muhammad Farooq
  • 204
  • 10
-1
votes
13 answers

Window Functions in Apache Age

I was looking over the window functions and wanted to know if we can use window functions like (rank, dense_rank, ntile etc.) in Apache-age. If yes, is there any practical example of using them. I am looking for window functions in graph databases…
Umer Freak
  • 21
  • 3
-1
votes
3 answers

Variable Edges Query

Can anyone explain with just words how this query works? SELECT * FROM cypher('graph_name', $$ MATCH p = (actor {name: 'Willam Defoe'})-[:ACTED_IN*2]-(co_actor) RETURN relationships(p) $$) as (r agtype); It's quite confusing and not very…
Peter
  • 43
  • 4
-1
votes
7 answers

Is there a way I can create nodes and edges with random values using Apache AGE?

While running some tests, I was looking for a way that can generate random nodes and edges with random values. I know in postgresql there are some helper functions like random() and generate_series() that can be used to fill in the table easily but…
ahmed_131313
  • 142
  • 6
-1
votes
7 answers

npm install fails with 'Object for dependency is empty' error in ag-viewer setup script

I want to setup the apache-age viewer with npm but when i execute the command npm run setup it gives me the following error. > ag-viewer@0.0.1 setup-front /home/Desktop/age-viewer > cd frontend && npm install npm WARN read-shrinkwrap This version…
Mohsin
  • 3
  • 2
-1
votes
6 answers

create_graph Function does not works

I have done: test=# SET search_path = ag_catalog, "$user", public; But still I can not use create_graph function directly. test=# create_graph('university'); ERROR: syntax error at or near "create_graph" LINE 1: create_graph('university'); Why I…
Muneeb Khan
  • 1
  • 11
-1
votes
4 answers

How to retrieve all the details(vertexs, relationship) of all graphs avaliable in a database in apache age

I am connected to a database named 'testdb' using the PSQL utility with the 'age' extension loaded, How can I retrieve all the details(vertexes, relationship) of all graphs available in a database and also the number of graphs present in apache…
Kamlesh Kumar
  • 351
  • 1
  • 7
-1
votes
3 answers

Apache AGE - How can I write a function in Apache AGE to avoid repeatedly writing the same query over and over again?

I have a graph in which I need to execute similar queries repeatedly. I would like to be able to pass parameters to the function and have it return the results. For instance, let's suppose I have a graph of movies and actors in which I want to find…
Abdul Manan
  • 117
  • 5
-1
votes
2 answers

How can I migrate an existing Neo4j graph database to Apache Age?

how do I transfer an existing graph database in Neo4j to Apache Age. A step by step guide will be greatly appreciated. I am a beginner. I couldn't find the solution online.
Muhammad Awais Bin Adil
  • 51
  • 4
-1
votes
2 answers

How to set Wails path for Go on Mac?

I'm trying to use Wails with Go on my Mac, but I'm having trouble setting the correct path. I have installed both Wails and Go, but when I try to build my Wails application using wails build, I get an error message saying "Go not found on path." How…
MOIEZ IBRAR
  • 39
  • 5
-1
votes
2 answers

Error while building Postgres 12.14 from source: fatal error: utils/errcodes.h: No such file or directory

I built the same version of postgres from source successfully a month ago. However, upon resetting my machine and trying to build the same version again, I'm having problems. When I try to run make I get the following…
tokamak32
  • 27
  • 7
-1
votes
9 answers

Apache AGE installation: Could not find extension/age.control

I am trying to install Apache AGE by following link. It worked successfully when I installed it on Ubuntu 22.04. But when I tried to install it on WSL also with Ubuntu 22.04, it didn't give any error during make install but when used installcheck it…
abhishek2046
  • 312
  • 1
  • 11
-1
votes
6 answers

Get Length of agtype List/ Array

I have created this vertex: test=# SELECT * FROM cypher('graph', $$ CREATE (s:student{name:"Muneeb", courses: ["OOP", "DS", "Programming", "Android"]}) RETURN s $$) as (student…
Muneeb Khan
  • 1
  • 11
1 2 3
…
27 28