Re:Ephemeral Postgres Databases
by stansler on Wednesday November 17, 2021 @05:00PM
(#29259419)
Another approach is to use Database Lab (https://gitlab.com/postgres-ai/database-lab). Our tool allows deploying disposable Postgres databases in seconds using REST API, CLI, or GUI. The difference is that we provide clones with snapshots of full-sized data. For example, you may have dozens of clones of your production databases (with masked sensitive data) to use as staging servers, database migration verification, tests, and all that provisioned in a couple of seconds.
Re:Ephemeral Postgres Databases
by Kinrany on Wednesday November 17, 2021 @06:00PM
(#29259983)
This sounds like a different problem, not a different approach: "in seconds" is only good for integration tests, and the topic is about (sub-second) unit tests.
More about using full-sized Postgres clones for migration testing and why is that important: https://postgres.ai/products/database-migration-testing