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 …
Technical Articles
In-depth guides, insights, and best practices for modern software engineering
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 →