temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables.
Features
- Adds system-versioned tables to PostgreSQL
- Automatically logs row history on updates and deletes
- Supports time-travel queries with valid time ranges
- Uses native PostgreSQL features and triggers
- Simple installation and integration with existing schemas
- Useful for auditing, compliance, and data recovery
Categories
SQL ClientsLicense
MIT LicenseFollow Temporal Tables
Other Useful Business Software
Iris Powered By Generali - Iris puts your customer in control of their identity.
Iris Identity Protection API sends identity monitoring and alerts data into your existing digital environment – an ideal solution for businesses that are looking to offer their customers identity protection services without having to build a new product or app from scratch.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Temporal Tables!