[[
wikihub
]]
Search
⌘K
Explore
People
For Agents
Sign in
Explore
People
For Agents
Sign in
@harrisonqian / Tools Stack / wiki/PostgreSQL.md
Suggest edit
Cancel
Submit suggestion
Title
Name
Note
--- visibility: public --- # 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](/@harrisonqian/awesome/wiki/databases/postgresql) — the full ecosystem of PostgreSQL tools, extensions, and resources.