I'm looking for suggestions for an in-memory database or other type of store that syncs to the file system (preferably as a single file) to store small, text-only documents (notes) and additional metadata.
It should preferably be made purely with Rust and have no dependencies to outside libraries like SQLite (without the dependency to the sqlite library in the system it would be my first choice). Also it shouldn't depend on any server/service running in the system.
It should support relational data (but not necessarily relational as in SQL and relational databases) to allow fast and easy searching and retrieval of data.
So far I (from the crate descriptions only) I found RedDB. the rql crate looks promising, too, even though I'll have to write the sync to the filesystem myself.
Are there more suggestions?
I'm not a big fan of memory-only stores, but I believe sled is entirely in memory. @asonix@lemmy.ml is that correct? Its key-value, so not SQL-like, so maybe not the best for your use case.
I do really recommend using sqlite, or if its server-based, postgres. These aren't written in rust obvi but they have great performance, and there are plenty of rust libraries to talk to them.
Also if your use case is storing text-documents, I def would not use a memory store.
Sled is my go-to key value store in Rust. It flushes to disk every 500ms by default iirc
It also has .flush() and .flush_async() to flush inline with your application if you need that