Databases
SQLite (in ~) — all four are stale
| File | Tables | Last modified | Known writer |
|---|
| deals.db | deals | 2026-09-26 | not identified; read by sync_deals_to_postgres.py |
| cars.db | cars | 2026-09-26 | not identified; read by sync_deals_to_postgres.py |
| recon.db | subdomains | 2026-09-26 | not identified |
| hunting_grid.db | flight_volume, vessel_volume, spike_alerts | 2026-10-17 | volume_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