PostgreSQL

primary database. the one database you need for almost everything.

installed via: brew install postgresql@16

extensions: pgvector installed (brew install pgvector) for vector similarity search — used with AI/embedding workflows.

in the stack: locally for development, remotely on AWS Lightsail for production. also use Supabase (via MCP) as a managed Postgres option for some projects.

why Postgres: rock-solid, SQL-native, extensible (pgvector, PostGIS, etc.), and the ecosystem tooling is unmatched.

deep dive: awesome-postgres — the full ecosystem of PostgreSQL tools, extensions, and resources.