JsonSQL

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.

Follow JsonSQL

JsonSQL Web Site