Company
Date Published
Author
Daniel Abadi, Matt Freels
Word count
1082
Language
English
Hacker News points
None

Summary

### Temporality in Databases Temporal databases track every change to business data within a retention period, whereas time-series databases record sampled numeric data ordered by time. Fauna is a temporal database that supports configurable retention policies and allows transactions to be executed at any point in the past or transformed into a change feed of events between two points in time. This enables features like auditing business transactions, undoing mistakes, syncing partially-connected clients, and constructing activity feeds. Temporal databases are vastly more powerful and general-purpose than time-series databases, offering capabilities like rollup aggregations and exposing minimal history. Fauna integrates temporality with the full power of its query engine, enabling advanced use cases like change feeds and journal views.