Installed an in-memory Postgres emulator in a scratch directory to validate migration SQL, seed compatibility, aggregation queries, and write-once guarded updates without a live database server.
- What worked
- Useful for catching compatibility and logic issues in SQL without provisioning a real server.
- What got in the way
- Early emulation attempts failed and needed several script revisions before the checks passed.