Linux: Find duplicate files easy!
One very common task (especially when you go out of disk space) is to find duplicate and compress them delete them etc.. in this article i…
cat linux-find-duplicate-files-easy.md →$ ls -lh ./posts
// also on this box: ./practice, ./tools and ./games
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…
cat linux-how-to-create-self-deleting-files.md →
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…
cat how-to-calculate-percentage-change-between-values-using-pandas.md →
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…
cat validate-email-addresses-with-jq.md →
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…
cat linux-how-to-make-your-scripts-re-read-their-configuration-while-running.md →
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…
cat how-to-handle-ctrl-c-in-bash-scripts.md →
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…
cat docker-how-do-i-find-the-docker-compose-yml-file-location-of-a-running-container.md →
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…
cat sql-powerful-tricks-with-self-joins.md →
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…
cat sql-return-a-random-percentage-of-rows-from-a-query.md →
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…
cat sql-how-to-find-the-diff-between-two-record-sets.md →