DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
5 Reasons Your SQL Index Is Being Ignored (and How to Fix Them)

5 Reasons Your SQL Index Is Being Ignored (and How to Fix Them)

Comments
3 min read
4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

Comments
3 min read
Catch N+1 Queries Before They Catch You

Catch N+1 Queries Before They Catch You

1
Comments
1 min read
SQL Window Functions in 5 Minutes: ROW_NUMBER, RANK, Running Totals, Top N

SQL Window Functions in 5 Minutes: ROW_NUMBER, RANK, Running Totals, Top N

Comments
3 min read
SQL Challenge: Can You Build a Customer Report Using JOIN, GROUP BY and CASE WHEN?

SQL Challenge: Can You Build a Customer Report Using JOIN, GROUP BY and CASE WHEN?

Comments
2 min read
The Fundamentals of Database Creation

The Fundamentals of Database Creation

Comments
2 min read
Data freshness is a schema property: freezing the market price before kickoff

Data freshness is a schema property: freezing the market price before kickoff

Comments
7 min read
Supabase vs Firebase: Which Backend Fits Your Startup?

Supabase vs Firebase: Which Backend Fits Your Startup?

Comments
6 min read
What Happens When Two Services Think They Own the Same Data?

What Happens When Two Services Think They Own the Same Data?

Comments
7 min read
# Week 10 -- Task 1: Connecting a NestJS Tasks API to PostgreSQL with TypeORM

# Week 10 -- Task 1: Connecting a NestJS Tasks API to PostgreSQL with TypeORM

Comments
7 min read
Your AI Agent Can Now Design, Edit and Export Database Schemas with MCP

Your AI Agent Can Now Design, Edit and Export Database Schemas with MCP

Comments
5 min read
First Record with a Specific Value Within Each Group

First Record with a Specific Value Within Each Group

6
Comments
4 min read
PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

Comments
17 min read
SQLAlchemy: Turn Your Python Classes Into Database Tables

SQLAlchemy: Turn Your Python Classes Into Database Tables

Comments
5 min read
Exposing ThingsDB as a MySQL Database

Exposing ThingsDB as a MySQL Database

2
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.