{"id":4053,"date":"2016-06-18T20:15:32","date_gmt":"2016-06-18T20:15:32","guid":{"rendered":"http:\/\/putridparrot.com\/blog\/?p=4053"},"modified":"2016-06-18T20:15:32","modified_gmt":"2016-06-18T20:15:32","slug":"embedded-nosql-with-litedb","status":"publish","type":"post","link":"https:\/\/putridparrot.com\/blog\/embedded-nosql-with-litedb\/","title":{"rendered":"Embedded NoSQL with LiteDB"},"content":{"rendered":"

I was looking for a simple file based object\/document database and came across LiteDB<\/a>. This gives similar functionality to MongoDB.<\/p>\n

If you’re looking for good documentation on LiteDB, I would suggest going to Getting Started<\/a>. I’ll undoubtedly duplicate some\/much of what’s written there in this post which is mainly aimed at reminding me how to get up and running with LiteDB.<\/p>\n

Getting started<\/strong><\/p>\n

It’s so easy to get started with LiteDB. Let’s first define an object model for some data that we might wish to store.<\/p>\n

\r\npublic class Artist\r\n{\r\n   public string Name { get; set; }\r\n   public IList<string> Members { get; set; }\r\n}\r\n\r\npublic class Album\r\n{\r\n   public int Id { get; set; }\r\n   public Artist Artist { get; set; }\r\n   public string Name { get; set; }\r\n   public string Genre { get; set; }\r\n}\r\n<\/pre>\n
We need an Id property or a property marked with a BsonId attribute on our POCO object. Whilst we can get away without this for some operations, updates (for one will fail) without the Id property\/BsonId.<\/em><\/p>\n
To use LiteDB, simply install the nuget package LiteDB<\/em> and now here’s the bare minimum to create\/open a LiteDB database file and get a reference to the collection for our CRUD operations<\/p>\n
\r\nusing (var db = new LiteDatabase("Albums.db"))\r\n{\r\n   var albums = db.GetCollection<Album>("albums");\r\n   \/\/ now we can carry out CRUD operations on the data\r\n}\r\n<\/pre>\n
Easy enough. The LiteCollection<\/em> returned from GetCollection<\/em> allows us to to work on our data in a very simple manner. <\/p>\n
For example, let’s insert a new album<\/p>\n
\r\nalbums.Insert(\r\n   new Album\r\n   {\r\n      Artist = new Artist\r\n      {\r\n         Name = "Led Zeppelin",\r\n         Members = new List<string>\r\n         {\r\n            "Jimmy", "Robert", "JP", "John"\r\n         }\r\n      },\r\n      Name = "Physical Graffiti",\r\n      Genre = "Rock"\r\n   });\r\n<\/pre>\n
How about retrieving all the data, we can use<\/p>\n
\r\nvar results = albums.FindAll();\r\n<\/pre>\n
We can also query for specific data using a predicate, for example<\/p>\n
\r\nvar r = albums.Find(a => a.Artist.Name == "Alice Cooper");\r\n<\/pre>\n
Note: in this example, the Artist.Name property has not been indexed, so performance would be improved by setting an index on the data.<\/em><\/p>\n
To update we need to get the instance from LiteDB (or at least know the Id) and then makes the changes as follows<\/p>\n
\r\nvar zep = albums.Find(a => a.Artist.Name == "Led Zeppelin").First();\r\nzep.Artist.Members[2] = "John Paul Jones";\r\nalbums.Update(zep);\r\n<\/pre>\n
Obviously in the above we’re assuming there’s at least one item (by calling First() as obviously there might be zero, one or multiple returns), the key is how we simply call the Update method.<\/p>\n
Deleting all items from a database can be achieved, obviously by deleting the DB file or using<\/p>\n
\r\nalbums.Delete(Query.All());\r\n<\/pre>\n
or we can delete an individual item by calling<\/p>\n
\r\n\/\/ use the Id property \r\nalbums.Delete(album.Id); \r\n\r\n\/\/ or\r\n\r\n\/\/ use a query type syntax\r\nalbums.Delete(x => x.Artist.Name == "Led Zeppelin"); \r\n\r\n\/\/ or\r\n\r\n\/\/ using the Query syntax similar to deleting all items\r\nalbums.Delete(Query.EQ("Artist.Name", new BsonValue("Led Zeppelin")));\r\n<\/pre>\n
Obviously the Query syntax seems a little over the top for most things, but offers more query like syntax if required.<\/p>\n
And there’s more<\/strong><\/p>\n
Okay I’m not intending to document everything in this single post but I have to just touch on transactions. It’s great to see the ability to use ACID transactions for use with LiteDB.<\/p>\n
So to ensure we only commit when all operations are successful we simply use<\/p>\n
\r\nvar albums = db.GetCollection<Album>("albums");\r\n\r\ndb.BeginTrans();\r\n\/\/ multiple operations against LiteDB\r\ndb.Commit();\r\n<\/pre>\n
Multiple Inserts<\/strong><\/p>\n
It seems (from the documentation etc.) that when we carry out an insert, LiteDB creates an “auto-transaction” around the insert for us (see Transactions and Concurrency<\/a>. As such we should be aware that if we’re creating many inserts (for example from a list of objects) then it’s best from a performance point of view to not call insert multiple times.<\/p>\n
Instead either using the IEnumerable overload of the Insert method or wrap all inserts within a transaction (I’m assuming this would also work – not yet tested).<\/p>\n
This make sense, but can be easily forgotten.<\/p>\n","protected":false},"excerpt":{"rendered":"
I was looking for a simple file based object\/document database and came across LiteDB. This gives similar functionality to MongoDB. If you’re looking for good documentation on LiteDB, I would suggest going to Getting Started. I’ll undoubtedly duplicate some\/much of what’s written there in this post which is mainly aimed at reminding me how to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[123],"tags":[],"class_list":["post-4053","post","type-post","status-publish","format-standard","hentry","category-litedb"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=4053"}],"version-history":[{"count":13,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4053\/revisions"}],"predecessor-version":[{"id":4077,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/4053\/revisions\/4077"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=4053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=4053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=4053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}