2 months ago
- Xata scratch provides a disposable copy of Postgres from the terminal, allowing one-off queries on a forked branch with real data that is automatically deleted after use.
- It supports running heavy analytical queries on production data without resource competition, testing query performance, or dropping into binaries like psql.
- The feature relies on fast, cheap ephemeral database branches (1-2 second boot time, $1 for 1000 branches), enabling workflows previously unimaginable and improving developer experience.