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 …