| (Shameless plug:) Here's the same thing as a docker container you can just keep around which auto-destroys the databases after a set time: https://github.com/ClockworkConsulting/tempgres-server We originally tried to create temporary databases locally, but found that it the fact that each dev had to do extra setup to be a bit of a pain. A docker container is on dockerhub as 'cwconsult/tempgres:v2.1.1' (I think I messed up the last publishing and 'latest' doesn't point to that. I should really fix that tag.) We have a couple of published clients (just for convenience, the REST interface is super-simple, so 'manual' integration is trivial): - https://github.com/ClockworkConsulting/tempgres-client (Java) - https://github.com/ClockworkConsulting/django-tempgres (Django) - https://github.com/BardurArantsson/pg-harness (Haskell) A few nice things about this one is that: - You don't even need a local PostgreSQL - You can keep one somewhere in your LAN and never have to worry about it again. - It integrates trivially with GitLab CI where you just use it as a service inside the build. - Integration super-simple... simple enough to use even in e.g. shell scripts. - No need to worry about tear-down Anyway, just thought I'd mention it since it's relevant to this thread. |