Happy to have inspired 😀 Having a real DB that juggles between memory and disk and saves the indexes sure makes sense.
I could try and see if nostr-social-graph could use indexeddb and not have to load everything into memory on app start. For native, I've made a social graph pull request to nostrdb: https://github.com/mmalmi/nostrdb
Login to reply
Replies (1)
That's pretty cool! I'll do some testing around your nostrdb fork. However, due to the requirements of the project, I'll continue with DuckDB as it has a good set of features to better handle resources in resource-constrained environments. It's also an OLAP DB, which makes sense for social graph operations, and to cross that with other data in the same db. I've also discovered the pgq extension of DuckDB, which is pretty interesting but is not yet supported in the current latest version. It could also help for this