Tag: postgres
All the articles with the tag "postgres".
The Code Rolled Back. The Schema Could Not.
A rollback restores the code and leaves the database where the migration put it. Why "no rollbacks" depends on schema changes the previous release can still run against.
The Reply Arrived Twice. The Record Updated Once.
Inbound replies and webhooks must link to the right record exactly once, and generated drafts must wait for a human. Two mechanisms from production systems: key on the sender id, hold behind a gate.
The OAuth Succeeded. The Reports Still Had to Reconcile.
Hardening QuickBooks OAuth server side and structuring Profit and Loss, Balance Sheet and Cash Flow in Postgres so three reports read at different times still agree.
Stripe Holds the Subscription. Your Database Holds a Copy.
Subscription state, idempotent Stripe webhooks and tenant scoped billing tables drawn from multi-tenant platform and ledger work.
The Policy Was Enabled. One Role Still Read Across Tenants.
Auditing Supabase Row Level Security for a multi-role SaaS pilot, testing tenant isolation role by role with the service key outside the test path.
The App Balanced the Ledger. The Database Refused the Write.
Enforcing double-entry balance, integer minor units and append-only audit in Postgres with constraints that refuse the forbidden write.