Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by j_s on Wednesday December 20, 2017 @02:27PM
(#15972862)
Is it possible to pre-allocate a fixed-size file with sqlite to then use as a local cache evicting old data? Supporting this may offer a chance to differentiate a bit.
Closest I could find was a workaround that is probably close enough (disable auto_vacuum and delete a giant blob) https://stackoverflow.com/a/4821318.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by SonicSoul on Wednesday December 20, 2017 @12:09PM
(#15971455)
can you elaborate on opting for Sqllite?
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by j_s on Wednesday December 20, 2017 @02:50PM
(#15973087)
Battle-tested multiplatform support (and thus reliability) is definitely a key selling point. This is further reinforced by its impressively extensive test suite.
Long ago I lost my first Android smartphone's SMS database since they used to delete + re-create even barely corrupted databases, but by now most of the kinks have been worked out.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by sametmax on Wednesday December 20, 2017 @05:50PM
(#15974612)
Plus it's amazingly fast and is packed with SQL features. For such a small lib, it's a miracle. And the way the author talks about it (he is not from a DB background) it so funny.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by cbcoutinho on Wednesday December 20, 2017 @01:25PM
(#15972291)
Sqlite is one of the simplest RDBMSs that you can run on a client, which is really useful for deploying apps that need their own data store
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by romanovcode on Wednesday December 20, 2017 @02:16PM
(#15972780)
Also Sqlite has native EF drivers which makes it first-class .NET citizen.
The API is similar to MongoDB which is great because I consider MongoDB drivers the best DB drivers for C# except for maybe EF.