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
Posted inJavaScript

JavaScript Object Deep Clone Techniques Without External Libraries

JavaScript Object Deep Clone Techniques Without External Libraries Cloning objects in JavaScript may seem trivial at first glance, but once nested structures come into play, things can get complicated fast.…
Posted by Oana Rinaldi August 1, 2025
Posted inSearch Algorithms

Binary Search Algorithm in Python

🔹 Introduction Binary Search is a powerful searching algorithm used on sorted arrays or lists. It repeatedly divides the search interval in half, making it extremely efficient — much faster…
Posted by oanaunciuleanu@gmail.com August 1, 2025
Posted inSorting Algorithms

Selection Sort Algorithm in Python

🔹 Introduction Selection Sort is a simple comparison-based sorting algorithm. It divides the input list into a sorted and an unsorted part and repeatedly selects the smallest (or largest) element…
Posted by oanaunciuleanu@gmail.com August 1, 2025

Posts pagination

Previous page 1 … 6 7 8

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