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.
The Complete Guide to PostgreSQL Lock Types for Schema Changes

The Complete Guide to PostgreSQL Lock Types for Schema Changes

1
Comments
5 min read
How to Monitor MongoDB Metrics with OpenTelemetry

How to Monitor MongoDB Metrics with OpenTelemetry

2
Comments
11 min read
World-Building with Persistence: Narrative Layers in AI Agents

World-Building with Persistence: Narrative Layers in AI Agents

1
Comments
3 min read
Why your AI agents have goldfish syndrome —and how I fixed it with a memory graph

Why your AI agents have goldfish syndrome —and how I fixed it with a memory graph

1
Comments
6 min read
The Memory Wall: Why Associative Pathfinding is the Final Frontier for AI Agents

The Memory Wall: Why Associative Pathfinding is the Final Frontier for AI Agents

1
Comments
2 min read
Designing Efficient Queries with SQL Joins and Window Functions

Designing Efficient Queries with SQL Joins and Window Functions

2
Comments
7 min read
SQL Joins and Window Functions- What I Learned Catching Up After Missing Class..

SQL Joins and Window Functions- What I Learned Catching Up After Missing Class..

Comments
4 min read
Database Indexing Explained: How to Make Your Queries 1000x Faster

Database Indexing Explained: How to Make Your Queries 1000x Faster

1
Comments
3 min read
PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

Comments
3 min read
PostgreSQL Internals: Inside the Storage Engine

PostgreSQL Internals: Inside the Storage Engine

1
Comments
9 min read
Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Comments
4 min read
How SQLite Executes Queries Through Its API Lifecycle

How SQLite Executes Queries Through Its API Lifecycle

20
Comments
3 min read
Stop paying the Goldfish Tax: Why your agent's memory is a massive waste of money

Stop paying the Goldfish Tax: Why your agent's memory is a massive waste of money

1
Comments
2 min read
Data Pipeline Architecture: From Messy CSVs to Clean Database

Data Pipeline Architecture: From Messy CSVs to Clean Database

Comments
5 min read
How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

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