Browse Code
JsonSQL is a lightweight, flat-file database engine for PHP, designed to store and manage data in structured JSON files using an intuitive, SQL-like syntax. JsonSQL empowers developers to build data-driven applications without the overhead and complexity of traditional database servers.
Whether you're prototyping, creating embedded systems, or developing small to medium-sized web applications, JsonSQL provides an efficient, portable, and human-readable solution for managing your data. With robust query capabilities, extensibility, and full PHP integration, JsonSQL offers a modern alternative to traditional SQL databases for projects with minimal hosting requirements.
⚠️ Please note: The current documentation
Features
- SQL-like Query Syntax: Use familiar SQL-style commands (SELECT, INSERT, UPDATE, DELETE, JOIN, WHERE, etc.) for easy data management.
- Flat-file JSON Storage: Data is stored in plain, human-readable JSON files—ideal for backup, editing, and version control.
- No External Database Required: Operates independently of MySQL, PostgreSQL, or other database servers. No server installation or setup needed.
- Lightweight & Portable: Minimal overhead and easy deployment; JsonSQL can be used anywhere PHP is available.
- PHP-based & Composer-ready: Seamlessly integrates into any PHP project and can be installed via Composer.
- Custom Functions & Extensibility: Add your own functions to extend query capabilities as needed.
- MySQL-compatible Export: Export your data as MySQL-compatible SQL dump files for migration or backup.
- Built-in Data Validation: Supports required fields, data type checking, and configurable validation rules at the schema level.
- Encryption Support: Optional data encryption for sensitive fields or entire tables.
- Aggregate Functions: Built-in support for SUM, COUNT, AVG, MIN, MAX, and other aggregate operations.
- Joins & Relational Operations: Perform JOIN operations across different JSON tables, enabling relational data management.
- Admin UI (Optional): Includes a simple, web-based admin interface for managing data and schema definitions.
- System Table Definitions: Define schemas and validation rules using system tables for consistent data structures.
- Automatic Field Handling: Auto-handling of timestamps, unique IDs, and other system fields.
- Extensive Documentation & Demos: Comprehensive documentation and real-world demo examples available.
Categories
JSONFollow JsonSQL
Other Useful Business Software
Our Free Plans just got better! | Auth0
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Rate This Project
Login To Rate This Project
User Reviews
-
Great for every small project
-
Great for every small project