Linux: How to create self deleting files!
In this article i will show you how you can create self deleting files!, files that will be deleted them self after a defined number of…
Konstantinos Patronas
How to calculate percentage change between values using pandas
Calculating percentage difference between values in pandas is a very common task, in this article i will show you some examples one how you…
Validate email addresses with JQ
In this article i will show you a handy one-liner that can do the following, read from stdin a text file with email addresses, verify that…
Linux: How to make your scripts re-read their configuration while running
Assume the following scenario, you have create a script that processes files.. your script is half way processing 1.000.000 files.. but you…
How to handle ctrl+c in bash scripts
Assume that you want to create a script that will run forever unless ctrl+c is pressed.. well as you might already know is that you can do…
Docker: How do i find the docker-compose.yml file location of a running container?
Assume the following scenario! you are the on-call engineer of a company and they asked you to support them on a docker issue, the problem…
SQL: powerful tricks with self-joins
If you are using SQL you know about the many types of joins, like inner join, left join, right, etc.. one particular powerful type of join…
SQL: return a random percentage of rows from a query
Assume you have the following task, you need to get a random percentage of records from a query, how do you do this? it might sound a bit…
SQL: How to find the diff between two record sets
In this article, I will show you how to subtract one result set from another. The database I will use is SQLite which supports the EXCEPT…
How to troubleshoot crontab issues
Crontabs are super useful, you can schedule tasks to run recurrently at specific times or intervals, but there are common pitfalls that can…