Don’t Emulate Prepared Statements with PDO & MySQL
Recently I have been updating one of my older sites to a completely new code base, and with that new code I’ve switched all old MySQL calls from the old mysql_* functionsRead More…
Recently I have been updating one of my older sites to a completely new code base, and with that new code I’ve switched all old MySQL calls from the old mysql_* functionsRead More…
I had a simple query where I was pulling data on a user, but binding with :user, as in select * from user_table u join other_table o on u.user_id = o.user_id whereRead More…
Just recently the library at the school where I work asked me to write a web application so that they could more easily manage their electronic resources. The resources they were trackingRead More…
I just ran across this post (via Planet Mysql) at Flite Mechanics. Apparently you can now use common_schema to parse JSON directly. Now there’s no more need to run your JSON throughRead More…
Here’s an interesting tutorial about Scaling MySQL for Developers that I ran across at Johathan Levin’s blog. It touches on indexing, troubleshooting, and table optimization, as well as a lot more, butRead More…