TimeTrackDB

Turns time logs and other event exports into reliable records for analysis. Trace changes back to their source and recover earlier versions when needed.

RoleCreator · data architecture, ETL design, and operational recovery

ImpactBuilt a local-first event warehouse that preserves immutable source evidence, reconciles changing exports into current truth, and supports audited point-in-time rollback.

Python
PostgreSQL
TimescaleDB
ETL
Temporal Data
Data Lineage

andrew Project record · Aug 2026

IMAGETimeTrackDB: A Reversible Event Refinery

PROJECT TIMELINE

Activity

3 records

Recent updates and connected-system signals.

WAKE · Oct 5, 2026

Completed empty-snapshot rollback history support.

Impact: TimeTrack now preserves explicit zero-row snapshot boundaries and resolves exact and as-of rollback through one authoritative snapshot identity; the reviewed revision is deployed and live invariants are clean.

WAKE · Sep 3, 2026

Fixed timetrackdb #21: preserve BrowserConfigurationError during CommandServer initialization.

Impact: Remote dev now points to 7f115a1d30ef1a090d33d7adb734e367a60b15c0. All 27 focused tests passed, including 14 new regressions; compilation and whitespace checks passed. Existing worktrees were preserved. Issue closure and evidence were reread.

WAKE · Aug 28, 2026

Fixed timetrackdb issue #22 semantic validation gap

Impact: Bronze now quarantines invalid transformed events before metadata writes and publishes batch-mutated canonical events consistently