ls ~/writing --tag=data-integrity

[01]Writing · Tag

Articles tagged "data-integrity".

$ tag --stat data-integrity
Articles
4
Published
Feb→Mar 2026
Reading time
29 min
In series
2

Articles tagged data-integrity

4 articles

8 min [postgres][supabase][postgres-triggers]

How to build a tamper-evident audit log in Postgres with one trigger

Build an audit log table, attach a SECURITY DEFINER trigger that captures every UPDATE and DELETE, lock it down with RLS. Forty lines of SQL.

Supabase Production Hardening 3/8

audit-log-postgres-trigger-tutorial--cover
I never made that change.

6 min [supabase][postgrest][postgres]

How a Postgres constraint rename silently broke production via PostgREST

PostgREST resolves onConflict against real constraint names at runtime. Rename a constraint and the upsert silently fails with a 400 nobody notices.

Supabase Production Hardening 2/8

postgrest-upsert-constraint-rename-fragility--cover
The migration ran clean on Tuesday. On Thursday nobody could invite anyone.

7 min [javascript][typescript][timezone-handling]

Silent timezone bugs in JavaScript date arithmetic

`new Date().toISOString().split('T')[0]` returns the UTC date, not the user's local date. The bug, the fix, and why it only shows up in production.

silent-timezone-bugs-javascript-date--cover
I logged six hours on Thursday and they’re showing up under Wednesday.

8 min [bubble][bubble-list-field][data-integrity]

Why I stopped trusting Bubble.io's list fields and re-query the database instead

Bubble.io list fields don't auto-update when children point at parents. Re-query the database, write the actual list back. Here is the pattern.

Data Pipeline Reliability 4/4

re-query-database-platform-relationships--cover
The children point at the parent. The parent shows an empty list.

[02]Narrow it down

[03]Read in order

2 series run through this tag.

All articles