How is PDO better than mysqli for a dev that sticks to just MySQL?
Commit
5f56831
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…
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…
I'm a recent dev, just before the AI craze and I'm thinking of trying out Postgres (PDO).
Parts of it's query lang messes with my MySQL brain so I built a query builder to abstract the raw SQL part out.
commit 5f56831