3 ms·
How does it compare with using temporal tables in a relational database?
by _-david-_ 7y ago
How does it compare with using temporal tables in a relational database?
- cevian 7y agoWell as far as I understand, temporal tables usually have either a valid time or system time. TimescaleDB is geared towards something you'd call measurement time, and most modifications are inserts to recent measurement time. In contrast, temporal tables are often still update-heavy and there is often no correlation with recent time, especially for valid time fields.
- manigandham 7y agoTemporal table = state of the data in the table at a particular time. Very useful for auditing or seeing how data has changed between different periods. Timeseries = data with a primary key that includes time, potentially with other time properties. For example, metrics are commonly associated with a value at some time.