Comment by nnnnico
3 years ago
Im thinking about making my own solution too using sqlite!
how do you handle graph queries and looping/traversal?
I am also wondering how i will sync across devices (in my case im thinking of a browser based ui with absurd-sql), probably will just start with the new filesystem api and syncthing or similar alternatives.
> Im thinking about making my own solution too using sqlite!
Me too. I see no problem in querying it and manipulating data. I don't really care about syncing. What I consider the most interesting and problematic are rendering the actual graph and the data, especially an anesthetic and interactive way. Because what I do NOT want to do is another browser/electron-based tool. I am only interested in desktop-native development but I have never seen components relevant to this subject. Apparently they are yet to be developed.
Sqlite supports recursive queries. It is clumsy and not too easy to write, but it works.
For syncing, what I did was to implement a simple automatic backup logic. Then if I want to move to a new device, I just copy the backup I want, which is just a sqlite db file, and restore it. It is not ideal if you are moving from device to device constantly, but it has the benefit that you can compare backups to see what exactly you have changed (I even wrote a tool to build graph visualizations from the output of sqldiff).