JFlatDB
🗃️ Lightweight JSON-Based Database Engine with SQL-like Features, Built in Pure Python.
📦 What is JFlatDB?
JFlatDB is a blazing-fast, file-based database engine that stores structured data in JSON format, while supporting SQL-like commands through a powerful CLI. Ideal for lightweight applications, offline tools, and embedded systems.
✨ Features
- 📁 JSON-based persistent storage (no external DBMS)
- 📝 SQL-like syntax for querying and manipulation
- ⚙️ CLI support with
.help
, .show tables
, .describe
etc.
- 🧠 Query features:
WHERE
, BETWEEN
, LIKE
, ORDER BY
, etc.
- 📊 Functions:
MIN
, MAX
, AVG
, COUNT
, GROUP BY
- 🔒 Constraints:
PRIMARY KEY
, NOT NULL
, UNIQUE
, DEFAULT
, CHECK
- 📤 Backup-ready and versioning-friendly
- ⚡ Written in pure Python — no dependencies