Problem Statement. prisma/schema.prisma hard-codes provider = "sqlite". Switching
to Postgres production requires manual edits.
Why it matters. Test environment may use SQLite for speed; production must use PG.
A single env-driven switch is safe.
Technical Context. prisma/schema.prisma::datasource.
Expected Outcome. Schema uses provider = env("DATABASE_PROVIDER") and a url/shadowUrl
pattern documented in docs/db/providers.md.
Acceptance Criteria.
- New
DATABASE_PROVIDER env var accepts sqlite|postgresql.
- Migration step validated against both providers in CI matrix.
Files or modules likely to be affected.
prisma/schema.prisma,
new docs/db/providers.md.
Difficulty. Medium
Estimated effort. S
Backlog item #43 from `docs/maintainer-issue-backlog.md.
Problem Statement.
prisma/schema.prismahard-codesprovider = "sqlite". Switchingto Postgres production requires manual edits.
Why it matters. Test environment may use SQLite for speed; production must use PG.
A single env-driven switch is safe.
Technical Context.
prisma/schema.prisma::datasource.Expected Outcome. Schema uses
provider = env("DATABASE_PROVIDER")and aurl/shadowUrlpattern documented in
docs/db/providers.md.Acceptance Criteria.
DATABASE_PROVIDERenv var acceptssqlite|postgresql.Files or modules likely to be affected.
prisma/schema.prisma,new
docs/db/providers.md.Difficulty. Medium
Estimated effort. S
Backlog item #43 from `docs/maintainer-issue-backlog.md.