Skip to content
TechPlained

#PostgreSQL

31 articles

Vector Databases: What They Are, How They Work, and When You Need One
AI/ML Engineering

Vector Databases: What They Are, How They Work, and When You Need One

A practical guide to vector databases -- how embeddings and ANN algorithms work, and an honest comparison of Pinecone, Weaviate, Qdrant, and pgvector.

11 min read·
CQRS and Event Sourcing: A Practical Introduction
Architecture

CQRS and Event Sourcing: A Practical Introduction

CQRS separates read and write models for independent optimization. Event Sourcing stores every state change as an immutable event. Learn when each pattern solves real problems, with TypeScript implementations, projection examples, and event store comparisons.

16 min read·
The CAP Theorem: What It Actually Means for Your Database Choices
Architecture

The CAP Theorem: What It Actually Means for Your Database Choices

The CAP theorem forces a trade-off between consistency and availability during network partitions. Learn how PostgreSQL, Cassandra, DynamoDB, and other databases handle this trade-off, plus the PACELC extension that captures what CAP misses.

12 min read·
PostgreSQL Indexes Explained: B-Tree, GIN, GiST, Hash, and BRIN
Databases

PostgreSQL Indexes Explained: B-Tree, GIN, GiST, Hash, and BRIN

A complete guide to PostgreSQL index types. Learn when to use B-Tree, Hash, GIN, GiST, BRIN, and partial indexes with real SQL examples, EXPLAIN ANALYZE verification, and index maintenance strategies.

14 min read·
← NewerPage 4 of 4

Stay in the loop

New articles delivered to your inbox. No spam.