Change Listener

implproposal

Listens for incremental changes in a PostgreSQL database and triggers feature change actions.

Scope

This extension can be useful when the database is changed incrementally by other applications. When a change happens that is relevant for a feature type, registered actions will be triggered, for example to update the spatial extent or the feature count of an API.

You do not need this extension when changes are only made via CRUD or when a new iteration of the database is used after external updates.

Limitations

Only feature types from an SQL feature provider with dialect PGIS and without root concatenation are supported.

Configuration

Options

Name	Default	Description	Type	Since
type		Always FEATURE_CHANGES_PG.	string	v2.0
enabled	false	Enable the extension?	boolean	v2.0
listenForTypes	[]	List of types that should be observed. An empty list means all types.	array	v3.3
pollingInterval	60s	Since the JDBC driver for PostgreSQL does not support real reactivity, it has to be polled for changes with the given interval.	string	v3.3

Example

- type: FEATURE_CHANGES_PG
  enabled: true
  listenForTypes: # optional, default is to listen for all types
  - governmentalservice
  pollingInterval: 30s # optional, default is 60s