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.
Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It

Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It

Comments
9 min read
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison

Comments
8 min read
5 RAG Failure Modes Nobody Warns You About in the Tutorials

5 RAG Failure Modes Nobody Warns You About in the Tutorials

Comments
7 min read
70% of Enterprise RAG Deployments Fail Before Production. Here's What Kills Them.

70% of Enterprise RAG Deployments Fail Before Production. Here's What Kills Them.

Comments
7 min read
INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

2
Comments
2 min read
Migrating From a JSON Column to a Proper Schema in Postgres

Migrating From a JSON Column to a Proper Schema in Postgres

1
Comments
6 min read
I built a PostgreSQL learning platform with labs & quizzes — would love feedback

I built a PostgreSQL learning platform with labs & quizzes — would love feedback

Comments
1 min read
GBase 8a Full-Text Index: Features, Queries, and Configuration

GBase 8a Full-Text Index: Features, Queries, and Configuration

2
Comments
2 min read
ShannonBase HTAP Architecture Analysis: From MySQL Optimizer to Vectorized Execution Engine — Overview

ShannonBase HTAP Architecture Analysis: From MySQL Optimizer to Vectorized Execution Engine — Overview

Comments
2 min read
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Comments 1
8 min read
LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

Comments
3 min read
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Comments
6 min read
Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

2
Comments 4
12 min read
The Metadata Structure of Modern Table Formats

The Metadata Structure of Modern Table Formats

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