Skip to content

Art of Coding

Art of Coding

  • Advanced
  • AI / Machine Learning
  • Algorithms
  • API Integration
  • Automation Scripts
  • Beginner
  • C#
  • C++
  • Data Structures
  • Databases
  • DevOps / CLI Tools
  • Dynamic Programming
  • Go
  • Graph Theory
  • HTML / CSS
  • Intermediate
  • Java
  • JavaScript
  • Python
  • Recursion
  • Rust
  • Search Algorithms
  • Shell / Bash
  • Sorting Algorithms
  • SQL
  • TypeScript
  • Uncategorized
  • Web Development
Top Stories
‘GROUP BY’ Pitfalls: Avoiding Common SQL Aggregation Errors
October 3, 2025
Create a JavaScript Bookmarklet That Cleans Up Blog Pages
October 2, 2025
JavaScript Bookmarklet to Extract Table Data into CSV
October 1, 2025
Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained
September 30, 2025
@Query Annotation Magic: Custom SQL in Spring Boot Repositories
September 29, 2025
Create a Personal Expense Tracker with SQLite and Python
September 28, 2025
Automate Invoice Generation with Python and Jinja2
September 27, 2025
“Set It and Forget It” Web Scraper in Python Using schedule + requests
September 26, 2025
[Python] Turn Gmail into an Automated Alert System
September 25, 2025
Automate Daily Git Backups with Bash Scripts
September 24, 2025
Automate File Backup With a Bash Script and Cron Job
September 23, 2025
SQL Window Functions Demystified: Real Analytics Queries Explained
September 22, 2025
Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree
September 21, 2025
Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux
September 20, 2025
Python Script to Auto-Fill Online Forms Using Selenium
September 19, 2025
Build a YouTube Playlist Downloader with Python and Pytube
September 18, 2025
Build a Currency Converter CLI in Java in Under 30 Minutes
September 17, 2025
“SELECT *” is Killing You: Write Optimized SQL Queries
September 16, 2025
‘SELECT … WITH RECURSIVE’: Advanced SQL Tree Traversals Explained
September 15, 2025
Build a CLI Weather App in Bash with curl and jq
September 14, 2025
JavaScript Bookmarklet: Save Any Page to Your Reading List
September 13, 2025
Python Script to Monitor and Alert on Disk Usage
September 12, 2025
‘SELECT * FROM JSON’: Querying Local JSON Files as Tables with Python
September 11, 2025
How to Detect Palindromes Efficiently in Java Without Reversing Strings
September 10, 2025
Java Automation: Rename Hundreds of Files in Seconds
September 9, 2025
Transform CSV Data into JSON Using Python in 10 Lines
September 8, 2025
Python Script to Clean CSVs with Messy Date Formats
September 7, 2025
Find Duplicates Fast — Deduping Lists in Python Efficiently
September 6, 2025
Intro to Web Scraping: Bash + cURL + grep = Fast Data Extraction
September 5, 2025
Python Generator Tricks for Streaming Large Files Line-by-Line
September 4, 2025
Build an Email Reminder Bot in Python That Reads From Google Sheets
September 3, 2025
Real-Time Currency Converter Using Python and ExchangeRate API
September 2, 2025
Web Scraping Price Data with BeautifulSoup and Writing to SQL
September 1, 2025
Debounce This! Implementing Debounce in Plain JavaScript
August 31, 2025
Build a Currency Converter Using Fetch API and Exchange Rates
August 30, 2025
Clean Up Messy CSVs Using Pandas: A Real-World Data Wrangling Guide
August 29, 2025
JavaScript Throttling vs Debouncing: See It Live with Scroll Events
August 28, 2025
Build a URL Shortener in Java Using Servlets
August 27, 2025
$PATH Demystified: Add Your Scripts to Bash Path Like a DevOps Engineer
August 26, 2025
Create a CLI Tool to Monitor System Health Using Bash
August 25, 2025
Java Regex Recipes for Everyday Text Cleanup
August 24, 2025
From CSV to JSON: A Node.js Utility You Can Reuse Anywhere
August 23, 2025
JavaScript Debounce Function Explained with Real UX Fixes
August 22, 2025
Mastering SQL Window Functions for Financial Analytics
August 21, 2025
Sorting Large Datasets: QuickSort vs MergeSort Visualized in Java
August 20, 2025
Scraping the Weather: Build a Python CLI for Real-Time Forecasts
August 19, 2025
Find Longest Consecutive Sequence Algorithm Solved in Python One-Liner Style
August 18, 2025
Optimize SQL Queries by Profiling Execution Plans
August 17, 2025
Build a RESTful CRUD API in Java with Spring Boot
August 16, 2025
Java Regex Recipes: Validate Email Addresses Like a Pro
August 15, 2025
(Ab)Using CSS Variables from JavaScript Dynamically
August 14, 2025
Stream Real-Time Logs Across Systems Using Netcat and Bash
August 13, 2025
Using Python’s difflib to Build a Simple ‘Track Changes’ Tool
August 12, 2025
Create Your Own URL Shortener Using Flask and SQLite
August 11, 2025
[JS] Count Word Frequency Live as You Type (No Libraries)
August 10, 2025
Build a Stock Tracker Email Bot in Python Using YFinance & smtplib
August 9, 2025
Recursive File Search with Java: Build Your Own ‘find’ Utility
August 8, 2025
Build an Auto-Responder Bot Using JavaScript and Gmail API
August 7, 2025
#100DaysOfCode Tracker Built With HTML5 LocalStorage + JS Only
August 6, 2025
“Find Missing Integers” Problem Solved with SQL Anti Joins
August 5, 2025
Automate Your Git Commits with a Bash Script
August 4, 2025
Create a RESTful API in Java with Spring Boot in Under 15 Minutes
August 3, 2025
“Instant Checkout” Button in Vanilla JS + Fetch API
August 2, 2025
Algorithm Deep Dive: Sliding Window in JavaScript for Subarray Sums
August 1, 2025
Diagnose Database Performance Issues with SQL EXPLAIN Plans
August 1, 2025
SQL Pivot Tables with CASE WHEN Logic
August 1, 2025
Build an HTTP Status Code Checker Using Bash For Loop + curl
August 1, 2025
Optimize SQL Queries with Indexing: A Practical Walkthrough
August 1, 2025
@Scheduled: Write Robust Cron Jobs in Spring Boot
August 1, 2025
@Transactional in Spring Boot: How It Actually Works (With Code)
August 1, 2025
JavaScript Object Deep Clone Techniques Without External Libraries
August 1, 2025
Binary Search Algorithm in Python
August 1, 2025
Selection Sort Algorithm in Python
August 1, 2025
Posted inSQL

