Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by infogulch on Wednesday December 20, 2017 @11:52AM
(#15971240)
SQLite can work as a document store too. Data can be any type (in spite of defined column types), and it works even for pretty big document sizes.
[ Parent
| on HN ]
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by fnayr on Wednesday December 20, 2017 @12:00PM
(#15971335)
Interesting, I did not know that. However, I use a 3rd party framework to transform the table rows to classes, and I assume I would lose all that magic conversion. In other words, the reason I go through all the effort of transforming to relational is for querying and updating, but if I just put the raw document in there, I won't have granularity on my querying (I imagine).
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by rakoo on Wednesday December 20, 2017 @12:54PM
(#15971965)
You can store everything in JSON in SQLite and then query it using json functions (https://www.sqlite.org/json1.html) or even combine than with indexes on expressions (https://sqlite.org/expridx.html) if you have a good indexable property
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by fnayr on Wednesday December 20, 2017 @01:38PM
(#15972408)
Ok this is pretty cool. This is also why I love HN. I've been using SQLite for ~3 years, have I missed this from the beginning or has it been added since then?