MySQL

Various guides and tutorials about the MySQL database system.

MySQL: A guide on which columns to use.

“What column should I use for X and Y?” This is a question that a lot of web developers end up asking themselves whenever they’ve been given the task of creating a database-driven application. Hopefully, this article will act as a useful guide for some of the more common problems that developers will face. Storing […]

Read More...

Slow MySQLi connection

A lot of people (including myself) have come across a peculiar issue with PHP’s MySQLi extension. For some strange reason, using the string “localhost” in the constructor will sometimes result in an unexpected delay in connectivity. i.e. Connecting to MySQL will take 1-2 seconds, even if the DBMS you’re trying to connect to is hosted on […]

Read More...