Expand description
Query functions for the activity_log table.
The activity log records timestamped observations of callsign activity on reflector modules. Each row represents one callsign heard at a specific instant, tagged with the data source that reported it.
Sources include:
"xlx_monitor"โ Tier 2 XLX UDP JSON monitor real-time events."ircddb"โ Tier 1 ircDDB last-heard page scrapes."pistar"โ Tier 1 Pi-Star host file activity hints.
The table is append-only by design. Old rows are not updated; queries filter
by observed_at to select recent activity windows.
Structsยง
- Activity
Row ๐ - A single row from the
activity_logtable.
Functionsยง
- get_
for_ ๐reflector - Returns activity for a specific reflector since the given timestamp.
- get_
recent ๐ - Returns recent activity across all reflectors since the given timestamp.
- insert_
observation ๐ - Inserts a single activity observation.