01Writing · Tag

Articles tagged "data-integrity".

At a glance
Articles
4
Published
Feb→Mar 2026
Reading time
29 min
In series
2

Articles tagged data-integrity

4 articles

8 min postgressupabasepostgres-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

I never made that change.

6 min supabasepostgrestpostgres

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

The migration ran clean on Tuesday. On Thursday nobody could invite anyone.

7 min javascripttypescripttimezone-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.

I logged six hours on Thursday and they’re showing up under Wednesday.

8 min bubblebubble-list-fielddata-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

The children point at the parent. The parent shows an empty list.

02Narrow it down

03Read in order

2 series run through this tag.

All articles