temporal_tables ☆
« Back to VersTracker
Description:
Temporal Tables PostgreSQL Extension
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql extension auditing versioning history
Install: brew install temporal_tables
About:
The Temporal Tables extension for PostgreSQL enables the tracking of full history of row changes. It automatically manages versioned rows in a separate history table, allowing users to query data as it appeared at any point in time. This provides built-in audit trails and simplifies point-in-time recovery without complex application logic.
Key Features:
  • Automatic history tracking of row changes
  • Preserves original table schema and query interface
  • Efficient time-travel queries using system time periods
  • Minimal performance overhead on standard operations
Use Cases:
  • Regulatory compliance and data auditing
  • Point-in-time data recovery and analysis
  • Debugging data issues by reviewing historical changes
Alternatives:
  • pg_audit – Focuses on detailed session and/or object audit logging rather than full data versioning
  • Manual Triggers – Requires custom coding to achieve similar history tracking, which is more error-prone and harder to maintain
Version History
Detected Version Rev Change Commit
Sep 26, 2025 1:15pm 1 VERSION_BUMP 2f3f5f4d
Sep 15, 2025 9:04pm 1 VERSION_BUMP 6c42014d
Sep 27, 2024 8:03pm 1 VERSION_BUMP 8e0ffbbb
Sep 12, 2024 11:25pm 1 VERSION_BUMP 00fbdb97
« Back to VersTracker  |  Browse Packages  |  About