Hacker News new | ask | show | jobs
by ExpiredLink 4627 days ago
Temporal databases and immutability are independent concepts. A 'time series database' only solves the simple temporal database problems. When validity comes into play things become really hard (something was entered yesterday but will be valid from tomorrow).
1 comments

Temporal databases rely on the immutability of each record (whether by convention or as a system guarantee). Changes are no longer expressed with updates on a given row; instead you add new rows to represent the change.
> Temporal databases rely on the immutability of each record

Some maybe, certainly not all! What you mean are 'historical' databases, a.k.a. time series.