dctdb 1.5.0

Pure Python in-memory database with SQL-like queries

---

DictDB is a pure Python in-memory database with SQL-like queries. Zero dependencies.

Installation

pip install dctdb

The PyPI package is dctdb, but the import is dictdb.

Features

• SQL-like CRUD — insert, select, update, delete
• Query DSL — table.age >= 18, table.name.startswith("A")
• Aggregations — Count, Sum, Avg, Min, Max with GROUP BY
• Indexes — Hash (O(1) lookup) and Sorted (range queries)
• Schemas — Optional type validation
• Persistence — JSON and Pickle formats
• Thread-safe — Reader-writer locks

Quick Example

from dictdb import DictDB, Condition, Count, Avg

db = DictDB()
db.create_table("users", primary_key="id")
users = db.get_table("users")

# Insert
users.insert({"name": "Alice", "age": 30, "dept": "IT"})
users.insert({"name": "Bob", "age": 25, "dept": "HR"})

# Query with DSL
users.select(where=Condition(users.age >= 25))
users.select(where=Condition(users.dept == "IT"), order_by="-age", limit=10)

# Aggregations
users.aggregate(count=Count(), avg_age=Avg("age"))
users.aggregate(group_by="dept", count=Count())

# Persistence
db.save("data.json")

Documentation

mhbxyz.github.io/dictdb

License

Apache 2.0