Stack Overflow
Stack Overflow

Questions tagged [agens-graph]

AgensGraph is a graph database based-on PostgreSQL. It is a robust and fully-featured graph database. AgensGraph can store graph data with relational data. And it also process Cypher and SQL queries and two query languages can be integrated in a single query.

Resources

114 questions
1
vote
1 answer

Is AgensGraph heavy compared to the other graph database?

I have a question while I'm using AgensGraph. I know the AgensGraph is developed based on PostgreSQL. So I thought it might be heavy because PostgreSQL is included into AgensGraph. But I didn't feel like it's heavy when I use it. Just that is what…
Kevin Lee
  • 121
  • 7
1
vote
1 answer

AgensGraph recommended memory parameters and hardware sizing

I've been playing with a beta version(0.9) of AgensGraph for the last few weeks. Now, I am testing the product on my VM machine(with 2 cores and 2gb memory), and planning to install the product on a real server(x86_64 with 32 cores and 96gb…
KingKwan
  • 43
  • 6
1
vote
1 answer

Which type of data can be stored in Agens Graph (Graph database)?

I read the documentation about Agens Graph. Your graph database is based on PostgreSQL, right? So I think your solution is operating anywhere including general RDBMS features. Then I have a question for data type. How can be stored in Agens…
Kevin Lee
  • 121
  • 7
0
votes
0 answers

String 'TEXT' format in OCINumberFromText Function

OCINumberFromText(errhp, (const oratext*)"-1e125", (ub4)strlen("-1e125"),(const oratext*)NULL, 0, (const oratext*)NULL, 0, &smallest_number); EXPECT_EQ(status, OCI_SUCCESS); I have given a very small number in "-1e125" TEXT format running…
Muhammad Suhaib
  • 23
  • 4
0
votes
2 answers

How to visualize the Apache-age graph schema at abstract level?

I am working on a task to visualize the schema of a graph inside a database in age viewer. So I need an abstract visualization that shows all the unique nodes inside a graph, and possible edges in between those nodes. For example in agCloud at…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
9 answers

How to use SQL with Agens Graph in AGCloud's AGViewer if possible

I'm trying to use the SQL syntax in Agens Graph but I don't know to use it. I tried the following query SELECT * FROM MATCH result = ()-[]->() RETURN result; Or SELECT * FROM GRAPH MATCH result = ()-[]->() RETURN result; but both gives me the…
Muhammad Farooq
  • 204
  • 10
0
votes
7 answers

Cannot create node with label `User` in AGCloud

I'm using AGViewer on cloud with AGCloud, and I can not create a Node with Label User. I tried to create a Node with label User using the following query Create(u:User {name: 'user1', email: 'user1@email.com', phone: '1234-5678'}) RETURN u but I…
Muhammad Farooq
  • 204
  • 10
0
votes
5 answers

How to load elabels or vlabels from the name of CSV file in Apache-age

When loading edges or vertex from a CSV file in Apache-age We have to create Elabels and Vlabels manually and then mention those in queries for loading data. So the query becomes SELECT create_vlabel('agload_test_graph', 'Country'); //to create…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
0 answers

How do I create multiple postgres extensions inside docker-compose?

I have to deploy postgresql:12 with postgis and agensgraph extensions using docker-compose. Separetely they are installed well, here is my yml file: for postgis docker-compose.base.yml version: '3.4' services: db: image:…
Владимир Фадеев
  • 1
  • 2
0
votes
0 answers

Filtering on patterns in AgensGraph

I'm having a hard time filtering by patterns in AgensGraph. According to the Cypher Query Language Reference I should be allowed to filter on patterns using NOT. However, this does not seem to work in AgensGraph. CREATE (eric:person {name:'Eric'}),…
filiphl
  • 921
  • 1
  • 8
  • 15
0
votes
0 answers

OGM for Agensgraph Database

Is there any known OGM for Python out there, that can be used on AgensGraph Databases?? I surely found GQLAlchemy (only supports neo4j and Memgraph), Goblin (for TinkerPop and async operations) and the various drivers for neo4j and agensgraph…
Robert
  • 652
  • 2
  • 11
  • 23
0
votes
1 answer

Agensgraph, graph databases, web development and webgis, advice on which way to go?

More of an advice question here. I'm well versed in Postgres/PostGIS, so I thought I'd look at Agensgraph aka Apache Graph Extension (AGE). This is a graph implementation in Postgresql which uses SQL for 'read-only' querying, but Cypher for pattern…
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
0
votes
1 answer

creating dynamic updates in Agensgraph via Cypher

trying to create a function like :- addChild(parent graphid,child graphid,relationship text,direction text) merge(parent)-[r:f(relationship)]->(child) return id(r); with a typical cal : relid=addChild(id(a),id(b),'has','U') -- where U means up…
howlingengines
  • 1
0
votes
1 answer

Save DOM tree into a graph database: Connect related nodes

I'm inserting hierarchical data made of a DOM Tree into a graph database but, I'm not able to obtain the parent's ID which is needed to create a relationship between the child and its parent's id. Below is the code that illustrates a traversing of…
alexander
  • 107
  • 9
0
votes
2 answers

Simplifying cypher, match all nodes and relationships between two node types

Is there anyway to further simplify this query? I want to go from kingdom to all the species, there are nodes related towards the species nodes. The image shows the result of this query, but is there any way to match the kingdom node and all the…
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
1 2
3
4 5 6 7 8