3 ms·
MSSQL comes with (very nice) temporal table support out of the box, if you can stomach the license fees.
by sparsely 5y ago
MSSQL comes with (very nice) temporal table support out of the box, if you can stomach the license fees.
- 5e92cb50239222b 5y agoMariaDB supports temporal tables, if you can stomach MySQL. Works fine in my experience, although the largest database I've used it with is no more than 30 GBs. https://mariadb.com/kb/en/system-versioned-tables/ https://mariadb.com/kb/en/system-versioned-tables/
- tluyben2 5y agoYes, I wondered why open source dbs don't have that out of the box (although it seems mysql has it in the other answer to you, so will check) as I use them extensively: both audit tables and temporal tables really make my work in banking far easier (and audit tables are often mandatory anyway). We use open source (both mysql and postgres) but I keep missing mssql features and have to replace them with adhoc stuff that often does not work on AWS Aurora as-is.