Metadata-Version: 2.4
Name: jsonql-db
Version: 0.1.4
Summary: A lightweight, file-based JSON database with SQL-like interface
Home-page: https://github.com/takouzlo/jsonql-db
Author: FBF
Author-email: f.bfalik@gmail.com
License: MIT
Keywords: json database sqlite alternative lightweight file-based
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Topic :: Database
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Requires-Python: >=3.7
Description-Content-Type: text/markdown
License-File: LICENSE
Provides-Extra: browser
Requires-Dist: flet>=0.25.0; extra == "browser"
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: keywords
Dynamic: license
Dynamic: license-file
Dynamic: provides-extra
Dynamic: requires-python
Dynamic: summary

# JSONQL-DB — Your Lightweight JSON Database

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

[![PyPI](https://img.shields.io/pypi/v/jsonql-db.svg)](https://pypi.org/project/jsonql-db/)
[![License](https://img.shields.io/badge/license-MIT-blue.svg)](https://github.com/takouzlo/jsonql-db/blob/main/LICENSE)
[![Python](https://img.shields.io/pypi/pyversions/jsonql-db)](https://pypi.org/project/jsonql-db/)

## 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](https://pypi.org/project/json-ql/) or [jsonql.js.org](https://jsonql.js.org) — those are JSON query utilities, not databases.

## Install

```bash
    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

