Topic notes

PostgreSQL

Indexing, SKIP LOCKED queues, UUID key design, and safe schema migration for PostgreSQL systems.

For developers who can write basic SQL. Follow the list from query contracts to pagination, indexes and plans, then constraints, concurrency, and migrations.

Topic notes

A SELECT Needs Four Decisions: Columns, Rows, Order, Limit

#PostgreSQL#database#SQL+2

2026-08-24

Why does the next page repeat a row? OFFSET and keyset pagination

#PostgreSQL#database#pagination+1

2026-09-09

Indexes follow query shape, not a column checklist

#PostgreSQL#database#index+2

2026-08-28

Do not add an index first: use EXPLAIN, statistics, and ANALYZE to see what PostgreSQL is guessing

#PostgreSQL#database#query performance+2

2026-08-31

PostgreSQL RLS is not an automatic WHERE clause: four boundaries for multi-tenant data

#PostgreSQL#database#security+2

2026-09-17

Supabase RLS Beyond the Policy UI: Make Authorization SQL Testable

#Supabase#PostgreSQL#Row-Level Security+2

2026-09-18

A Database Is Not a JSON Blob: Let Constraints Protect Data

#PostgreSQL#database#SQL+2

2026-08-23

Before JOIN Syntax, Count the Relationship

#PostgreSQL#database#SQL+2

2026-08-25

PostgreSQL 18 Skip Scan: The Leftmost Rule, Revisited

#PostgreSQL#database#B-tree+2

2026-08-11

A schema migration is not one SQL statement: expand, backfill, and observe before you contract

#PostgreSQL#database#schema migration+2

2026-09-02

PostgreSQL SKIP LOCKED: Job Queue, Not Magic Broker

#PostgreSQL#database#concurrency+1

2026-08-14

Transaction Boundaries for Orders, Inventory, and ACID

#PostgreSQL#database#transaction+2

2026-08-27

UUIDv7 for Primary Keys: Better, Not Universal

#PostgreSQL#database#UUIDv7+2

2026-08-05

PgBouncer does not make PostgreSQL infinite: budget connections before choosing a pool mode

#PostgreSQL#database#connection pooling+2

2026-09-16

PostgreSQL backups: what pg_dump, WAL, and PITR actually do

#PostgreSQL#database#backup+2

2026-10-07