Recently I discovered that the recommended way of changing a column type of a table in MySQL is intolerably slow. By recommended I mean that the first result of searching for “how to change column type mysql” (excluding quotes) is a link to the MySQL developer documentation for an ALTER TABLE query.
The circumstances started [...]

I’m currently working on a small project that led me to look for the best way to fetch a random row from a MySQL database. Online research showed that a common solution to this problem is something similar to
[1]

SELECT * FROM `TABLE` ORDER BY RAND() LIMIT 1;

The problem with this solution is that it assigns [...]

A few days ago I had been searching for information about a very cool IDE I’ve begun using called ‘UEStudio’. The bottom of the page read
“In response to a complaint we received under the US Digital Millennium Copyright Act, we have removed 1 result(s) from this page. If you wish, you may read the DMCA [...]