How to Bring Back GROUP BY in MySQL
If you are suddenly not able to perform GROUP BY statements as you used to after a MySQL/MariaDB version update, then you will have noticed the change …
Technical Articles
In-depth guides, insights, and best practices for modern software engineering
How to implement a Queue using Stacks in Python
A common programming interview question, and for a change, one that you will actually be able to use in the job, is that of implementing a Queue by …
Read Article →Find positions of largest groups of characters in a String with Python
The question
Take a string S of lowercase letters.
These letters form consecutive groupings of like characters.
Find groups with 3 or more like …
Read Article →How to make Git “forget” about a file that was tracked but is now in .gitignore?
You can ignore certain files and folders from being committed to Git by means of including a .gitignore file.
Unfortunately, you may have forgotten to …
Read Article →How to Purge the BinLog for MySQL and MariaDB
If you see lots of disk space quickly disappearing on your MySQL or MariaDB server, then you may want to look into the BinLog directory, it is located …
How to Measure Execution Time in Google Colab
Google Colab is a fantastic environment to write Python code using Jupyter Notebooks, hosted for free by Google.
If you’ve ever used Jupyter …
Read Article →How to fake a User Agent in Python
A User-Agent is a bunch of text that is sent with every HTTP and HTTPS request. The server processing this request is able to determine what type of …
How to Delete from a Table where rows match in Another Table – MySQL
So you have a table where you want to delete a bunch of rows, based on a particular column being matched in another table.
This is easily achievable …
Read Article →REPLACE INTO instead of INSERT INTO – MySQL
There are many occasions where you need to INSERT a record into a MySQL database table, but the record already exists.
INSERT INTO queue_domains …
Read the bottom n lines of a file in Python
Using Operating System Commands in Python
Use the Linux/Mac tail command to provide the data:
line = subprocess.check_output(['tail', …How to Format a Number as a Currency in Javascript
There are quite a few ways to format a number as a currency value in Javascript. This is a common task when building web applications, similar to …
Read Article →How to Change the Timezone on Ubuntu Server
If you’ve ever typed date into your Ubuntu Server and seen a different time or timezone appear than you expected, then it probably means that …
How to make a Python script Pip-installable
As Python developers, we’ve all used pip to install applications, but speaking to other Python developers, it’s not always clear how to …
How to Host an AngularJS site on AWS S3
AngularJS is a Javascript Framework that allows you to create dynamic front-end web applications easily.
I have traditionally packaged these …
Read Article →How to send emails using Python and AWS SES SMTP
Sending emails using Python and AWS’ SES service is really easy. They provide an SMTP server that you can authenticate against and send email …
Read Article →Generate a random number between two numbers in JavaScript
If you need to generate a random number between two numbers in JavaScript, then you are in the right place! Here you will learn javascript random …
Read Article →Why Password Managers are Not the Solution
Why a Password Manager?
Password managers exist for two main reasons.
Firstly, to generate strong passwords and secondly so that you don’t end …
Read Article →Read the top n lines of a file in Python
Sometimes you may need to read the top n lines of a file using Python.
We start by opening the file for reading and then using a list comprehension we …
Read Article →How Fast is your Website?
I operate a bunch of different sites and have done for many years now.
Some of them get quite a lot of traffic and require a high level of uptime.
To …
Read Article →How to Git Reset a Single File
It’s very easy to reset files that have not yet been committed to git.
Reset a single file
git reset <filename>
You can also specify the …
Read Article →Introducing Variables in Golang
Golang comes with a decent offering around variables that you can use to store, retrieve and manipulate information.
A variable is defined with the …
Read Article →Golang cannot convert (type string) to type int
Every language has it’s ways of converting data types. One of the most common data types to convert between is that of strings (string) and …
Learn Golang as a Python Developer
Learning Go or Golang as a Python developer, programmer or software engineer is easier than you think.
While there are quite a lot of things to learn …
Read Article →Remove Special Characters in a String using Bash
Programming languages provide the ability to remove special characters from a string quite easily.
Sometimes you need to also do this from your …
Read Article →