jsonql-db 0.1.4

A lightweight, file-based JSON database with SQL-like interface

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

    ![JSONQL Browser](https://raw.githubusercontent.com/takouzlo/jsonql-db/main/jqlFlet.png)


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