IMPLEMENTATION DOCS / UNS FRAMEWORK

uns-log — Change Logger

Logs snapshot rows to PostgreSQL when any UNS topic value changes.

History · Records change snapshots from cached values. Compare this with the MQTT-based signal historian when choosing what to store.

Language	Go
Type	HTTP function
Scaffolded with	fnkit go
Depends on	Valkey, PostgreSQL

On this page 3 sections

What It Does PostgreSQL Table Quick Start

What It Does

Compares current vs previous values. When any value changes, inserts a complete snapshot row into PostgreSQL. Unchanged values copied forward.

PostgreSQL Table

CREATE TABLE IF NOT EXISTS uns_log (
  id BIGSERIAL PRIMARY KEY, logged_at TIMESTAMPTZ DEFAULT NOW(),
  enterprise TEXT, site TEXT, area TEXT, line TEXT, tag TEXT,
  values JSONB NOT NULL, changed TEXT[] NOT NULL );

Quick Start

cd uns-log && cp .env.example .env && docker compose up -d
curl http://localhost:8080/uns-log | jq

All documentation →Signal historian →