Oana Rinaldi – Page 2 – Art of Coding

Automate File Backup With a Bash Script and Cron Job

Automate File Backup With a Bash Script and Cron Job Backing up important data is essential for developers, system administrators, and anyone handling critical files. In this post, we'll…

Oana Rinaldi September 23, 2025

SQL

SQL Window Functions Demystified: Real Analytics Queries Explained

SQL Window Functions Demystified: Real Analytics Queries Explained SQL window functions are one of the most powerful — yet often misunderstood — features in modern SQL. These functions enable…

Oana Rinaldi September 22, 2025

Shell / Bash

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree Managing disk space efficiently is a common concern for system administrators and developers alike. Files can…

Oana Rinaldi September 21, 2025

Shell / Bash

Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux

Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux Does your ~/Downloads folder look like a digital junk drawer? PDFs next to random installers, screenshots neighbors with…

Oana Rinaldi September 20, 2025

Python

Python Script to Auto-Fill Online Forms Using Selenium

Python Script to Auto-Fill Online Forms Using Selenium Filling out online forms for surveys, registrations, or repetitive tasks can quickly become a tedious chore. Fortunately, Python combined with Selenium…

Oana Rinaldi September 19, 2025

Python

Build a YouTube Playlist Downloader with Python and Pytube

Build a YouTube Playlist Downloader with Python and Pytube If you've ever wanted to download an entire YouTube playlist for offline viewing or archiving, Python makes this process simple…

Oana Rinaldi September 18, 2025

Java

Build a Currency Converter CLI in Java in Under 30 Minutes

Build a Currency Converter CLI in Java in Under 30 Minutes If you’ve ever needed to convert currencies on the fly, building a command-line interface (CLI) tool in Java…

Oana Rinaldi September 17, 2025

SQL

“SELECT *” is Killing You: Write Optimized SQL Queries

"SELECT *" is Killing You: Write Optimized SQL Queries When working with SQL, it’s tempting to take shortcuts—perhaps the most common being SELECT *. It’s quick, convenient, and works…

Oana Rinaldi September 16, 2025

SQL

‘SELECT … WITH RECURSIVE’: Advanced SQL Tree Traversals Explained

'SELECT ... WITH RECURSIVE': Advanced SQL Tree Traversals Explained Handling hierarchical data like category trees, folder structures, and organizational charts is a common yet complex challenge in SQL. PostgreSQL…

Oana Rinaldi September 15, 2025

Shell / Bash

Build a CLI Weather App in Bash with curl and jq

Build a CLI Weather App in Bash with curl and jq Getting real-time weather information straight from the command line is not only fun but also a great way…

Oana Rinaldi September 14, 2025