I am a full-stack/back-end developer with over 15 years of software development experience. My most skilled technologies include PHP, NodeJS, JavaScript and TypeScript. Senior Software Developer at The Service Directory.
I am in the process of improving the speed of a MySQL remote connection which connects to an external server on the internet. In order to test the speed of…
SSH sessions can become unresponsive or hang for a number of reasons; one reason being network issues which I experience frequently when working from an unstable Wi-Fi network. The following…
I was running two Ethereum mining rigs with USB drives as their boot drives for several months and, after around 2-3 months, both of them began experiencing I/O related issues.…
Recently, our server ran out of storage space due to a unnecessarily huge database and I was tasked with diagnosing and remediating the issue. I needed to: Determine the remaining…
I have written this post to serve as some quick guidelines for how databases and collections should be named in MongoDB to keep my projects consistent. Partially derived from this…
I was recently asked to look at an issue causing results on two MySQL servers (hosted on different machines: local environment and production environment) to be inconsistent with one another…
Before exporting the query results to a CSV file, you must firstly determine if the secure_file_priv option is set by running the following SQL query: SHOW VARIABLES LIKE 'secure_file_priv'; If…