PHP MySQL Engine
A pure PHP MySQL 5.6 simulation engine for in-memory database testing without a real MySQL server.
What is PHP MySQL Engine?
PHP MySQL Engine is a library written in pure PHP that simulates MySQL 5.6 for testing database-driven applications. It allows developers to run SQL queries against an in-memory database without needing a real MySQL server, solving the performance and maintenance issues of traditional database testing approaches. It extends PDO to provide a drop-in replacement for MySQL connections in test environments.
PHP developers with extensive test suites that require database interactions, particularly those at organizations like Vimeo who need to test data access layers without the overhead of real databases.
Developers choose PHP MySQL Engine because it eliminates the fragility of query mocks and the performance costs of real databases in tests, offering a fast, in-memory alternative that supports a wide range of MySQL syntax and integrates seamlessly via PDO.
Overview
A MySQL engine written in pure PHP
Use Cases
Best For
- Unit testing PHP applications with complex database queries
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
