Module activity

Module activity 

Source
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ยง

ActivityRow ๐Ÿ”’
A single row from the activity_log table.

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.