2025 – Page 4 – Art of Coding

Efficient SQL: Deduplicate Rows Without Losing Data

Efficient SQL: Deduplicate Rows Without Losing Data Duplicates in your database can lead to bloated storage, inaccurate analytics, and unexpected behavior. But purging them blindly can mean losing valuable…

Oana Rinaldi November 29, 2025

Python

Parsing Complex Logs into Insights with Python and Regex

Parsing Complex Logs into Insights with Python and Regex Logs are the pulse of any software system, devops toolchain, or backend app. Buried within those multiline log files are…

Oana Rinaldi November 16, 2025

JavaScript

Design a Simple Rate Limiter Using Redis and Node.js

Design a Simple Rate Limiter Using Redis and Node.js Rate limiting is a crucial technique for controlling traffic to your APIs and protecting your application from abuse, DDoS attacks,…

Oana Rinaldi November 15, 2025

JavaScript

How Async/Await Works under the Hood in JavaScript

How Async/Await Works under the Hood in JavaScript Async/await has made asynchronous programming in JavaScript more readable and expressive. But have you ever wondered how it actually works under…

Oana Rinaldi November 14, 2025

Python

Data Cleaning with Pandas: Fixing Messy CSVs Step-by-Step

Data Cleaning with Pandas: Fixing Messy CSVs Step-by-Step If you've spent any time working with real-world data, you already know: it's rarely clean. Broken formats, missing values, inconsistent naming,…

Oana Rinaldi November 12, 2025

JavaScript

Web Scraping with Cheerio.js: Extract Job Listings into CSV

Web Scraping with Cheerio.js: Extract Job Listings into CSV Web scraping has become an essential tool for gathering data from websites for analysis, automation, or reporting. In this tutorial,…

Oana Rinaldi November 11, 2025

Shell / Bash

(Ab)using Bash Loops to Rename Log Files by Date Automatically

(Ab)using Bash Loops to Rename Log Files by Date Automatically Log files are the bread and butter of system and application diagnostics — but without proper naming conventions, managing…

Oana Rinaldi November 9, 2025

JavaScript

Consuming Public APIs in JavaScript Without Axios or jQuery

Consuming Public APIs in JavaScript Without Axios or jQuery Modern JavaScript gives us a powerful native tool to make HTTP requests: the Fetch API. Unlike older approaches that relied…

Oana Rinaldi November 8, 2025

JavaScript

Auto-Reply Gmail Emails Using Google Apps Script (JavaScript)

Auto-Reply Gmail Emails Using Google Apps Script (JavaScript) Automating email responses is a game-changer for productivity. Whether you're managing customer support, internal communication, or just want cleaner inbox management,…

Oana Rinaldi November 7, 2025

Shell / Bash

Automate File Organization by Type with Bash Scripts

Automate File Organization by Type with Bash Scripts Manually sorting files is a repetitive task that can eat into your productivity, especially if you deal with frequent downloads, reports,…

Oana Rinaldi November 6, 2025