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

[decMuc]

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

[avbdr]

:) when you say 'as close', you have meant 'i just copied copied whole thing and just replaced MySQLi with pdo and some sugar and removed the tests'. Great job bro

…

On Sun, Jul 6, 2025, 10:37 PM Lucky ***@***.***> wrote: *decMuc* created an issue (ThingEngineer/PHP-MySQLi-Database-Class#1051) <#1051> Hi all, First off: hats off to @ThingEngineer <https://github.com/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 <https://github.com/decMuc/PDOdb/releases/tag/1.2.2> Thanks again to @ThingEngineer <https://github.com/ThingEngineer> for the great foundation! — decMuc — Reply to this email directly, view it on GitHub <#1051>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAZCL4RCCPJDSO7PP5MCH4L3HHMNTAVCNFSM6AAAAACA47J4QWVHI2DSMVQWIX3LMV43ASLTON2WKOZTGIYDOMZVHE3TONI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[decMuc]

lol – to achieve something close to 1:1 compatibility and properly address all the security-related issues like SQL injections in where, orderBy, or groupBy, it definitely takes more than just copy-pasting.

Yes, Thing's original work was the base – but what’s under the hood now only loosely resembles it.

[avbdr]

you could just submit patches upstream like I been doing it. But it seems that you are too smart for this.