LightDB: Lightweight JSON Database for Python

LightDB is a simple and lightweight JSON database for Python that allows users to efficiently write data to a file. It is designed to be easy to use, making it a great choice for developers who need a fast and reliable way to store and retrieve data.

You can install LightDB using pip:

pip install LightDB

To use LightDB, first import the LightDB class from the lightdb package:

from lightdb import LightDB

Then, create a LightDB object by passing in the path to a JSON file where the database will be stored:

db = LightDB("db.json")

You can then set key-value pairs in the database using the set() method:

db.set("name", "Alice")
db.set("age", 30)

To save the changes, use the save() method:

db.save()

LightDB supports defining models for more structured and convenient data management. Here’s how to use models with LightDB:

First, import the necessary classes:

from typing import List, Dict, Any

from lightdb import LightDB
from lightdb.models import Model

Define your model by extending the Model class:

class User(Model, table="users"):
    name: str
    age: int
    items: List[str] = []
    extra: Dict[str, Any] = {}

Create a new instance of the model and save it to the database:

user = User.create(name="Alice", age=30)

Retrieve a user from the database:

user = User.get(User.name == "Alice")
# or user = User.get(name="Alice")
print(user.name, user.age)

Update a user’s information and save it:

user.name = "Kristy"
user.save()

Filter users based on certain criteria:

users = User.filter(User.age >= 20)
for user in users:
    print(user.name)

Delete a user:

user.delete()