apache / age

Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
https://age.apache.org
Apache License 2.0
3.05k stars 407 forks source link

Query to return list of graphs #316

Open susano0 opened 1 year ago

susano0 commented 1 year ago

I feel there should be a query that would return the names of the different graphs I have created. After creating a bunch of graphs, it gets difficult to recall their names.

Creating a new query with the syntax SELECT * FROM ag catalog.get graph list() could be a solution to this issue.

Also, a further enhancement could be to associate a short description with the graph name.

TropicalPenguin commented 1 year ago

SELECT * FROM ag_catalog.ag_graph;

jrgemignani commented 1 year ago

@susano0 I'm reopening for discussion.

Should we consider creating a cypher function to do this?

In my opinion, users shouldn't need to know what tables to look at to get this information from. Just my opinion, though.

TropicalPenguin commented 1 year ago

Neo4J appears to offer such diagnostics; neatly overloaded for all vs specific graphs: https://neo4j.com/docs/graph-data-science/current/graph-list/