How to use LiteDB Manager

This post shows you How to Download and Use LiteDB Manager to Open NoSQL database LiteDB.

LiteDB Manager is a free tool allows you to read NoSQL database LiteDB. This tool was created by Yushell Darwich and it is very useful.

litedb manager

First, You need to download LiteDB Manager: Link

What is LiteDB?

LiteDB is a embedded NoSQL database for .Net and store in a single data file. It's a small, fast and lightweight NoSQL embedded database.

LiteDB Manager tool is a lightweight, powerful database manager for Windows LiteDB users that eliminates most of the hassle of managing your LiteDB database.

You can also you the LiteDB Manager to create database or Insert Update Delete Select data from LiteDB database.

To create new LiteDB database, you need to click the File menu, then select Create database. Next, you can enter your database name.

litedb create database

Right click on SampleCollection, then select Rename Collection.

litedb change collection name

Create a Json data as shown below.

{
  "Contact": [
    {
      "_id": 1,
      "FullName": "Lucy",
      "Email": "[email protected]",
      "Phone": "4584656970",
      "Address": "223 Str"
    },
    {
      "_id": 2,
      "FullName": "Tom",
      "Email": "[email protected]",
      "Phone": "4375588889",
      "Address": "123 Str"
    }
  ]
}

Next, Right click on Contact, then select Import Collection => select your Json file.

You can also export data from LiteDB database to Json data.

If you want to update data, you can double click on the row. Next, Modify your Json data

litedb manager edit data

You can also check validate before save your json data.

If you want to add new record, you should open your json file, then add new record to the json file or you can add directly from DataGridView in LiteDb Manager.

Another tool I would recommend to you is LiteDb Studio which helps you open the LiteDB database: Link

This tool was created by mbdavid user. You can get more information at: Linklitedb studioClick Connect button, then select your LiteDB database file. You can easily using sql query to excute select insert update delete data.

For example: SQL delete data from Contact in LiteDB database.

DELETE Contact WHERE _id = 2

And SQL query update data from Contact in LiteDB database.

UPDATE Contact SET Address = 'ABC' WHERE _id=1