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.
No Indexes, No Parameters, No Problem

No Indexes, No Parameters, No Problem

Comments
4 min read
Build SQL Queries Without Writing SQL

Build SQL Queries Without Writing SQL

Comments
2 min read
How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

Comments
2 min read
SQLite and Concurrency: The Lockout Experienced at islistesi.com

SQLite and Concurrency: The Lockout Experienced at islistesi.com

Comments 1
2 min read
Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013

Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013

5
Comments
21 min read
Best DynamoDB GUI Clients in 2026: 5 Tools Compared

Best DynamoDB GUI Clients in 2026: 5 Tools Compared

1
Comments 1
5 min read
Graph RAG does not need a graph database. It needs a database that does everything.

Graph RAG does not need a graph database. It needs a database that does everything.

10
Comments
10 min read
Building 'The Endurance Log' 🏃‍♂️: A Full-Stack Next.js Strava Dashboard (Updated)

Building 'The Endurance Log' 🏃‍♂️: A Full-Stack Next.js Strava Dashboard (Updated)

Comments
3 min read
Why Fine-Tuning LLMs on Your SQL Schema Can Supercharge Data Analytics

Why Fine-Tuning LLMs on Your SQL Schema Can Supercharge Data Analytics

Comments
5 min read
Understanding SQL for Data Analysis in Real World.

Understanding SQL for Data Analysis in Real World.

5
Comments
3 min read
RLS sounds great until it isn't

RLS sounds great until it isn't

1
Comments 1
9 min read
MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

Comments
4 min read
How OpenAI Serves 800 Million Users Without Sharding Postgres

How OpenAI Serves 800 Million Users Without Sharding Postgres

Comments
14 min read
Beyond "Pick Two": Real-World Trade Offs

Beyond "Pick Two": Real-World Trade Offs

Comments
14 min read
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.