Oana Rinaldi – Art of Coding

Detect Duplicate Files on Your System with a Python Hashing Script

Detect Duplicate Files on Your System with a Python Hashing Script Duplicate files can quietly eat up precious disk space, especially on systems that see heavy data movement or…

Oana Rinaldi January 26, 2026

Java

From CSV to Insight: Parse and Analyze CSV Files Using Modern Java Streams

From CSV to Insight: Parse and Analyze CSV Files Using Modern Java Streams In today’s data-driven world, it’s common to work with large CSV files for everything from analytics…

Oana Rinaldi January 25, 2026

SQL

Visualizing SQL Query Performance with EXPLAIN Plans

Visualizing SQL Query Performance with EXPLAIN Plans Performance tuning is a critical aspect of working with relational databases. In PostgreSQL, understanding how a query gets executed is the first…

Oana Rinaldi January 24, 2026

Python

Use Python’s Requests and BeautifulSoup to Scrape Product Prices

Use Python's Requests and BeautifulSoup to Scrape Product Prices Web scraping allows developers to automate data collection from websites, making it a powerful tool for monitoring prices, extracting content,…

Oana Rinaldi January 23, 2026

SQL

Speed Up SQL Queries Using Indexes—With Before-and-After Benchmarks

Speed Up SQL Queries Using Indexes—With Before-and-After Benchmarks SQL performance tuning is one of the most impactful ways to improve an application’s responsiveness. One of the most powerful tools…

Oana Rinaldi January 22, 2026

JavaScript

Building a Simple CAPTCHA System in JavaScript Without Dependencies

Building a Simple CAPTCHA System in JavaScript Without Dependencies Spam and automated bots are common nuisances when building web forms. To prevent bot submissions, a well-known solution is the…

Oana Rinaldi January 21, 2026

Databases

Find Duplicates Fast — SQL vs Python Algorithm Showdown

Find Duplicates Fast — SQL vs Python Algorithm Showdown When you're working with massive datasets—think millions of rows—duplicate detection becomes more than just a simple query or a loop.…

Oana Rinaldi January 20, 2026

Python

Scraping Job Listings from Indeed Using Python and BeautifulSoup

Scraping Job Listings from Indeed Using Python and BeautifulSoup IntroductionWeb scraping offers developers an easy way to extract structured data from websites. One practical example is collecting job listings…

Oana Rinaldi January 19, 2026

Java

Local File Sync Tool in Java Using WatchService

Local File Sync Tool in Java Using WatchService Keeping directories in sync is a common task for developers and system administrators alike — whether you're backing up a folder,…

Oana Rinaldi January 18, 2026

SQL

SQL Query Recipes for Cleaning Dirty Data

SQL Query Recipes for Cleaning Dirty Data Dirty data is a persistent challenge in every data system. Whether it's duplicate records, null values, inconsistent formatting, or typos, bad data…

Oana Rinaldi January 8, 2026