Use moddatetime triggers for updated_at columns | BeforeMerge Rules | BeforeMerge

Use moddatetime triggers for updated_at columns | BeforeMerge Rules | BeforeMerge

Why This Matters

Database triggers guarantee updated_at is always current, regardless of which code path updates the row.

Good

CREATE TRIGGER handle_updated_at
  BEFORE UPDATE ON rules
  FOR EACH ROW
  EXECUTE FUNCTION extensions.moddatetime(updated_at);

Bad

// Some code paths forget to update the timestamp
await supabase.from("rules").update({
  title: newTitle,
  // forgot updated_at!
})