jsonql-db

JSONQL-DB — Your Lightweight JSON Database

SQLite, but with human-readable JSON files.
Zero setup. Zero server. Just pure Python and transparency.

Why JSONQL-DB?

Feature	SQLite	JSONQL-DB
Storage	Binary	Human-readable JSON
Setup	Install	Zero install (pure Python)
Transparency	Opaque	Everything is a file
Ideal for	Heavy apps	Prototypes, AV tools, edge devices, indie devs

• No server
• Thread-safe
• SQL-like queries
• Core under 300 lines

Note: Not related to json-ql or jsonql.js.org — those are JSON query utilities, not databases.

Install

pip install jsonql-db

For the GUI browser (Flet-based):

pip install "jsonql-db[browser]"

Quick Start

import jsonql

# Connect (creates folder if needed)
db = jsonql.connect("my_app_data")

# Insert
db.insert("devices", {"name": "Projector", "room": "A101", "ip": "192.168.1.10"})

# Query
devices = db.select("devices", {"room": "A101"})
print(devices)

# SQL-like
result = db.query("SELECT * FROM devices WHERE room = 'A101'")
print(result)

GUI Browser Launch the built-in browser:

python -m jsonql.browser

Philosophy

"If it’s not human-readable, it’s not transparent."

JSONQL-DB is for developers who value simplicity, portability, and control.

Perfect for:

- Audiovisual integrators (Crestron, QSC, Extron)
- IoT edge logging
- Local Flet/PyQt apps
- Teaching database basics

License MIT — see LICENSE