F34.us Content Aggregator Prototype
ACTIVEPROJECT 12

SYSTEMS ENGINEERING RECORD

TimeTrackDB

A local-first PostgreSQL and TimescaleDB event warehouse with immutable ingestion, versioned current truth, and safe rollback.

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

40 commits across 17 active days, 2026-03-09 through 2026-09-06 UTC.

WAKE / SIGNAL

TimeTrackDB work log

  1. WORK COMPLETEDFixed timetrackdb #21: preserve BrowserConfigurationError during CommandServer initialization.
  2. WORK COMPLETEDFixed timetrackdb issue #22 semantic validation gap

FORGEJO / REPOSITORY PULSE

TimeTrackDB repository

Commits
106
Files
115
Code bytes
560,748
Branches
7
Issues
8 open / 14 closed
Python
99.1%
Shell
0.6%
Dockerfile
0.3%

ARTICLE

Why a Day Is the Unit of Truth

A deep dive into fingerprints, logical-day replacement, temporal history, and dataset-aware rollback.

ARTICLE

Quarantine Before Trust

Local ownership becomes dependable history only when every source transition is measured, contained, and auditable.

ARTICLE

Adapters as Contracts, Not Escape Hatches

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

PROJECT TIMELINE

Activity

View all 4

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

TECHNICAL RECORD

Documentation

View all 2

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

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

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

F34.us Background Image