LeoDB
Lightweight Miniature JSON DB
Hello World, The use of JSON is at its peak and th future of the data being passed and store has a higher potential of also being in JSON format. Thus im presenting you with this module of which makes it extremely easy to perform DB like queries on the JSON data.
// Import the module
const leoDB = require("leo-db");
This module provides following functionality,
- Loading data from file.
- Saving the data to a file.
- Performing a search query.
- Performing an insert query.
- Performing a update query.
- Performing a delete query.
I have tried implementing the module to save save using key replacement method to a general structure. Thus reducing the data size without affecting the runtime efficiency.
// Loading an existing DB from the Local disk.
leodb.LoadDB();
// Save the DB to the loacl disk.
leodb.SaveDB();
Now to make a new DB or remove an existing DB we have the following functions, (DB here means the collection/table)
// Create a new DB.
leoDB.NewDB("Enter_DB_Name", ["field_1", "field_2", "field_3"]);
// Delete a particular DB and remove all data.
leoDB.DeleteDB("Enter_DB_Name");
Select the database you want to perform the query on.
// Select the DB. (Only once for multiple query on same DB)
leoDB.SelectDB("Enter_DB_Name");
Performing Insert Query
// Single Data Insert
leoDB.Insert({
field_1: "value_1",
field_2: "value_2",
field_3: "value_3",
});
// Multiple Data Insert
leoDB.Insert([
{
field_1: "value_1",
field_2: "value_2",
field_3: "value_3",
},
{...},
{...}
]);
Performing Update Query
// Data Update
leoDB.Update(
{
search_for_key: "search_for_value",
},
{
update_field: "update_value",
}
);
Performing Find Query
// Data Find (Returns all data)
leoDB.Find();
// Data Find (Returns all data thats matching)
leoDB.Find({
search_field_1: "search_value_1",
OR: {
// Search for optional values matching.
search_field_2: [
"possible_value_1",
"possible_value_2",
"possible_value_3",
],
search_field_3: [
"possible_value_1",
"possible_value_2",
"possible_value_3",
],
},
});
Performing Delete Query
// Data Delete
leoDB.Delete({
search_for_key: "search_for_value",
});
// Delete all data. (Removes all the data);
leoDB.Delete();