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?

  • Victor von VoidOP
    2·
    3 years ago

    I definitely don’t want a database that needs to be installed first as I want to write a tool that can be thrown at a user and is instantly usable. So PostgreSQL and similar DBs are not an option. My problem with SQLite is, that it’s not available everywhere, so I’d have to ship it with my app which again leads to a more complex setup. I’ll have a look at sled, though, thanks!

      • Victor von VoidOP
        2·
        3 years ago

        I mean: not already installed on every system. Don’t get me wrong: I like SQLite and used it in several projects. I just need something that doesn’t have to be installed/downloaded/whatever first. I just want to deploy a single executable and not worry about the dependencies.

        • pinknoise
          6·
          3 years ago

          You can statically link sqlite into your program, rusqlite has that as a feature flag iirc