To JOIN or not to JOINThe question crops up regularly on StackOverflow: are JOIN queries faster than several queries?Jan 8, 2019A response icon4Jan 8, 2019A response icon4
Removing the MySQL root passwordThere you go again. You just spinned up a virtual machine to do some testing, installed MySQL using your favourite package manager, started…Sep 7, 2017A response icon2Sep 7, 2017A response icon2
Creating a Linux service with systemdWhile writing web applications, I often need to offload compute-heavy tasks to an asynchronous worker script, schedule tasks for later, or…Sep 5, 2017A response icon41Sep 5, 2017A response icon41
High-speed inserts with MySQLWhen you need to bulk-insert many million records in a MySQL database, you soon realize that sending INSERT statements one by one is not a…Sep 4, 2017A response icon7Sep 4, 2017A response icon7
