pg-harness: REST service for creating temporary PostgreSQL databases

This is a package candidate release! Here you can preview how this package release will appear once published to the main package index (which can be accomplished via the 'maintain' link below). Please note that once a package has been published to the main package index it cannot be undone! Please consult the package uploading documentation for more information.

[maintain] [Publish]

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 SETUP.txt file for details on what is required of the database setup.

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 "temp_ba36rk6rqvs92wbofk55sz5k3pcl0u74x" has been created on the database server "db" (port 5432) and made available to the user "pg-harness-test" using the password "pg-harness-pass".

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.

Properties

Versions 0.1.0, 0.1.1, 0.1.2, 0.2.0, 0.2.1
Change log None available
Dependencies async (>=2.0.1.5 && <3), base (>=4 && <5), ini (>=0.2 && <0.3), postgresql-simple (>=0.4.2 && <0.5), random (>=1.0 && <1.1), scotty (>=0.7.0 && <0.8), text (>=1.1.0 && <2), transformers (>=0.4.1 && <0.5) [details]
License AGPL-3.0-only
Copyright Copyright (c) 2014 Bardur Arantsson
Author Bardur Arantsson
Maintainer spam@scientician.net
Category Database Testing Web
Uploaded by BardurArantsson at 2014-12-04T16:42:46Z

Downloads

Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees