catfan/Medoo
Medoo
Medoo ist eine leichtgewichtige PHP-Datenbank-Abstraktionsschicht und ein SQL-Query-Builder. Er dient als minimaler Datenbank-Wrapper, der eine einheitliche API zur Ausführung von Queries über mehrere SQL-Engines hinweg bereitstellt und PHP-Methodenaufrufe in spezifische Datenbankdialekte übersetzt.
Das Projekt ermöglicht Multi-Dialekt-SQL-Interfacing, wodurch eine einzige Codebasis mit verschiedenen Backends interagieren kann, einschließlich MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle und Sybase. Es verwendet Prepared-Statement-Parametrisierung, um Injektionsangriffe zu verhindern, während ein programmatischer Ansatz zur Konstruktion komplexer SQL-Statements beibehalten wird.
Das Toolkit deckt Standard-Datenmanipulationsoperationen ab, einschließlich Datensatz-Einfügung, Updates, Löschungen und Abfragen. Es bietet zudem Funktionen für Aggregatberechnungen, atomares Transaktionsmanagement und die Ausführung von Raw-SQL für komplexe Logik.
Diagnosetools sind für die Inspektion der Query-Ausführung enthalten, was das Logging generierter SQL- und Verbindungsinformationen zu Debugging-Zwecken ermöglicht.
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.
