Problem
Provider, merchant, shop, terminal and commercial-terms data was scattered across spreadsheets without history.
Approach
Version and audit every rate and fee. Exact fractions, money in minor units, non-overlapping validity periods and immutable published terms protect financial accuracy. Configuration changes arrive in a private review inbox with secrets masked. DuckDB-WASM runs analytics in the browser; fine-grained permissions and 5-minute grants protect sensitive values.
Measured outcome
One audited source of truth; shop-card load time: 9.0 → 5.5 s
Tech stack
- Lake/Storage
- PlanetScale PostgresD1R2
- Query
- HyperdriveDuckDB-WASMMotherDuck
DuckDB-WASM runs analytics in the browser; the backend never sees analytical data.
- Serve
- Next.jsCloudflare WorkersHonotRPCCloudflare Containers
- Access & infra
- permit.ioTerraform