pg-harness: REST service for creating temporary PostgreSQL databases
|Versions||0.1.0, 0.1.2, 0.2.0, 0.2.1|
|Dependencies||async (>=18.104.22.168 && <3), base (==4.*), ini (==0.2.*), postgresql‑simple (>=0.4.2 && <0.5), random (==1.0.*), scotty (>=0.7.0 && <0.8), text (>=1.1.0 && <2), transformers (>=0.4.1 && <0.5) [details]|
|Copyright||Copyright (c) 2014 Bardur Arantsson|
|Category||Database Testing Web|
|Uploaded||by BardurArantsson at Mon Sep 15 18:09:52 UTC 2014|
|Downloads||1088 total (14 in the last 30 days)|
|Rating||(no votes yet) [estimated by rule of succession]|
|Status||Docs not available [build log]
Last success reported on 2015-06-06 [all 5 reports]
Hackage Matrix CI
This is a REST service for conveniently creating temporary PostgreSQL databases. It is intended for use from tests.
Simply install, update the configuration INI file to
suit your setup, and run as a system service (e.g.
via systemd, upstart or similar) -- see the
file for details on what is required of the database
Once the service is running you can do a HTTP POST to it to create a temporary database. For example,
$ curl -d '' http://localhost:8900 pg-harness-test:pg-harness-pass@db:5432/temp_ba36rk6rqvs92wbofk55sz5k3pcl0u74x
The response indicates that the temporary database "
has been created on the database server "
db" (port 5432) and made available
to the user "
pg-harness-test" using the password "
The database will automatically be destroyed after a configurable duration, though any temporary databases that have not been destroyed when the service is stopped will stay around.
NOTE: No attempt has been made to prevent DoS attacks, so you should NOT run this on any network facing the public Internet. It is only meant for development LANs which are firewalled off.
For package maintainers and hackage trustees