#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)

Introduction Imagine logging into your bank account only to discover that someone else got in without your password. Scary, right? That’s not a movie plot—it’s often the result of an SQ...

05.04.2025 0 Read More

I Made a Detective Game That Teaches You SQL

A month ago, I launched a small passion project called SQL Noir — a web-based detective game where you solve crimes using real SQL queries.I built it as a way to teach SQL through storytelling and l...

06.04.2025 0 Read More

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Are you working with @forge/sql and struggling with pagination + total count? Here's a more efficient and safer way to do it using window functions. 💡 The problem In typical pagination, we ...

06.04.2025 0 Read More

Basics of Animal Tracking Databases: Crafting the Schema

“ChatGPT, whip up a next-gen animal tracking database for me…” In my last post, Basics of Animal Tracking Databases, we nailed the essentials: core entities, a tight data model, and why SQL is t...

06.04.2025 0 Read More

Where SQL joins struggle but MongoDB documents shine

Claims such as "Joins are slow" or "Joins don't scale" often prompt me to showcase how efficiently rows can be joined in a SQL database (here, here, or here). However, user perception of slowness pers...

06.04.2025 0 Read More

Deduplicate between an uncertain number of columns：SQL VS SPL #15

A certain database table has multiple fields, each storing an email address, which may be null or duplicated. Now we need to merge multiple fields into one, remove null and duplicate values, and merge...

07.04.2025 0 Read More

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story is a guest Stack Post from the community Convex Champion, Matt Luo.To someone new to Convex, it might look like Co...

07.04.2025 0 Read More

Oracle 23ai — Automatic SQL Transpiler Feature

As you may know, using a function in an SQL statement causes a context switch between the SQL engine and the PL/SQL engine. Frequent context switches can negatively impact database performance.To impr...

07.04.2025 0 Read More

Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

Hi! In today’s article, we’ll walk through a small ELT project, revisiting each step of the process and diving deep into the details.So, hop on and let’s get started! Extract As always, ...

07.04.2025 0 Read More

Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

In many organizations, capturing and analyzing changes in data over time is crucial. Whether it’s tracking inventory, customer behavior, or sales trends, having historical snapshots can unlock power...

07.04.2025 0 Read More

One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)

I Made a Detective Game That Teaches You SQL

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Basics of Animal Tracking Databases: Crafting the Schema

Where SQL joins struggle but MongoDB documents shine

Deduplicate between an uncertain number of columns：SQL VS SPL #15

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story

Oracle 23ai — Automatic SQL Transpiler Feature

Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

#reading

#popular