Oana Rinaldi – Page 19 – Art of Coding

‘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

Python

Transform CSV Data into JSON Using Python in 10 Lines

Transform CSV Data into JSON Using Python in 10 Lines Converting CSV files into JSON format is a common task in data workflows. Whether you're cleaning up messy exports,…

Oana Rinaldi September 8, 2025

Python

Python Script to Clean CSVs with Messy Date Formats

Python Script to Clean CSVs with Messy Date Formats Real-world data is rarely clean — especially when it comes to dates. CSV files collected from external sources often include…

Oana Rinaldi September 7, 2025

Python

Find Duplicates Fast — Deduping Lists in Python Efficiently

Find Duplicates Fast — Deduping Lists in Python Efficiently When working with large datasets, one of the most common tasks developers face is eliminating duplicates. Whether you're cleaning data,…

Oana Rinaldi September 6, 2025