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
1 maintainer
Release files for jsonql-db 0.1.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| jsonql_db-0.1.5.tar.gz | 10.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| jsonql_db-0.1.5-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 19.1 kB
Release files / jsonql_db-0.1.5.tar.gz
| Download URL | jsonql_db-0.1.5.tar.gz |
|---|---|
| Size | 10.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8a4fd6e76b023021276d04bd6242d0ac7f738fd0bf3ebf2ccac1be8fb0d3a811
|
|
BLAKE2b-256 checksum How to use checksums |
a61d88d8297a398b94ac426a25b95e0617edc23b596341b5d63b1f72c7a86c9c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.13.5
|
Release files / jsonql_db-0.1.5-py3-none-any.whl
| Download URL | jsonql_db-0.1.5-py3-none-any.whl |
|---|---|
| Size | 9.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
0bab576216cfa5c432bf6f0b5f63b75119ba98d9f1754e70add985875c56b276
|
|
BLAKE2b-256 checksum How to use checksums |
14b0c340fe9f206b4172b43b4c6a1bcf4ce2d38a214781a434cdb1b20bbf0aed
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.13.5
|
