Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by DenisM on Wednesday December 20, 2017 @11:19AM
(#15970896)
What is the advantage over SQLite?
[ Parent
| on HN ]
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by mataniko on Wednesday December 20, 2017 @11:50AM
(#15971231)
I needed a small for my C# MAME frontend IV/Play, it didn't matter if it was relational on not. I picked this over SQLite because it's a single native DLL with no dependencies. It also supports POCO mappings (think serialization) which usually requires some ORM type package.
SQLite in .NET is still a little messy - there are several versions in various state of support, and they all depend on multiple packages.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by fnayr on Wednesday December 20, 2017 @11:41AM
(#15971124)
I am developing a mobile game and the BaaS we use (Gamesparks) uses MongoDB. Currently I use SQLite to cache the data locally, but that can be a pain to transform document formatted data to relational, and back. I wish I had known about this before (and I use Unity so the app code is C#).
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.
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?
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by lotyrin on Wednesday December 20, 2017 @02:37PM
(#15972948)
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.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by ioddly on Wednesday December 20, 2017 @05:14PM
(#15974355)
It's definitely only about two years old. I remember commenting on it when someone submitted the repo timeline relating to JSON on HN.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by j_s on Wednesday December 20, 2017 @02:34PM
(#15972929)
Back in the dark ages as everyone upgraded from 32-bit to 64-bit environments, shipping two versions of native dependencies caused extra hassle. However, this may not be much of an issue these days.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by zwerdlds on Wednesday December 20, 2017 @11:26AM
(#15970966)
I don't know for sure, but I believe it would be that SQLite is relational, this is NoSQL (document key/value store)
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by simlevesque on Wednesday December 20, 2017 @11:26AM
(#15970967)
It's native and NoSQL.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by dumbfounder on Wednesday December 20, 2017 @12:08PM
(#15971445)
NoSQL is not a feature, it is the lack of a feature.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by Clubber on Wednesday December 20, 2017 @01:28PM
(#15972321)
This car is a NoTires car! You don't have to go through the hassle of replacing your tires! :)
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by interfixus on Wednesday December 20, 2017 @01:46PM
(#15972495)
Any day, if someone invents wheels for the twentyfirst century. The rubber-rings are a kludge, not a fundamental condition of life.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by simlevesque on Wednesday December 20, 2017 @06:39PM
(#15974930)
Says you.
Re:LiteDB – A .NET NoSQL Document Store in a Single Data File
by manigandham on Wednesday December 20, 2017 @05:19PM
(#15974399)
"NoSQL" is a meaningless term. Even when strictly taken as either not supporting SQL or not relational, it is a rather useless way to search for options.