How to Create a Bash Script That Only Executes from Cron
Bash scripts are a powerful way to automate tasks on Linux systems. However, in some cases, you may want a script to only execute under…
Konstantinos Patronas
Managing Amazon Aurora RDS Snapshots with AWS CLI
Amazon Aurora, a managed relational database service designed for performance and reliability, allows for easy backup and snapshot…
Managing AWS CLI SSO Accounts: Adding, Listing, and Deleting
With AWS Single Sign-On (SSO), managing multiple AWS accounts becomes more efficient, especially in an environment where access to multiple…
Nginx log analytics on the command line
Understanding and analyzing web server logs is crucial for maintaining optimal website performance and security. In this article, we’ll…
How to Deploy a Flask Application with Gunicorn, Nginx, and SSL
Deploying a Flask application on a production server requires setting up Gunicorn as the application server, Nginx as the reverse proxy…
How to Generate a QR Code for Wi-Fi Connection from the Command Line
QR codes offer a quick and easy way to share Wi-Fi credentials. By generating a QR code, users can scan it with their smartphone or tablet…
How to create a directory that will automatically zip files
When managing large file systems, automating routine tasks like file compression can help improve storage efficiency and reduce manual…
How to minimize SSH connection time using connection multiplexing
SSH (Secure Shell) is a widely used protocol for securely accessing remote servers and executing commands. While SSH is a powerful tool…
Converting a Pandas DataFrame to SQL Statements
In this tutorial, you will learn how to convert a Pandas DataFrame to SQL commands using SQLite. By the end, you’ll be able to generate SQL…
SQL: Group Rows By Minute Intervals
When working with large datasets, especially event logs, it’s common to group data by specific time intervals to better analyze trends and…