Posts tagged “PostgreSQL”

tsvector, GIN indexes, ranking with ts_rank, language configs, and when to reach for Elasticsearch instead.

Schema as code, migrations, relations vs manual joins, SQL-like query builder, and comparing Drizzle to Prisma for control freaks.

Expand and contract migrations, backfills, shadow databases, zero-downtime renames, and operational checklists for Postgres under load.