‘GROUP BY’ Pitfalls: Avoiding Common SQL Aggregation Errors

'GROUP BY' Pitfalls: Avoiding Common SQL Aggregation Errors   Introduction SQL's GROUP BY clause is a powerful tool for summarizing data, but it's also a frequent source of confusion, especially…
Continue Reading
Posted by Oana Rinaldi October 3, 2025
Posted inJavaScript

Create a JavaScript Bookmarklet That Cleans Up Blog Pages

Create a JavaScript Bookmarklet That Cleans Up Blog Pages   Ever landed on a blog page only to be swarmed by popups, sticky sidebars, and jittery ads? While browser extensions…
Continue Reading
Posted by Oana Rinaldi October 2, 2025
Posted inJavaScript

JavaScript Bookmarklet to Extract Table Data into CSV

JavaScript Bookmarklet to Extract Table Data into CSV   Have you ever landed on a website with a useful HTML table but no option to export the data? With this…
Continue Reading
Posted by Oana Rinaldi October 1, 2025
Posted inSQL

Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained

Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained   Working with relational databases often means working with multiple related tables. Whether you're building reports for an e-commerce…
Continue Reading
Posted by Oana Rinaldi September 30, 2025
Posted inJava

@Query Annotation Magic: Custom SQL in Spring Boot Repositories

@Query Annotation Magic: Custom SQL in Spring Boot Repositories   Spring Data JPA’s power lies in its ability to abstract away complex data connectivity layers. But there comes a point…
Continue Reading
Posted by Oana Rinaldi September 29, 2025
Posted inPython

Create a Personal Expense Tracker with SQLite and Python

Create a Personal Expense Tracker with SQLite and Python   Managing personal finances doesn't need a fancy web application or integration with a bank API. Sometimes, a simple terminal-based utility…
Continue Reading
Posted by Oana Rinaldi September 28, 2025
Automate File Backup With a Bash Script and Cron Job
Posted inShell / Bash

