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

Commit graph

  • 621a30cd81 fix(dashboard_api): jsonable_encoder on /health/ingest (datetime serialize) feat/staging-fleetops-architecture david kiania 2026-07-02 23:57:32 +0300
  • b11294009b fix(security,ingest): 260702 audit — secure the stack, correct poller counters david kiania 2026-07-02 09:51:02 +0300
  • 03c66fbd17 feat(dashboard_api): CRQ tab routes (crq-dashboard/search/filter-options) david kiania 2026-06-26 00:20:10 +0300
  • 458e0be101 feat(tools): import_drivers_csv reads raw Tracksolid Pro export format david kiania 2026-06-25 14:52:11 +0300
  • 048d1a3173 feat(dashboard_api): GET /webhook/inc-filter-options (explorer pulldowns) david kiania 2026-06-19 12:34:46 +0300
  • e27933b1cb feat(dashboard_api): GET /webhook/inc-search route (ticket explorer) david kiania 2026-06-19 11:48:42 +0300
  • 1d4bd6000e feat(dashboard_api): wire GET /webhook/inc-dashboard route david kiania 2026-06-18 15:06:52 +0300
  • 024b698bca fix(api): support generic Nd period presets (90d, 365d, …) kianiadee 2026-06-12 00:19:06 +0300
  • c42a500d4b feat(api): add /analytics/fuel-fills endpoints for the FleetOps Fuel Log kianiadee 2026-06-12 00:01:36 +0300
  • 868960c39c chore(tickets): hand the tickets schema + ingest to the fleettickets repo david kiania 2026-06-11 20:15:23 +0300
  • cae64167eb feat(tickets): INC/CRQ tickets schema, geocoding + read-API david kiania 2026-06-11 17:30:22 +0300
  • f1c231a737 fix(reporting): restore live-feed cost-centre exclusion + vehicle_type (migration 20) david kiania 2026-06-10 22:36:45 +0300
  • d5093f0a1c chore(cleanup): purge n8n, Grafana, and DWH references + dead artifacts david kiania 2026-06-10 21:41:27 +0300
  • 76f6915e61 feat(stack): consolidate 7→4 services (merge pollers, drop pgbouncer/grafana) david kiania 2026-06-10 21:41:05 +0300
  • 2f6ab1ba3b docs: mark stage-2 (prod reads via dashboard_ro) done david kiania 2026-06-10 20:21:51 +0300
  • aea226cc74 feat(db): split refresher onto REFRESH_DATABASE_URL; prod reads via dashboard_ro david kiania 2026-06-10 20:19:40 +0300
  • 54a714e0cd docs: finalize staging+FleetOps as-built; phase closed david kiania 2026-06-10 20:10:14 +0300
  • 2603f0e726 docs: dashboard_ro role + two-stage rollout; mark Phase 1 done david kiania 2026-06-10 12:37:09 +0300
  • cbbe3dab87 feat(db): dedicated read-only dashboard_ro role + repoint staging david kiania 2026-06-10 12:33:53 +0300
  • 8ddbd7b745 feat(db): grant grafana_ro read access to reporting.* (Phase 0 role) david kiania 2026-06-10 12:24:55 +0300
  • 478fb0e707 feat(infra): staging dashboard_api deploy script (Phase 1) david kiania 2026-06-10 12:19:17 +0300
  • 6cf0905b31 feat(dashboard_api): FleetOps analytics endpoints + fuel view (Phase 3) david kiania 2026-06-10 12:12:00 +0300
  • e01b50a8b1 docs: staging environment + FleetOps split architecture david kiania 2026-06-10 12:05:29 +0300
  • 3015104f5b docs+tooling: OSM POI export workflow + Shell stations data; graded DQ report main david kiania 2026-06-08 22:04:49 +0300
  • 376965e978 Merge PR #16: map read-API, reporting schema, fleet segmentation + FleetNow data plumbing david kiania 2026-06-08 15:55:19 +0300
  • 4b77d20966 Merge origin/main into feat/dashboard-read-api feat/dashboard-read-api david kiania 2026-06-08 15:55:17 +0300
  • f53298590e Merge branch 'main' into feat/dashboard-read-api david kiania 2026-06-08 15:46:07 +0300
  • 45d764a5f1 docs: add FleetNow stakeholder briefings (directors + heads of department) david kiania 2026-06-08 15:42:37 +0300
  • a8e1327aa8 feat(reporting): add vehicle_type + fleet_segment to live map feed (migration 16) david kiania 2026-06-08 14:33:21 +0300
  • 0c32094347 feat(reporting): exclude non-operational vehicles from the live map (migration 15) david kiania 2026-06-08 14:18:30 +0300
  • 347c97ec4c feat(reporting): fleet segmentation + deduped vehicle roster (migration 14) david kiania 2026-06-08 13:54:47 +0300
  • 94cbd2a85e docs: document FleetNow merged dashboard + read-API topology + FIX-D03 kianiadee 2026-06-06 10:09:48 +0300
  • d95e5c2dbd config(cors): allow fleetnow.rahamafresh.com origin on dashboard_api kianiadee 2026-06-06 10:07:46 +0300
  • 9986d3b411 docs(claude): add pending Grafana redeploy to open items (post ops/dwh_gold purge) david kiania 2026-06-05 20:39:56 +0300
  • 8c5a43f3b8 chore(db): purge unused ops + dwh_gold schemas david kiania 2026-06-05 18:11:03 +0300
  • e060933c55 docs: record fleet-dashboard filter fix + v_trips self-refresh david kiania 2026-06-05 16:58:20 +0300
  • 30b351576c feat(api): self-refresh reporting.v_trips in dashboard_api david kiania 2026-06-05 16:25:45 +0300
  • f1387d1476 fix(api): parse form-urlencoded POST body in fleet-dashboard handler david kiania 2026-06-05 13:23:10 +0300
  • 26fa1a4dc5 docs: add Grafana dashboards appendix + link PLATFORM_OVERVIEW from CLAUDE.md david kiania 2026-06-05 12:50:48 +0300
  • 83a2d06148 docs: add PLATFORM_OVERVIEW.html — current-state platform reference david kiania 2026-06-05 12:47:18 +0300
  • 00e81a063b feat(db): capture reporting.* map-dashboard schema as migration 11 david kiania 2026-06-05 12:32:44 +0300
  • 831f683b83 fix(api): expose /webhook/live-positions/track so map trail matches SPA path david kiania 2026-06-05 00:54:58 +0300
  • 5703d70aa6 feat(api): dedicated FastAPI read-API for map dashboards (replaces n8n) david kiania 2026-06-01 04:23:37 +0300
  • e5b0e192d8 chore(repo): reorganize tree into migrations/ data/ legacy/ docs/ david kiania 2026-06-01 02:27:30 +0300
  • 2309464ab8 FIX-M21: alarm cross-feed + stale-IMEI recovery for live_positions quality-program-2026-04-12 david kiania 2026-05-21 21:05:26 +0300
  • cbae345d43 Merge PR #15: FIX-M20 alarm cross-feed + stale-IMEI recovery kianiadee 2026-05-21 18:43:08 +0000
  • c8f5907d4f FIX-M20: alarm cross-feed + stale-IMEI recovery for live_positions 260521-location-freshness-upgrade david kiania 2026-05-21 21:05:26 +0300
  • 7bc0a2ce87 fix(BUG-01b): aggregate trips and alarms in separate CTEs to avoid cartesian explosion fix/bugs-01-02-03 david kiania 2026-05-15 16:44:40 +0300
  • d66c3bab42 fix: BUG-06..11 — pool lock, clean_int rounding, date-only tz, _infer_city, rowcount naming, double commit fix/bugs-06-to-11 david kiania 2026-05-15 15:49:54 +0300
  • 378682bd57 fix: BUG-04 honour JSON Content-Type in webhook _parse_request, BUG-05 guard obdJson list fix/bugs-04-05 david kiania 2026-05-15 15:42:17 +0300
  • 8d386bf27a fix: BUG-01 ETL type crash, BUG-02 multi-account audit, BUG-03 diagnostic david kiania 2026-05-15 15:34:43 +0300
  • 3b79d5a62e revert(infra): remove pgAdmin4 sidecar and configs David Kiania 2026-05-08 00:34:10 +0300
  • bc020cb1a8 feat(infra): add pgAdmin4 web sidecar pointed at pgbouncer David Kiania 2026-05-07 14:03:32 +0300
  • f3ad612a1c fix(infra): drop pgbouncer image tag — pin 1.23.1 unavailable David Kiania 2026-05-07 13:48:31 +0300
  • e811dd8f34 feat(infra): add pgbouncer sidecar to cap tracksolid_db connections David Kiania 2026-05-07 13:21:35 +0300
  • 737ca67712 feat(analytics): add v_driver_clock_daily/today views for tardiness monitoring David Kiania 2026-05-04 14:03:40 +0300
  • f94d14864f feat(trips): add --skip-geocode flag to backfill script 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 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