Oana Rinaldi – Page 2 – Art of Coding

Write a SQL Query That Builds a Running Total Without Window Functions

Write a SQL Query That Builds a Running Total Without Window Functions Window functions like SUM() OVER (ORDER BY ...) make calculating running totals in SQL straightforward and efficient.…

Oana Rinaldi January 30, 2026

Python

Scrape and Schedule: Automate Web Reports Using Python & Cron

Scrape and Schedule: Automate Web Reports Using Python & Cron Automatically receiving a daily report in your inbox with up-to-date financial data can save time, improve decision-making, and reduce…

Oana Rinaldi January 29, 2026

Python

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