F34.us
Menu
ACTIVEPROJECT 12

SYSTEMS ENGINEERING RECORD

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 ·

TimeTrackDB: A Reversible Event Refinery IMAGETimeTrackDB: A Reversible Event Refinery

PROJECT README

README

TimeTrackDB turns exported time and event data into an auditable pipeline instead of a pile of mutable CSV files.

Immutable Bronze metadata records every source load, generic Silver tables publish current truth with history, and serving views expose stable data for applications and analysis. Adapter-owned schemas, quarantine paths, migrations, and rollback tooling let the system evolve beyond time tracking without sacrificing provenance.

SYSTEM DOSSIER

Project signals

5 ITEMS · 2 CONNECTIONS

ARTICLE

TimeTrackDB: A Local-First Warehouse for Events That Change

An overview of Bronze and Silver storage, configuration-driven adapters, quarantine, auditing, and rollback.

FORGEJO / 26 WEEK ACTIVITY

TimeTrackDB repository

77 commits across 33 active days, 2026-05-11 through 2026-11-08 UTC.

Project pulse

Latest activity

  1. F34 Quarantine Before Trust
  2. F34 Why a Day Is the Unit of Truth

WAKE / Recent activity

TimeTrackDB work log

  1. Completed
    Completed empty-snapshot rollback history support.

    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.

  2. Completed
    Fixed timetrackdb #21: preserve BrowserConfigurationError during CommandServer initialization.

    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 rere…

  3. Completed
    Fixed timetrackdb issue #22 semantic validation gap

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

Explore project progress in Wake

FORGEJO / REPOSITORY PULSE

TimeTrackDB repository

Commits
143
Files
154
Code bytes
720,479
Branches
22
Issues
6 open / 25 closed
Python
99.3%
Shell
0.5%
Dockerfile
0.3%

PROJECT TIMELINE

Activity

View all 5

The current overview mosaic features this collection’s latest evidence.

TECHNICAL RECORD

Documentation

View all 2

Article · Friday 28th of August, year 2026

Adapters as Contracts, Not Escape Hatches

Architecture deep dive

A second event domain proves that extensibility can add meaning without weakening lineage or validation.

Open record

VISUAL AND AUDIO RECORD

Media

View all 1

The current overview mosaic features this collection’s latest evidence.

COMPLETE PROJECT INDEX

All material

View all 5

Article · Friday 28th of August, year 2026

Adapters as Contracts, Not Escape Hatches

Architecture deep dive

A second event domain proves that extensibility can add meaning without weakening lineage or validation.

Open record
F34.us Background Image