To JOIN or not to JOINThe question crops up regularly on StackOverflow: are JOIN queries faster than several queries?Jan 8, 20194Jan 8, 20194
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, 20172Sep 7, 20172
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, 201736Sep 5, 201736
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, 20176Sep 4, 20176