Automate File Backup With a Bash Script and Cron Job

Automate File Backup With a Bash Script and Cron Job   Backing up important data is essential for developers, system administrators, and anyone handling critical files. In this post, we'll…
Posted by Oana Rinaldi September 23, 2025
SQL Window Functions Demystified: Real Analytics Queries Explained
Posted inSQL

SQL Window Functions Demystified: Real Analytics Queries Explained

SQL Window Functions Demystified: Real Analytics Queries Explained   SQL window functions are one of the most powerful — yet often misunderstood — features in modern SQL. These functions enable…
Posted by Oana Rinaldi September 22, 2025
Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree
Posted inShell / Bash

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree   Managing disk space efficiently is a common concern for system administrators and developers alike. Files can…
Posted by Oana Rinaldi September 21, 2025
Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux
Posted inShell / Bash

Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux

Clean Up Your Downloads Folder: A Bash Automation Script for Mac/Linux   Does your ~/Downloads folder look like a digital junk drawer? PDFs next to random installers, screenshots neighbors with…
Posted by Oana Rinaldi September 20, 2025
Python Script to Auto-Fill Online Forms Using Selenium
Posted inPython

Python Script to Auto-Fill Online Forms Using Selenium

Python Script to Auto-Fill Online Forms Using Selenium   Filling out online forms for surveys, registrations, or repetitive tasks can quickly become a tedious chore. Fortunately, Python combined with Selenium…
Posted by Oana Rinaldi September 19, 2025
Build a YouTube Playlist Downloader with Python and Pytube
Posted inPython

Build a YouTube Playlist Downloader with Python and Pytube

Build a YouTube Playlist Downloader with Python and Pytube   If you've ever wanted to download an entire YouTube playlist for offline viewing or archiving, Python makes this process simple…
Posted by Oana Rinaldi September 18, 2025
Build a Currency Converter CLI in Java in Under 30 Minutes
Posted inJava

Build a Currency Converter CLI in Java in Under 30 Minutes

Build a Currency Converter CLI in Java in Under 30 Minutes   If you’ve ever needed to convert currencies on the fly, building a command-line interface (CLI) tool in Java…
Posted by Oana Rinaldi September 17, 2025
“SELECT *” is Killing You: Write Optimized SQL Queries
Posted inSQL

“SELECT *” is Killing You: Write Optimized SQL Queries

"SELECT *" is Killing You: Write Optimized SQL Queries   When working with SQL, it’s tempting to take shortcuts—perhaps the most common being SELECT *. It’s quick, convenient, and works…
Posted by Oana Rinaldi September 16, 2025
‘SELECT … WITH RECURSIVE’: Advanced SQL Tree Traversals Explained
Posted inSQL

‘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…
Posted by Oana Rinaldi September 15, 2025
Build a CLI Weather App in Bash with curl and jq
Posted inShell / 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…
Posted by Oana Rinaldi September 14, 2025

Posts pagination

Previous page 1 2 3 4 … 8 Next page

Recent Posts

  • ‘GROUP BY’ Pitfalls: Avoiding Common SQL Aggregation Errors
  • Create a JavaScript Bookmarklet That Cleans Up Blog Pages
  • JavaScript Bookmarklet to Extract Table Data into CSV
  • Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained
  • @Query Annotation Magic: Custom SQL in Spring Boot Repositories

Recent Comments

No comments to show.

Archives

  • October 2025
  • September 2025
  • August 2025

Categories

  • Databases
  • Java
  • JavaScript
  • Python
  • Search Algorithms
  • Shell / Bash
  • Sorting Algorithms
  • SQL
You May Have Missed
Posted inSQL

‘GROUP BY’ Pitfalls: Avoiding Common SQL Aggregation Errors

Posted by Oana Rinaldi October 3, 2025
Posted inJavaScript

Create a JavaScript Bookmarklet That Cleans Up Blog Pages

Posted by Oana Rinaldi October 2, 2025
Posted inJavaScript

JavaScript Bookmarklet to Extract Table Data into CSV

Posted by Oana Rinaldi October 1, 2025
Posted inSQL

Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained

Posted by Oana Rinaldi September 30, 2025
Copyright 2025 — Art of Coding. All rights reserved. Bloghash WordPress Theme
Scroll to Top