PHP-MySQLi-Database-Class icon indicating copy to clipboard operation
PHP-MySQLi-Database-Class copied to clipboard

PDO rewrite with (mostly) full compatibility – anyone interested?

Open decMuc opened this issue 5 months ago • 3 comments

Hi all,

First off: hats off to @ThingEngineer – this library has been incredibly useful and reliable over the years. The fluent API, subquery support, and overall simplicity are hard to beat.

That said, mysqli is slowly falling behind. So I’ve been working on a PDO-based rewrite that aims to be as close to the original as possible. Most methods and query structures work out of the box – but we’re still ironing out a few edge cases to match the behavior 1:1.

The goal is drop-in compatibility wherever possible, with cleaner internals and modern PDO under the hood.

Along the way, I’ve also started adding optional improvements:

Named connection instances (useful for multi-tenant apps)

Type-safe where*() methods (e.g. whereInt(), whereBool())

Improved subquery handling across SELECT/INSERT/JOIN/WHERE

If anyone is interested in testing, contributing, or just giving feedback – I’d be happy to hear your thoughts.

Repo: https://github.com/decMuc/PDOdb Latest release: v1.2.2

Thanks again to @ThingEngineer for the great foundation!

— decMuc

decMuc avatar Jul 07 '25 02:07 decMuc