The next-gen lightweight JSON database for Python — fast, secure, and schema-aware.
Store and query data instantly with zero setup, pure Python power, and human-readable JSON files.

• Features
• Installation
• Quick Start
• Usage Examples
• Project Structure
• Contributing
• License
• Community
• Credits
• Support

jflatdb is a file-based, schema-aware JSON database system that combines the simplicity of NoSQL with powerful query and indexing features inspired by SQL — all in pure Python.

No servers. No setup. Just plug, code, and store.

Perfect for developers, students, or small apps that need fast, secure, local data storage with minimal dependencies.

Feature	Description	Demo
🧩 Flat-File Simplicity	Store data in plain JSON files
⚙️ Persistent Indexing	Fast queries, no rebuild on load
🔍 Powerful Query Engine	$gt, $lt, $in, $like, $between
🔒 Encryption & Validation	Optional AES encryption & schema constraints
🧠 Async & Transactions	Atomic commits, async-safe operations
🛠 Zero Dependencies	100% pure Python
💡 Extensible Design	Add plugins, custom storages, or new data types

pip install jflatdb

or install from source:

git clone https://github.com/jflatdb/jflatdb.git
cd jflatdb
pip install .

from jflatdb.database import Database

# Initialize with optional encryption
db = Database("users.json", password="your-password")

# Insert data
db.insert({"name": "Akki", "email": "[email protected]", "age": 25})

# Query with conditions
users = db.find({"age": {"$gt": 18, "$lt": 30}})
print(users)

# Update and Delete
db.update({"name": "Akki"}, {"email": "[email protected]"})
db.delete({"name": "Akki"})

jflatdb/
├── jflatdb/
│   ├── utils/
│   ├── exceptions/
│   ├── __init__.py
│   ├── cli.py
│   ├── database.py
│   ├── indexer.py
│   ├── query_builder.py
│   ├── query_cache.py
│   ├── query_engine.py
│   ├── schema.py
│   ├── schema_migration.py
│   ├── schema_version.py
│   ├── storage.py
│   ├── transation.py
│   └── security.py
├── examples/
├── tests/
├── README.md
├── setup.py
└── LICENSE

We welcome all contributions! To get started:

1. Fork the repository
2. Create a new branch → git checkout -b feature-name
3. Commit your changes → git commit -m "Add feature"
4. Push your branch → git push origin feature-name
5. Open a Pull Request

Check our CONTRIBUTING.md for more details.

This project is licensed under the MIT License — see the LICENSE file for details.

• 💡 Suggest a Feature
• 🐞 Report a Bug
• 💬 Start a Discussion

Developed and maintained by Akki Inspired by TinyDB, SQLite, and the open-source spirit.

Your support keeps this project growing! 🌱 If you like jflatdb, please ⭐ star the repo, share it, and help more developers discover it.

Let’s redefine simple data storage — one JSON file at a time. 💾🚀