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
gabrielanhaia profile

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

#database #architecture #postgres #mongodb
Comments
9 min read
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison
gabrielanhaia profile

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

#pgvector #database #rag #postgres
Comments
8 min read
INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples
michaelfv profile

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

#gbase #database #数据库
2
Comments
2 min read
Migrating From a JSON Column to a Proper Schema in Postgres
gabrielanhaia profile

Migrating From a JSON Column to a Proper Schema in Postgres

#postgres #database #tutorial #devops
1
Comments
6 min read
I built a PostgreSQL learning platform with labs & quizzes — would love feedback
missak_boyajian profile

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

#database #postgressql #sql #product
Comments
1 min read
GBase 8a Full-Text Index: Features, Queries, and Configuration
michaelfv profile

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

#backend #database #sql #tutorial
2
Comments
2 min read
ShannonBase HTAP Architecture Analysis: From MySQL Optimizer to Vectorized Execution Engine — Overview
shannonbase profile

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

#architecture #database #performance #systemdesign
Comments
2 min read
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs
gabrielanhaia profile

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

#database #architecture #postgres #tutorial
Comments 1
8 min read
Building a Database Performance Testing Tool With AI: The Honest Breakdown

Explores N+1 and schema regressions
m4rri4nne profile

Building a Database Performance Testing Tool With AI: The Honest Breakdown

#ai #testing #database #performance
73
Comments 10
6 min read
LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure
dylan_dumont_266378d98367 profile

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

#architecture #database #systems #backend
Comments
3 min read
Don’t Trust Backups You Haven’t Restored
alzhi_f93e67fa45b972 profile

Don’t Trust Backups You Haven’t Restored

#go #postgres #database
Comments
8 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead
alex_kargin profile

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

#postgres #database #postgressql #dataengineering
Comments
6 min read
Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)
vektor_memory_43f51a32376 profile

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

#ai #vectordatabase #opensource #database
2
Comments 4
12 min read
The Metadata Structure of Modern Table Formats
alexmercedcoder profile

The Metadata Structure of Modern Table Formats

#architecture #database #dataengineering #tutorial
Comments
7 min read
3 General Methods to Optimize Query Performance in GBase 8a
michaelfv profile

3 General Methods to Optimize Query Performance in GBase 8a

#gbase #database #数据库
2
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.