catfan/Medoo
Medoo
Medoo is a lightweight PHP database abstraction layer and SQL query builder. It serves as a minimal database wrapper that provides a unified API to execute queries across multiple SQL engines, translating PHP method calls into specific database dialects.
The project enables multi-dialect SQL interfacing, allowing a single codebase to interact with various backends including MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, and Sybase. It uses prepared statement parameterization to prevent injection attacks while maintaining a programmatic approach to constructing complex SQL statements.
The toolkit covers standard data manipulation operations, including record insertion, updates, deletions, and querying. It also provides capabilities for aggregate calculations, atomic transaction management, and raw SQL execution for complex logic.
Diagnostic tools are included for query execution inspection, allowing the logging of generated SQL and connection information for debugging purposes.
Features
- Database Wrappers - Serves as a minimal database wrapper providing a unified interface for CRUD operations and aggregate calculations.
- Relational Database Abstractions - Provides a unified, vendor-agnostic PHP interface for interacting with multiple relational database systems via PDO.
- Array-Driven Query Construction - Provides a mechanism to define complex SQL queries and filters using PHP associative arrays.
- Database Engine Abstractions - Implements a layer that decouples application logic from specific SQL engines to allow multi-backend support.
- Database Record Querying - Enables retrieving records from tables using a variety of filters, limits, and column selections.
- Prepared Statements - Uses prepared statements with parameterization to prevent SQL injection attacks.
- Query Abstraction Layers - Provides a unified query abstraction layer for executing SQL across multiple engines using a single PHP API.
- Record Deletion - Provides methods for removing one or multiple records from a table based on filtering criteria.
- Record Insertion - Implements standard interfaces for inserting single or multiple data records into tables.
- Record Updating - Provides fluent methods for modifying existing database records based on conditional filters.
- SQL Database Engine Support - Supports a wide range of SQL engines including MySQL, PostgreSQL, SQLite, MSSQL, Oracle, and Sybase.
- SQL Dialect Adapters - Provides a unified API that adapts queries to ensure compatibility across different SQL database implementations.
- SQL Query Builders - Includes a programmatic utility for constructing and executing structured query language operations.
- SQL Query Building - Enables programmatic construction of complex SQL statements with prepared statements to prevent injection.
- Multi-Database Support - Enables building applications that remain portable across different SQL backends via a unified interface.
- Aggregate Calculations - Provides built-in methods for performing aggregate calculations like sum, average, and count on database tables.
- Atomic Batch Commits - Implements atomic batch commits to ensure a group of database mutations either succeed completely or roll back.
- Database Transaction Management - Manages database transactions to ensure data integrity through atomic operations.
- Raw SQL Execution - Allows the injection of raw SQL expressions into generated queries for complex logic.
- Lightweight Integrations - Provides a minimal interface for adding basic database CRUD operations without the overhead of a full ORM.
Star history
How this analysis was created: This summary and feature list were written by an AI model that read the project's README and public documentation pages. Each feature links to the documentation it came from; stars, license and language come straight from the GitHub API. The model does not read the source code, and the analysis is refreshed when the project is re-analysed. Learn more on our About page.
