arkhipov/temporal_tables

Health v2 · maintenance only

Adoption not part of the score

1048 stars · 52 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A PostgreSQL extension written in C that implements system-versioned temporal tables, automatically archiving old row versions into a history table on update or delete. It is distributed via PGXN and supports PostgreSQL 9.2 and higher.

Use cases

• track full change history of rows in postgres tables
• keep an audit trail of every update and delete in a database
• query what a record looked like at a past point in time
• implement system-versioned temporal tables in postgresql
• archive old row versions automatically into a history table
• store historical records with valid-time periods in sql

When to choose

• you need automatic, trigger-based row versioning with history tables in PostgreSQL
• you want a mature, battle-tested C extension rather than hand-written triggers
• you need to reconstruct historical row states for auditing or time-travel queries

When to avoid

• you need application-period (valid-time) temporal tables, which are not supported
• you are on PostgreSQL 13+ and prefer the built-in system-versioning or range types
• you use a database other than PostgreSQL

Facets

plugin · maturity stable

database databases developer-tools windows self-hosted postgresql-extension temporal-tables system-versioned-tables history-tables audit-history sql2011 pgxn c-extension linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="arkhipov/temporal_tables")