Module db 

Database connection pool, schema migrations, and typed query modules.

This module manages the PostgreSQL connection pool via sqlx and provides the schema migration entry point. Submodules contain typed query functions for each table:

Module	Table	Purpose
reflectors	reflectors	Registry of discovered D-STAR reflectors.
activity	activity_log	Timestamped callsign observations.
connected_nodes	connected_nodes	Live snapshot of linked nodes per reflector.
streams	streams	Captured voice transmissions with audio.
uploads	streams	Upload queue lifecycle management.

The pool is shared across all tiers via sqlx::PgPool, which is cheaply cloneable (it wraps an Arc internally).

Modules

activity 🔒

Query functions for the activity_log table.

connected_nodes 🔒

Query functions for the connected_nodes table.

migrations 🔒

Embedded SQL schema migrations.

reflectors 🔒

Query functions for the reflectors table.

streams 🔒

Query functions for the streams table.

uploads 🔒

Query functions for the stream upload queue.

Functions

connect 🔒

Creates and returns a PostgreSQL connection pool.

migrate 🔒

Runs embedded database migrations.