How is PDO better than mysqli for a dev that sticks to just MySQL?
Commit
caf9a55
Contrary opinion: it isn't, unless you're using simple tables of simple data. Then absolutely use PDO. But once you extend into geographic queries or JSON style structured data queries, you are locking into a flavor of SQL anyway, and are tying your code to a database. If that happens, use the most direct connection. PDO doesn't give you much at that point.
commit caf9a55
As a follow up, I developed that opinion after migrating some start-of-Covid panic-coded things from MySQL to Postgres. Enough stuff broke that I sort of wish I had just used something that forced me to rewrite every line of SQL. On the other hand, some other trivial sites like…