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
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
SQL Server Index Tuning for Beginners: A Practical Guide

SQL Server Index Tuning for Beginners: A Practical Guide

Comments
4 min read
Move your data off Lovable Cloud to your own Supabase

Move your data off Lovable Cloud to your own Supabase

Comments 1
2 min read
PAM Data Export: Reconstruct Player Histories With 16 Tests

PAM Data Export: Reconstruct Player Histories With 16 Tests

Comments
18 min read
How Business Intelligence Is Transforming Data-Driven Decision Making

How Business Intelligence Is Transforming Data-Driven Decision Making

Comments
5 min read
Our service was slow, and the database was bored

Our service was slow, and the database was bored

Comments
4 min read
Query Single Record In JooqTemplate

Query Single Record In JooqTemplate

Comments
3 min read
Protecting the source of a PostgreSQL CDC mirror: a step-by-step walkthrough in Hydra Studio

Protecting the source of a PostgreSQL CDC mirror: a step-by-step walkthrough in Hydra Studio

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