Art of Coding – Art of Coding

‘SELECT *’ is (Still) Killing Your DB: Write Safer SQL Queries with Code Samples

'SELECT *' is (Still) Killing Your DB: Write Safer SQL Queries with Code Samples Stop using SELECT * in your queries—you're silently sabotaging your database performance. Whether you're optimizing…

Oana Rinaldi February 7, 2026

Shell / Bash

Parsing PDFs in Bash: Extract Data in Seconds

Parsing PDFs in Bash: Extract Data in Seconds Working with PDF files on the command line may seem daunting due to their binary complexity, but with the right tools,…

Oana Rinaldi February 6, 2026

Shell / Bash

Build a REST API Client in Bash Using curl and jq

Build a REST API Client in Bash Using curl and jq When people think of REST API clients, they often imagine sophisticated libraries in Python or JavaScript. But with…

Oana Rinaldi February 5, 2026

Shell / Bash

From Cronjob to CLI: Create a Bash Tool That Sends Daily Weather SMS

From Cronjob to CLI: Create a Bash Tool That Sends Daily Weather SMS Need a daily weather forecast texted straight to your phone? In this tutorial, we'll show you…

Oana Rinaldi February 4, 2026

JavaScript

JavaScript Debouncing Explained with Scroll Event Optimization

JavaScript Debouncing Explained with Scroll Event Optimization In web development, performance is key—especially when dealing with events that fire rapidly, such as scrolling, resizing, or keypresses. Without managing these…

Oana Rinaldi February 3, 2026

JavaScript

Build a Live Search Filter in Vanilla JavaScript

Build a Live Search Filter in Vanilla JavaScript Interactive UI features like live search provide real-time feedback and deliver a dynamic user experience. In this hands-on tutorial, we’ll walk…

Oana Rinaldi February 2, 2026

Shell / Bash

Build a REST API Client in Bash Using Curl and jq

Build a REST API Client in Bash Using Curl and jq Interacting with RESTful APIs doesn’t always require Python, Node, or Postman. You can harness the simplicity and ubiquity…

Oana Rinaldi February 1, 2026

Python

Python Meets Excel: Automate Monthly Reports Without Opening Excel

Python Meets Excel: Automate Monthly Reports Without Opening Excel Manually updating Excel reports every month is tedious, error-prone, and unnecessary in 2024. With just a few lines of Python…

Oana Rinaldi January 31, 2026

SQL

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