2025 – Page 7 – Art of Coding

‘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…

Oana Rinaldi October 3, 2025

JavaScript

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…

Oana Rinaldi October 2, 2025

JavaScript

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…

Oana Rinaldi October 1, 2025

SQL

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…

Oana Rinaldi September 30, 2025

Java

@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…

Oana Rinaldi September 29, 2025

Python

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…

Oana Rinaldi September 28, 2025

Python

Automate Invoice Generation with Python and Jinja2

Automate Invoice Generation with Python and Jinja2 Generating invoices manually can be time-consuming and error-prone—especially for freelancers or small businesses juggling multiple clients. With Python and Jinja2, you can…

Oana Rinaldi September 27, 2025

Python

“Set It and Forget It” Web Scraper in Python Using schedule + requests

"Set It and Forget It" Web Scraper in Python Using schedule + requests Web scraping has become an essential tool for automation, data monitoring, and real-time notification systems. Whether…

Oana Rinaldi September 26, 2025

Python

[Python] Turn Gmail into an Automated Alert System

[Python] Turn Gmail into an Automated Alert System In today's world of ever-growing email notifications, manually checking important emails can be inefficient. Imagine a script that scans your Gmail…

Oana Rinaldi September 25, 2025

Shell / Bash

Automate Daily Git Backups with Bash Scripts

Automate Daily Git Backups with Bash Scripts Keeping your source code safe and versioned is one of the core principles of modern software development. Git is already a powerful…

Oana Rinaldi September 24, 2025