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
Enterprise-grade ITSM, for every business
Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Rate This Project
Login To Rate This Project
User Reviews
-
Great for every small project
-
Great for every small project