Raw PostgreSQL
Use postgres.js (or compatible drivers) with thin query modules and generated SQL artifacts.
When to choose raw SQL
Pick the raw Postgres adapter when you want minimal ORM surface area, hand-written queries, or tight control over performance plans.
Connection
Set DATABASE_URL and ensure pooling matches your host (PgBouncer, Neon pooler, and so on). The generated client wraps postgres with typed helpers where applicable.
Migrations
Apply SQL files from db/migrations (path may vary) with psql, a migration runner, or your platform’s job system.
Combine with Hosted providers for Neon or Railway connection patterns.