Linux: find files created/modified after, before and between a timestamp
Find files created or modified after, before and between a timestamp!…
$ whoami — Konstantinos Patronas
SQL: inner, left and self join examples
Learn how to work with SQL joins to create amazing reports…
Bash: find CSV files, count their rows, and print modification time; all in one line!
Recently I needed a quick and dirty way to…
How to export — import a WSL Linux instance
In this article, I will show how to export and import a WSL Linux instance; some of the reasons to use this feature are…
Linux: convert rows to columns with the paste command
Recently i had to deal with a script that produce row output…
sqlite3 : How to import csv files to tables from bash
Recently i had a situation where a report needs data from two different databases that do not communicate each other in other to join……
Linux: How to ping multiple hosts directly or over ssh proxy
Ping multiple hosts in parallel, directly or over SSH proxy.…
Python: How to insert characters in specific positions of a string.
A simple guide on how to insert characters in specific positions of a string in Python.…
Grafana: How to export graphs as images and email them
Grafana is one of the most used dashboarding and alerting tools, it has many features but recently i noticed that lacked the capability to……
Linux: recover deleted text files using grep
Recently i did a mistake, i accidentally deleted a script on my file system that had tool about a week to complete it, i started exploring……