Databases

SQLite (in ~) — all four are stale

FileTablesLast modifiedKnown writer
deals.dbdeals2026-09-26not identified; read by sync_deals_to_postgres.py
cars.dbcars2026-09-26not identified; read by sync_deals_to_postgres.py
recon.dbsubdomains2026-09-26not identified
hunting_grid.dbflight_volume, vessel_volume, spike_alerts2026-10-17volume_telemetry/telemetry_common.py (path ~/hunting_grid.db); all three tables have 0 rows

Postgres (hermes-postgres, Docker stack)

pipeline_runner.py, govdeals_sniper.py, car_sniper_pipeline.py and recon_engine.py all use psycopg2, so the live Snipers (deals, cars, recon) data goes to Postgres. deals-sync.service (every 10 min) copies deals.db and cars.db into Postgres.

Memory export: mnemosyne_export_2026-09-07.json. See Volume telemetry.

Postgres schemas

Linked from: Docker stack, Home, MetLife DUI attorney vetting, SATNA Cyber Command Center, Snipers (deals, cars, recon), Volume telemetry