Beware the Dangers of .swp Files On Prod
Editing a file with vim and exiting the program improperly on a public-facing web server can leave you vulnerable to leaking private data like db credentials, private keys etc. A…
Spy on the Output of a Linux Process Using its PID
There may be instances whereby ps -aux has been used to see the PID of a running process and you would like to see its output. This can be done…
Most Useful VS Code Keybinds
Here are the shortcuts I find myself using on a daily basis. I will update this post as I think of more. Last updated: 16th January 2023. CMD + SHIFT…
Stop Git from Tracking a File or Directory Added to Gitignore
This article will explain how to fix files still being tracked by Git after it has been added to the .gitignore file. Rules added to the .gitignore file only applies…
Run a Terminal Command after n Seconds Has Passed
It is sometimes desirable to run a command after n seconds has passed e.g. to run a command after the approximate time taken for deploy pipeline to complete. Scheduling the…
Scrolling on MacOS Terminal Does Not Work/Scrolls Commands instead of Text
This happens when the terminal is in 'Alternative Screen Mode'. The problem might also be combined with characters looking like ^[OB^[OB. What is Alternative Screen Mode? Many user-interactive terminal application…
Benchmarking a webpage response time (for web developers)
It is good practice to benchmark your webpages and API endpoints before pushing them live to production. This can help identify areas of improvement which can be used to inform…
Run a shell script in the background on Linux
Typically, I will need to run a shell script on a Linux server which I know will take a while to execute. I will sometimes also need to check up…
How to Export Amazon RDS MySQL Results to CSV
Over the past couple of months, I have been tasked with moving our server stack over from Digital Ocean VPS hosting to AWS. What used to be just one single…
How to Kill Many MySQL Processes at Once
We recently had an issue on our database server which meant many slow MySQL queries had built up (up to 50 of them!) These slow queries were preventing other queries…