kianiadee/tracksolid_timescale_grafana_prod
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions 1

Commit graph

  • f94d14864f feat(trips): add --skip-geocode flag to backfill script quality-program-2026-04-12 David Kiania 2026-05-01 22:12:07 +0300
  • 144dedee90 feat(trips): [FIX-M20] enrich tracksolid.trips with coords, route polyline, addresses, plate David Kiania 2026-05-01 21:30:20 +0300
  • 898fd25a5a feat(analytics): Phase 0 — analytics-config migration and CSV importer rewrite David Kiania 2026-04-27 23:42:37 +0300
  • 5418fc48c5 fix(api): map new Mitieng CSV columns in tracksolid_update_v2 David Kiania 2026-04-27 23:42:20 +0300
  • dc6404a114 fix(grafana): raise geomap maxZoom from 12 to 22 for full-resolution drill-in main David Kiania 2026-04-27 18:32:14 +0300
  • 0b45f8d0f7 fix(grafana): raise geomap maxZoom from 12 to 22 for full-resolution drill-in David Kiania 2026-04-27 18:32:14 +0300
  • 03ceeb4d2d fix(grafana): tighten Active Vehicles map to Kenya, Uganda and Tanzania David Kiania 2026-04-27 18:31:01 +0300
  • bf17d5fa80 fix(grafana): tighten Active Vehicles map to Kenya, Uganda and Tanzania David Kiania 2026-04-27 18:31:01 +0300
  • d6fd8cf0cf fix(grafana): stop SI auto-scaling on km/hours stats; bound geomap to East Africa David Kiania 2026-04-27 17:25:58 +0300
  • 80c0e6510f fix(grafana): stop SI auto-scaling on km/hours stats; bound geomap to East Africa David Kiania 2026-04-27 17:25:58 +0300
  • 34f5fa1b9c feat(dwh): bronze pipeline migrations, runbook, and execution manual David Kiania 2026-04-25 01:07:53 +0300
  • 4b738fbcb7 Merge PR #11: backup TZ → Africa/Nairobi kianiadee 2026-04-24 08:31:24 +0000
  • 85cb408dea feat(backup): timestamp and schedule in Africa/Nairobi local time David Kiania 2026-04-24 11:30:20 +0300
  • f0de4057b3 Merge PR #10: persistence fix + multi-schedule backups kianiadee 2026-04-24 08:12:09 +0000
  • c585e67482 feat(backup): run pg_dump multiple times per day via BACKUP_TIMES_UTC David Kiania 2026-04-24 11:00:02 +0300
  • 3807d9554c fix(db): mount TimescaleDB HA volume at correct PGDATA path David Kiania 2026-04-24 10:59:53 +0300
  • fa110f4313 feat: [FIX-M19] multi-account ingest across fireside sub-accounts David Kiania 2026-04-24 10:43:07 +0300
  • 417627675e fix: [FIX-M18] pull driverName/vehicleNumber/sim from detail endpoint David Kiania 2026-04-22 18:21:25 +0300
  • 778686e7ce docs: CLAUDE.md audit — add backup sidecar, missing files, update open items David Kiania 2026-04-21 16:01:38 +0300
  • 108c1be057 feat: nightly pg_dump sidecar uploads to rustfs fleet-db bucket David Kiania 2026-04-21 12:53:23 +0300
  • e5c9d0f4c4 Merge pull request 'fix: auto-register devices + refresh CSV (140 new rows)' (#9) from quality-program-2026-04-12 into main kianiadee 2026-04-21 09:30:14 +0000
  • 257643cae2 fix: auto-register devices on push + allow CSV import to insert new rows David Kiania 2026-04-21 12:29:32 +0300
  • 6371967f8d Merge pull request 'fix: parse real Jimi push format (msgType+data)' (#8) from quality-program-2026-04-12 into main kianiadee 2026-04-21 09:10:21 +0000
  • 636dd2b8b0 fix: parse actual Jimi push format (msgType+data, field name remap) David Kiania 2026-04-21 12:10:08 +0300
  • f42eef6653 Merge pull request 'diag: log raw push body to identify Jimi format' (#7) from quality-program-2026-04-12 into main kianiadee 2026-04-21 09:05:09 +0000
  • c54794eb4c diag: log raw push body + content-type at INFO level David Kiania 2026-04-21 12:04:55 +0300
  • 809dbb165c Merge pull request 'fix: webhook handles JSON body push format from Jimi' (#6) from quality-program-2026-04-12 into main kianiadee 2026-04-21 08:57:04 +0000
  • ef36ebebea fix: handle JSON body push format from Jimi integration API David Kiania 2026-04-21 11:44:08 +0300
  • 5f24c158e2 Merge pull request #5: Daily Operations dashboard + tracksolid analytics views kianiadee 2026-04-19 10:47:52 +0000
  • 85d02c81a5 feat: Daily Operations dashboard + tracksolid analytics views David Kiania 2026-04-19 13:44:18 +0300
  • 8d1f40de1c Merge pull request 'quality-program: deploy-ready stack (Apr 2026)' (#4) from quality-program-2026-04-12 into main kianiadee 2026-04-18 21:30:06 +0000
  • 4371a0d6e6 docs: CLAUDE.md audit — add commands section, fix stale DB access note David Kiania 2026-04-19 00:27:59 +0300
  • 18e7e668c0 docs: fleet intelligence pitch deck copy and one-pager (25 slides + A4 leave-behind) David Kiania 2026-04-18 17:05:07 +0300
  • c6e4a227c8 docs: add blob storage and data warehouse as optional pitch products David Kiania 2026-04-18 17:00:39 +0300
  • 9f4406d863 docs: fleet intelligence partner pitch design (elicitation method) David Kiania 2026-04-18 16:41:04 +0300
  • f2222593a3 Merge pull request 'fix: DB port 5888→5433 (port conflict)' (#3) from quality-program-2026-04-12 into main kianiadee 2026-04-18 12:43:57 +0000
  • 152fce81a8 fix: point DATABASE_URL at timescale_db container (not legacy 31.97.44.246:5888) David Kiania 2026-04-18 15:43:49 +0300
  • 07ef491695 fix: change DB host port 5888→5433 (5888 already allocated by legacy DB) David Kiania 2026-04-18 14:19:20 +0300
  • 6b4e09670a Merge pull request 'docs: update CLAUDE.md with session learnings (18 Apr 2026)' (#2) from quality-program-2026-04-12 into main kianiadee 2026-04-18 11:14:40 +0000
  • 160f477318 infra: expose timescale_db port 5888 for direct pgcli access David Kiania 2026-04-18 14:14:32 +0300
  • 244112154a docs: update CLAUDE.md with session learnings (18 Apr 2026) David Kiania 2026-04-18 12:26:21 +0300
  • 5fa87a712e Merge pull request 'feat: business analytics expansion, driver CSV import, live DB state docs' (#1) from quality-program-2026-04-12 into main kianiadee 2026-04-18 06:04:10 +0000
  • 274473c544 docs: update analytics report with live DB state (18 Apr 2026) David Kiania 2026-04-18 08:39:58 +0300
  • cebcf74ba2 feat: business analytics expansion + driver CSV import David Kiania 2026-04-18 08:30:34 +0300
  • 8867be9d3d perf+fix: SAVEPOINT-per-item pollers, batched GPS inserts, parallel detail fetch David Kiania 2026-04-18 00:33:55 +0300
  • f7cc48cc6a chore: align .python-version to 3.12.0 (matches Docker image and pyproject.toml) David Kiania 2026-04-12 21:41:43 +0300
  • 20d3ddb841 feat: add db_audit health checks, runner, and scheduled Forgejo workflow David Kiania 2026-04-12 21:40:29 +0300
  • 6ed4d3a1e2 test: add test suite - unit tests, webhook endpoint tests, and CI workflow David Kiania 2026-04-12 21:38:20 +0300
  • 2ca3d2f021 ci: add ruff + mypy static analysis config and Forgejo workflow David Kiania 2026-04-12 21:32:33 +0300
  • 75d3417a2b docs: add quality program design spec David Kiania 2026-04-12 21:31:56 +0300
  • f9834564ab Add CLAUDE.md and project docs for structured Claude project David Kiania 2026-04-12 20:59:15 +0300
  • 2131faf8c6 Add 260412 baseline report — first trip data, FIX-M16 confirmed David Kiania 2026-04-12 00:14:27 +0300
  • 6a0ceb78dd Fix trip distance unit (metres→km) and full device sync on upsert David Kiania 2026-04-12 00:06:57 +0300
  • fcc745f09d Fix Grafana provisioning: bake datasource/dashboard config into custom image David Kiania 2026-04-11 22:18:44 +0300
  • d706d17cc8 Fix Grafana datasource: add GRAFANA_DB_RO_PASSWORD and sync grafana_ro on startup David Kiania 2026-04-11 19:22:30 +0300
  • 87ecab4a72 Wire /pushevent to device_events table (was log-only) David Kiania 2026-04-11 18:42:22 +0300
  • b1e4d6e85f Fix 5 webhook bugs: SAVEPOINTs, NULL guards, BCD timestamps, /pushevent, log NULL fix David Kiania 2026-04-11 18:19:13 +0300
  • 1f11a65b0b Add 02_tracksolid_docker_commands.md — remote DB command reference David Kiania 2026-04-11 08:23:01 +0300
  • ae5bd2c960 Update tracksolidApiDocumentation.md with live implementation findings David Kiania 2026-04-11 07:52:28 +0300
  • d7ffa136a3 Regenerate 260410_baseline_report.md from live database (post-migration) David Kiania 2026-04-11 07:42:33 +0300
  • f277532a9d Regenerate 260410_baseline_report.md with post-migration comprehensive data David Kiania 2026-04-11 07:29:49 +0300
  • 5f1b32f1dc Extend seed sentinels to cover migrations 04 and 05 David Kiania 2026-04-10 23:48:30 +0300
  • 5d47eece6b Fix: seed pre-tracking migrations to skip already-applied 02 and 03 David Kiania 2026-04-10 23:43:44 +0300
  • 63e555b822 Fix: create tracksolid schema before schema_migrations table David Kiania 2026-04-10 23:40:32 +0300
  • aa290151ea Update run_migrations.py: add 04+05, idempotency tracking, expanded verify David Kiania 2026-04-10 23:34:57 +0300
  • 20a98074a6 Add idempotent migration runner script David Kiania 2026-04-10 23:31:57 +0300
  • 97b19eb968 Add 2026-04-10 baseline fleet report from live database query David Kiania 2026-04-10 23:20:16 +0300
  • 40e452e156 Replace hardcoded container names with dynamic lookup David Kiania 2026-04-10 23:09:01 +0300
  • 09b3860706 Add fleet business analytics document David Kiania 2026-04-10 22:57:36 +0300
  • 3797a4e2ca Implement POLL-01 high-res GPS trails and POLL-03 on-demand location refresh David Kiania 2026-04-10 22:46:00 +0300
  • d534aceadc Add DB connection string to ops manual, add administration notes, remove stale deploy guide David Kiania 2026-04-10 22:34:56 +0300
  • 05993100e9 Enhance tracksolid_DB_manual.md with full analytics suite David Kiania 2026-04-10 22:33:06 +0300
  • c05b47abe2 Fix alarm field mapping, distance unit bug, parking params; add schema migrations David Kiania 2026-04-10 22:18:30 +0300
  • 791bf2700c Add Ubuntu instance deployment guide David Kiania 2026-04-09 16:40:05 +0300
  • 82761e1e3f Add Grafana NOC operational manual David Kiania 2026-04-09 00:12:48 +0300
  • cd6b2ca81a Add Grafana NOC fleet dashboard with provisioning David Kiania 2026-04-09 00:01:52 +0300
  • 2f3879aa2a Add n8n workflow templates and change webhook port to 8888 David Kiania 2026-04-08 18:54:42 +0300
  • 004fed7ab9 Add operations manual with verification queries per service David Kiania 2026-04-08 17:59:05 +0300
  • e1402f6af1 Fix NoneType crash: API returns null result instead of missing key David Kiania 2026-04-08 17:27:48 +0300
  • 326764e1a0 Fix migration failures: switch to full TimescaleDB + use psql runner David Kiania 2026-04-08 17:17:58 +0300
  • 3bbf3b777d Run migrations inline at each service startup instead of init service David Kiania 2026-04-08 17:11:12 +0300
  • 4a31de30b1 Add db_migrate init service to auto-run SQL schema on deploy David Kiania 2026-04-08 17:02:09 +0300
  • b59616c7aa Remove webhook_receiver host port binding (Coolify proxy handles routing) David Kiania 2026-04-08 16:49:52 +0300
  • 2fbd286d29 Fix timescale_db: remove empty ports key causing Coolify deploy failure David Kiania 2026-04-08 16:42:20 +0300
  • 77bc3a9eca Remove .DS_Store from tracking (now in .gitignore) David Kiania 2026-04-08 16:31:12 +0300
  • de70972d6a Add webhook receiver, consolidate shared utilities, expand telemetry coverage David Kiania 2026-04-08 16:28:45 +0300
  • 85b50db71a Update docker-compose.yaml kianiadee 2026-04-07 21:53:11 +0000
  • bdd26472e7 Update docker-compose.yaml kianiadee 2026-04-07 20:00:16 +0000
  • 6205c483ee Deploy v2.0 Production Telemetry Stack David Kiania 2026-04-07 21:34:40 +0300
  • 0ce5d521db first commit David Kiania 2026-04-07 20:41:16 +0300