arkhipov/temporal_tables
Temporal Tables
Temporal Tables is a PostgreSQL database extension and trigger function library that implements system-versioned tables and database history tracking. It automates the maintenance of historical data archives by intercepting write operations to capture previous row versions when updates and deletions occur.
The extension manages record lifespans through transaction-time interval mapping, using paired timestamp columns to track active validity periods and relational schema linking to connect primary tables to their corresponding history archives. It includes concurrent conflict resolution mechanisms using row locking and serialization to prevent race conditions during simultaneous modifications, alongside session-level configuration variables for custom temporal overrides to backfill historical records.
Features
- Data Versioning - Implements system-versioned tables that record historical changes automatically over time.
- Data Auditing and Versioning - Tracks historical changes by automatically archiving old row versions into separate history tables.
- First-Write-Win Conflict Resolutions - Prevents race conditions during simultaneous modifications using row locking and serialization mechanisms.
- Row Version Archiving - Maintains automated archives of previous row versions to preserve historical data states.
- Database History Tracking Tools - Connects database tables to history archives using trigger functions to manage active lifespans and timestamps.
- Row-Level History Archives - Maintains a record of previous row versions in a separate history table whenever data is updated or deleted.
- Database Trigger Management - Connects database tables to history archives using trigger functions that manage timestamps and conflicts.
- Time Period Managements - Automatically generates and manages start and end timestamps for database records to reflect their active lifespan.
- Temporal Table Extensions - Provides a PostgreSQL database extension that automatically records historical changes and archives old row versions.
- Relational Schemas - Connects primary data tables directly to their corresponding historical archives using foreign key constraints.
- Temporal Data Management - Records the active lifespan of database records by automatically generating and managing valid start and end timestamps.
- Transaction-Time Interval Mappings - Tracks row validity periods using paired timestamp columns to maintain transaction-time intervals.
- Temporal Trigger Function Libraries - Provides database triggers that manage system valid periods and resolve concurrent transaction conflicts in PostgreSQL.
- State Auditing Triggers - Intercepts write operations automatically to capture previous row versions and append them to history tables.
- Parallel Data Backfilling - Overrides default transaction timestamps with custom temporal values to populate past records and data warehouses.
- Row Deletions - Automatically records table row validity periods and archives old data on updates and deletions.
- Custom System Time Overrides - Allows overriding default transaction timestamps with custom temporal values to backfill historical data.
- Temporal Configuration Overrides - Allows developers to supply custom timestamps via session configuration variables to backfill historical records.
Star history
How this analysis was created: This summary and feature list were written by an AI model that read the project's README and public documentation pages. Each feature links to the documentation it came from; stars, license and language come straight from the GitHub API. The model does not read the source code, and the analysis is refreshed when the project is re-analysed. Learn more on our About page.
