On: LiteDB – A .NET NoSQL Document Store in a Single D...

[rakoo]

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

[fnayr → rakoo]

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?

[lotyrin → fnayr]

Probably wasn't available at that time.

From the VCS history, looks like it was very first started on 2015-08-12, not sure when it became stable or part of a release.

[ioddly → lotyrin]

It's definitely only about two years old. I remember commenting on it when someone submitted the repo timeline relating to JSON on HN.