PostgreSQL

Primary relational database. Used in all projects requiring persistent structured storage.

Proficiency: Proficient · 2+ years

Features used

• JSONB columns for semi-structured data
• Full-text search with tsvector
• Row-level security for multi-tenant apps
• pg_trgm for fuzzy text search
• Connection pooling via PgBouncer / Supabase

Typically accessed via Drizzle ORM or Prisma in Next.js projects, raw SQL for analytics queries.

Related: SQL, Docker, Web Dev