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.
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
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
How We Built a 162K-Word Database on Cloudflare Workers + D1

How We Built a 162K-Word Database on Cloudflare Workers + D1

Comments
4 min read
SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

1
Comments 1
2 min read
Room Database Complete Guide: Local Data Persistence in Compose

Room Database Complete Guide: Local Data Persistence in Compose

Comments
3 min read
Comparing Today's Multi-Model Databases

Comparing Today's Multi-Model Databases

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