For a few years, I’ve been using mysqli prepared statements for all php-mysql interations on all of my websites because of the inherent mysql injection protection afforded by the separation of query and data. What I have not done is… Read More
RAM hogging mediumtext (MySQL)
Php can easily exceed its maximum allowed RAM allocation when trying to retrieve mediumtext fields from mysql. Background: Through some obscure misunderstanding/bug, I have from time to time ended up with a MySQL database that has mediumtext instead of the… Read More
Memcached
Whilst this is rather an advanced topic to start off this blog, it is very fresh in my mind still… I recently had a play with Memcached, a RAM based caching system used by large websites such as Facebook. Memcached… Read More