How about supporting graph analysis?

[sharefantasy]

Brief Abstract

How about using some kind of graph analyzer to support note manangement

Long Description

I'm interested in using some kind of brain dump style to write notes, and tagging it by instinct. Then I'll use org-roam-server to review the entire graph and fix some links, do some clustering manually. It should be difficult to continue this workflow after the entire diagram grows larger and more complex.

Proposed Implementation (if any)

how about neo4j?

Please check the following:

• No similar feature requests

[alan-carroll]

You are not alone in graph analysis! Check out the discourse topics if you haven't already: https://org-roam.discourse.group/c/dev/graph/8

While I can't speak for everyone, obviously, I think the sheer practicality of sqlite compared to neo4j means it is here to stay. Personally I also want a graph-based db, and I searched far and wide for something that could be the 'sqlite of graph databases' -- nothing came up for me.

[kennethbruskiewicz]

@alan-carroll You can do graph analysis on table records. Graph databases use a list of tuples as a representation.

Also this would be cool. PageRank is an obvious choice of analysis to be done on Roam notes.

[alan-carroll]

I just like the schema and query language. You can do everything in SQL, but I like writing eg. Cypher a lot more than SQL 😄

[sharefantasy]

You are not alone in graph analysis! Check out the discourse topics if you haven't already: https://org-roam.discourse.group/c/dev/graph/8

While I can't speak for everyone, obviously, I think the sheer practicality of sqlite compared to neo4j means it is here to stay. Personally I also want a graph-based db, and I searched far and wide for something that could be the 'sqlite of graph databases' -- nothing came up for me.

Hey! Thank you for that discourse! I haven't participate in it yet.

Well, I can't find an opensource file-base graph db at present. all the existing choices are for big companies with commercial usage. Sqlite is irreplaceable at the moment, maybe a cypher syntax import and export function will be much more practical.

[sharefantasy]

@alan-carroll You can do graph analysis on table records. Graph databases use a list of tuples as a representation.

Also this would be cool. PageRank is an obvious choice of analysis to be done on Roam notes.

SQL is good but it has its limit on multiple foreign key relation chains. Roam notes are naturally graphs. So it's better to use graph language to describe and extend.

[tbsexton]

I might suggest Redis Graph; it's lighter weight, and utilizes cypher as well, in case anyone wishes to transition to e.g. Neo4J down the line.

Also, the analytics can be easily done redis-side, since it's built on the incredibly efficient graphBLAS (sparse matrix Lin. Algebra).

Edit: I forgot, the new version now includes full text-search within the graph, which is obviously of use here.

[sharefantasy]

I might suggest Redis Graph; it's lighter weight, and utilizes cypher as well, in case anyone wishes to transition to e.g. Neo4J down the line.

Also, the analytics can be easily done redis-side, since it's built on the incredibly efficient graphBLAS (sparse matrix Lin. Algebra).

Edit: I forgot, the new version now includes full text-search within the graph, which is obviously of use here.

Full-text search is a big merit. I'm thinking about introducing ElasticSearch as well, but it looks rather overwhelmed.