LiteDB vs. SQLite: a comparison for .NET developers

Do you need to use an embedded database in your .NET app?

Are you struggling to choose the right one?

Have you already considered SQLite? And do you perhaps want something that feels and works more like MongoDB?

Let me help you decide.

There is a new kid on the block - LiteDB.

Maybe you've already read my blog post about it. Here, you can dive deeper.

You will learn what LiteDB can do for you and how it compares to the gold standard of embedded databases - SQLite.

This is a practical, hands-on guide that answers the following questions you might have:

• what are the differences between SQLite and LiteDB on a high level?
• what can LiteDB do for me that SQLite cannot, and vice versa?
• when do I use LiteDB, and when should I stick with SQLite?
• how easy is it to set up LiteDB compared to SQLite in a new C# project?
• how do I migrate from SQLite to LiteDB in an existing project?

This is not a philosophical treatise but a pragmatic handbook for a busy programmer. You’ll find code samples throughout, and should you want to play along, download or fork the Github repo with the sample app.

This source code of the handbook itself is Open Source and available here. You can download the PDF or EPUB for free, or pay what you want if you like it!