(03-13-2019, 07:45 AM)mladoux Wrote: I prefer PDO, as that's where all database extensions should be going eventually anyway, and all popular databases including many that aren't already have PDO drivers built into PHP. PDO is intended to provide a pretty reliable API that can port through many databases seamlessly. Is it perfect, no, but it provides a good starting foundation. This is why the most popular ORM and DBAL libraries are based on it, since it makes writing portable database code simpler. My recommendation would be to implement PDO, and once that's done, to add any other layers as development time arises to support the more niche use cases that require a database specific driver.
To be clear here - I believe most popular ORM and DBAL libraries use PDO because it's less work for them. CodeIgniter's database layer has always done many of the things that PDO takes care of for you. If I were starting from scratch you better believe I'd build on top of PDO and save work. At least when this conversion was started 3 years ago the non-PDO drivers of several popular engines still have more complete feature set than their PDO counterparts. I'm not sure if this is still true or not, honestly.
But just adding PDO support doesn't automatically make any database engine work with our Query Builder, Forge, etc. Those each still have to be custom tailored as they all have their own unique implementation details. PDO just abstracts the connection and basic query capabilities.
