Oana Rinaldi – Page 10 – Art of Coding

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

JavaScript

JavaScript Bookmarklet: Save Any Page to Your Reading List

JavaScript Bookmarklet: Save Any Page to Your Reading List Bookmarklets are tiny snippets of JavaScript code that run directly in your browser when you click on them. They offer…

Oana Rinaldi September 13, 2025

Python

Python Script to Monitor and Alert on Disk Usage

Python Script to Monitor and Alert on Disk Usage System administrators and DevOps engineers often need to monitor disk space usage to ensure that servers continue operating smoothly. If…

Oana Rinaldi September 12, 2025

Python

‘SELECT * FROM JSON’: Querying Local JSON Files as Tables with Python

'SELECT * FROM JSON': Querying Local JSON Files as Tables with Python If you've ever wished you could run SQL queries directly on JSON files without setting up a…

Oana Rinaldi September 11, 2025

Java

How to Detect Palindromes Efficiently in Java Without Reversing Strings

How to Detect Palindromes Efficiently in Java Without Reversing Strings When it comes to checking whether a string is a palindrome, the naive approach involves reversing the string and…

Oana Rinaldi September 10, 2025

Java

Java Automation: Rename Hundreds of Files in Seconds

Java Automation: Rename Hundreds of Files in Seconds Renaming dozens or even hundreds of files manually is time-consuming and error-prone. Whether you're organizing thousands of camera photos, web assets,…

Oana Rinaldi September 9, 2025