Comment Comment by rklaehn Interesting. SQLite is awesome.I did something similar recently, a block store for a rust implementation of ipfs, which models a directed acyclic graph of content-addressed nodes.https://github.com/actyx/ipfs-sqlite-block-storeI found that performance is pretty decent if you do almost everything inside SQLite using WITH RECURSIVE.The documentation has some really great examples for WITH RECURSIVE. https://sqlite.org/lang_with.html parent rklaehn 5 years ago
I did something similar recently, a block store for a rust implementation of ipfs, which models a directed acyclic graph of content-addressed nodes.
https://github.com/actyx/ipfs-sqlite-block-store
I found that performance is pretty decent if you do almost everything inside SQLite using WITH RECURSIVE.
The documentation has some really great examples for WITH RECURSIVE. https://sqlite.org/lang_with.html