Want to see what a row looked like yesterday? MariaDB’s system‑versioned tables keep every change automatically. This post walks through how they work, a point‑in‑time query example, the unbounded‑history trade‑off, and how to prune history with partitions.

Community & Careers · Blog

system-versioned-tables temporal-data

mariadb

Community & Careers

Article0 replies880 followingPosted 12 Sept 2026, 20:37 UTC61.7K views1,427 votes

Stop Writing Audit Triggers: MariaDB System-Versioned Tables Do It for You

MariaDB's system-versioned tables automatically capture every UPDATE and DELETE, letting you query any row as it existed at a past timestamp — no audit triggers or soft-delete logic required.

Community & Careers · Blog

system-versioned-tables auditing temporal-data

Community & Careers

Article0 replies3,381 followingPosted 03 Oct 2026, 04:45 UTC108.1K views895 votes

MariaDB System-Versioned Tables: Automatic Row History Without Triggers

MariaDB 10.3+ system-versioned tables preserve every row version automatically. Learn the WITH SYSTEM VERSIONING syntax, FOR SYSTEM_TIME queries, history partitioning, and storage pitfalls.

Community & Careers · Guide

system-versioned-tables temporal-tables audit-logging