Playbooks & production notes
Data Safety
Practical checks for protecting customer data, preventing destructive mistakes, and making recovery possible when an AI-built app reaches production.
Backups nobody has restored, deletes with no undo, and the exports customers are owed. For founders whose AI-built app now holds data they cannot afford to lose. Start with "Supabase Backup", then "Accidentally Deleted the Production Database: The First Hour".
Data Safety
How to analyze Postgres query plans: finding the slow queries, reading EXPLAIN, and adding the indexes that actually help
Data Safety
Connection pooling Postgres apps need: what it is, how to size the pool, and how to test it under load
Data Safety
The database cleanup checklist: finding orphaned rows, deleting junk safely, and proving nothing valid went with it
Data Safety
The database review checklist: constraints, keys, cascade rules, and a data model a reviewer can read
Data Safety
The disaster recovery checklist for SaaS: the one-page plan, the timed drill, and the evidence a reviewer asks for
Data Safety
How to generate realistic fake data for staging: a repeatable seed script for an empty test database
Data Safety
How to wrap multiple writes in a transaction, so a failed signup or order leaves nothing half-finished
Data Safety
The object storage security checklist: signed links, upload limits, and the bucket that is public by accident
Data Safety
What is soft delete? When a deleted record should be recoverable, and how to add it without breaking every query
Data Safety
A business continuity plan template for a small SaaS: the one-page plan, the impact analysis, and the parts that apply to a two-person company
Data Safety
Cannot execute INSERT in a read-only transaction: what put your database in read-only mode, and how to get writes back
Data Safety
The data consistency checklist for SaaS: 14 database checks between a demo and production
Data Safety
The database backup checklist for startups: what your host keeps, the retention to set, and the off-site copy
Data Safety
Database encryption for a small SaaS: what at rest and in transit already cover, and the fields worth encrypting yourself
Data Safety
The database migration checklist: moving dashboard schema changes into ordered, version-controlled migrations
Data Safety
How to harden managed database settings: who can connect, which role the app uses, TLS, and the encryption you already have
Data Safety
The time zone handling checklist: store UTC, display local, and stop the off-by-one-day bug
Data Safety