4 ms·

Imagine if SQL databases had reflog.

• tremon 6y ago
  https://en.wikipedia.org/wiki/Temporal_database https://en.wikipedia.org/wiki/Temporal_database
  • yencabulator 6y ago
    You're still imagining a centralized solution with a single source of truth and less power than Git. Git history is a directed acyclic graph, not a single linear timeline.
    • refset 6y ago
      "less power" definitely depends on what you value when comparing Git against real databases, e.g. https://stackoverflow.com/questions/984707/what-are-the-file-limits-in-git-number-and-size https://stackoverflow.com/questions/984707/what-are-the-file... There is at least one database that exists which does support a Git-like DAG for transaction-time temporality: https://terminusdb.com/ https://terminusdb.com/ It should also be pointed out that "temporal databases" usually offer a lot more besides a linear transaction-time history. Although I've not seen anything that offers a DAG for valid-time histories yet :)