Postgres KeyValueStore implementation via JDBC

Description

It would be nice to have a JDBC based implementation of the KeyValueStore API for use with Postgres. An immediate use case would be for thresholding in non-distributed installations where access to Cassandra is not an option. This would allow thresholding on OpenNMS to be able to persist state and resume where it left off after a restart.

 

Currently there is a NOOP implementation of the KeyValueStore for non-distributed installs, with this new implementation we could replace that as the default to use Postgres.

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Matthew Brooks August 21, 2019 at 8:44 PM

Matthew Brooks August 7, 2019 at 3:03 PM

Note: this issue pertains specifically to the BlobStore variant of the key value store. Having a Postgres implementation of this would be beneficial on OpenNMS for thresholding state.

Matthew Brooks August 7, 2019 at 3:02 PM

Leveraging the work from https://github.com/OpenNMS/opennms/pull/2614 should make this fairly trivial.

Fixed

Details

Assignee

Reporter

Sprint

Fix versions

Priority

PagerDuty

Created July 22, 2019 at 6:55 PM
Updated August 27, 2019 at 1:26 PM
Resolved August 27, 2019 at 1:26 PM