meshcore-analyzer

dandri/meshcore-analyzer

Fork 0

mirror of https://github.com/Kpa-clawbot/meshcore-analyzer.git synced 2026-03-30 14:45:52 +00:00

Commit Graph

Author SHA1 Message Date

Author	SHA1	Message	Date
you	e340949253	feat: optimize observations table — 478MB → 141MB Schema v3 migration: - Replace observer_id TEXT (64-char hex) with observer_idx INTEGER FK - Drop redundant hash, observer_name, created_at columns - Store timestamp as epoch integer instead of ISO string - In-memory dedup Set replaces expensive unique index lookups - Auto-migration on startup with timestamped backup (never overwrites) - Detects already-migrated DBs via pragma user_version + column inspection Fixes: - disambiguateHops: restore 'known' field dropped during refactor (`fba5649`) - Skip MQTT connections when NODE_ENV=test - e2e test: encodeURIComponent for # channel hashes in URLs - VACUUM + TRUNCATE checkpoint after migration (not just VACUUM) - Daily TRUNCATE checkpoint at 2:00 AM UTC to reclaim WAL space Observability: - SQLite stats in /api/perf (DB size, WAL size, freelist, row counts, busy pages) - Rendered in perf dashboard with color-coded thresholds Tests: 839 pass (89 db + 30 migration + 70 helpers + 200 routes + 34 packet-store + 52 decoder + 255 decoder-spec + 62 filter + 47 e2e)	2026-03-25 22:33:39 +00:00
you	fba5649979	refactor: consolidate hop disambiguation — remove 3 duplicate implementations - server.js disambiguateHops() now delegates to server-helpers.js (was a full copy of the same algorithm, ~70 lines removed) - live.js resolveHopPositions() now delegates to shared HopResolver (was a standalone reimplementation, ~50 lines removed) - HopResolver.init() called when live page loads/updates node data - Net -106 lines, same behavior, single source of truth All unit tests pass (241). E2E 13/16 (3 pre-existing Chromium crashes).	2026-03-24 22:19:16 +00:00
you	21e7996c98	Extract server-helpers.js and add unit tests for server logic + db.js - Extract pure/near-pure functions from server.js into server-helpers.js: loadConfigFile, loadThemeFile, buildHealthConfig, getHealthMs, isHashSizeFlipFlop, computeContentHash, geoDist, deriveHashtagChannelKey, buildBreakdown, disambiguateHops, updateHashSizeForPacket, rebuildHashSizeMap, requireApiKey - Add test-server-helpers.js (70 tests) covering all extracted functions - Add test-db.js (68 tests) covering all db.js exports with temp SQLite DB - Coverage: 39.97% → 81.3% statements, 56% → 68.5% branches, 65.5% → 89.5% functions	2026-03-24 01:09:03 +00:00

you

e340949253

feat: optimize observations table — 478MB → 141MB

Schema v3 migration:
- Replace observer_id TEXT (64-char hex) with observer_idx INTEGER FK
- Drop redundant hash, observer_name, created_at columns
- Store timestamp as epoch integer instead of ISO string
- In-memory dedup Set replaces expensive unique index lookups
- Auto-migration on startup with timestamped backup (never overwrites)
- Detects already-migrated DBs via pragma user_version + column inspection

Fixes:
- disambiguateHops: restore 'known' field dropped during refactor (fba5649)
- Skip MQTT connections when NODE_ENV=test
- e2e test: encodeURIComponent for # channel hashes in URLs
- VACUUM + TRUNCATE checkpoint after migration (not just VACUUM)
- Daily TRUNCATE checkpoint at 2:00 AM UTC to reclaim WAL space

Observability:
- SQLite stats in /api/perf (DB size, WAL size, freelist, row counts, busy pages)
- Rendered in perf dashboard with color-coded thresholds

Tests: 839 pass (89 db + 30 migration + 70 helpers + 200 routes + 34 packet-store + 52 decoder + 255 decoder-spec + 62 filter + 47 e2e)

2026-03-25 22:33:39 +00:00

you

fba5649979

refactor: consolidate hop disambiguation — remove 3 duplicate implementations

- server.js disambiguateHops() now delegates to server-helpers.js
  (was a full copy of the same algorithm, ~70 lines removed)
- live.js resolveHopPositions() now delegates to shared HopResolver
  (was a standalone reimplementation, ~50 lines removed)
- HopResolver.init() called when live page loads/updates node data
- Net -106 lines, same behavior, single source of truth

All unit tests pass (241). E2E 13/16 (3 pre-existing Chromium crashes).

2026-03-24 22:19:16 +00:00

you

21e7996c98

Extract server-helpers.js and add unit tests for server logic + db.js

- Extract pure/near-pure functions from server.js into server-helpers.js:
  loadConfigFile, loadThemeFile, buildHealthConfig, getHealthMs,
  isHashSizeFlipFlop, computeContentHash, geoDist, deriveHashtagChannelKey,
  buildBreakdown, disambiguateHops, updateHashSizeForPacket, rebuildHashSizeMap,
  requireApiKey

- Add test-server-helpers.js (70 tests) covering all extracted functions
- Add test-db.js (68 tests) covering all db.js exports with temp SQLite DB
- Coverage: 39.97% → 81.3% statements, 56% → 68.5% branches, 65.5% → 89.5% functions

2026-03-24 01:09:03 +00:00

3 Commits