PostgreSQL for the Next.js and SvelteKit stacks through Drizzle ORM and node-postgres (pg): Docker Compose dev and test databases, checked-in SQL migrations with a drift check, a server-only database module and repository, a readiness route, and tests on databases cloned from a migrated template.
PostgreSQL for the Effect stacks (typescript-api, react-router, astro-fullstack): Docker Compose dev and test databases, migrations run by an explicit command, a scoped connection pool, a schema-decoding repository behind an Effect service, and tests on a private database per test file.
PostgreSQL for the FastAPI stacks (python-react, python-api): Docker Compose dev and test services with healthchecks, SQLAlchemy async models with Alembic migrations, make db-* targets, and a test harness that gives each test file its own database cloned from a migrated template.