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
JavaScript Bookmarklet: Save Any Page to Your Reading List
Posted inJavaScript

JavaScript Bookmarklet: Save Any Page to Your Reading List

JavaScript Bookmarklet: Save Any Page to Your Reading List   Bookmarklets are tiny snippets of JavaScript code that run directly in your browser when you click on them. They offer…
Posted by Oana Rinaldi September 13, 2025
Python Script to Monitor and Alert on Disk Usage
Posted inPython

Python Script to Monitor and Alert on Disk Usage

Python Script to Monitor and Alert on Disk Usage   System administrators and DevOps engineers often need to monitor disk space usage to ensure that servers continue operating smoothly. If…
Posted by Oana Rinaldi September 12, 2025
‘SELECT * FROM JSON’: Querying Local JSON Files as Tables with Python
Posted inPython

‘SELECT * FROM JSON’: Querying Local JSON Files as Tables with Python

'SELECT * FROM JSON': Querying Local JSON Files as Tables with Python   If you've ever wished you could run SQL queries directly on JSON files without setting up a…
Posted by Oana Rinaldi September 11, 2025
How to Detect Palindromes Efficiently in Java Without Reversing Strings
Posted inJava

How to Detect Palindromes Efficiently in Java Without Reversing Strings

How to Detect Palindromes Efficiently in Java Without Reversing Strings   When it comes to checking whether a string is a palindrome, the naive approach involves reversing the string and…
Posted by Oana Rinaldi September 10, 2025
Java Automation: Rename Hundreds of Files in Seconds
Posted inJava

Java Automation: Rename Hundreds of Files in Seconds

Java Automation: Rename Hundreds of Files in Seconds   Renaming dozens or even hundreds of files manually is time-consuming and error-prone. Whether you're organizing thousands of camera photos, web assets,…
Posted by Oana Rinaldi September 9, 2025
Transform CSV Data into JSON Using Python in 10 Lines
Posted inPython

Transform CSV Data into JSON Using Python in 10 Lines

Transform CSV Data into JSON Using Python in 10 Lines   Converting CSV files into JSON format is a common task in data workflows. Whether you're cleaning up messy exports,…
Posted by Oana Rinaldi September 8, 2025
Python Script to Clean CSVs with Messy Date Formats
Posted inPython

Python Script to Clean CSVs with Messy Date Formats

Python Script to Clean CSVs with Messy Date Formats   Real-world data is rarely clean — especially when it comes to dates. CSV files collected from external sources often include…
Posted by Oana Rinaldi September 7, 2025
Find Duplicates Fast — Deduping Lists in Python Efficiently
Posted inPython

Find Duplicates Fast — Deduping Lists in Python Efficiently

Find Duplicates Fast — Deduping Lists in Python Efficiently   When working with large datasets, one of the most common tasks developers face is eliminating duplicates. Whether you're cleaning data,…
Posted by Oana Rinaldi September 6, 2025
Intro to Web Scraping: Bash + cURL + grep = Fast Data Extraction
Posted inShell / Bash

Intro to Web Scraping: Bash + cURL + grep = Fast Data Extraction

Intro to Web Scraping: Bash + cURL + grep = Fast Data Extraction   When it comes to quickly extracting data from websites, few tools offer the combined power and…
Posted by Oana Rinaldi September 5, 2025
Python Generator Tricks for Streaming Large Files Line-by-Line
Posted inPython

Python Generator Tricks for Streaming Large Files Line-by-Line

Python Generator Tricks for Streaming Large Files Line-by-Line   When working with massive data files — especially gigabyte-sized CSVs — reading the entire file into memory using standard approaches like…
Posted by Oana Rinaldi September 4, 2025

Posts pagination

Previous page 1 2 3 4 5 … 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