I am looking for a permanent keystore for .NET. Requirements:
- Storage is used for objects that are identified by strings and have several optional (named) properties with values that are only arrays of bytes. To solve SQL, I would simulate it as a single row → id table and several id tables → blob.
- The expected amount of data is a few megabytes (more than 10 MB is currently unlikely, but scaling to 100 MB would be a good bonus)
- Easy - preferably monosyllabic, of course, without external applications.
- Readings are more frequent than recordings at least 100 times.
- Fast read / write access - I expect memory in memory and lazy writing about data updates; I can periodically create asynchronous records myself, bonus points, if the storage does it.
- Atomic I / O - the database should not be interrupted if the process ends in the middle of the letter; otherwise, the data is not critical, i.e. no additional redundancy is required.
Currently, I think SQLite will work here; however, it seems to be a bit overkill - I only need memory with a key, and not full SQL support. I also heard about bdb and the libdb-dotnet binding - it seems easier, but I don't know the performance / consistency characteristics.
Can someone recommend something here? Additional links are welcome (i.e. it would be great if something in the .NET Framework could do the job), as well as experience with SQLite or libdb-dotnet (or bdb in general) or a home-made solution if it was painless .
source share