Show HN: DriftDB – An experimental append-only database with time-travel queries

7 DavidCanHelp 3 9/14/2025, 7:42:52 PM github.com ↗

Comments (3)

esafak · 56s ago
Nice work! Did you really write 15K LOC here, or did you squash some commits? https://github.com/DavidLiedle/DriftDB/commit/a655f630dad22e...
twosdai · 2m ago
Really interesting! I used influxdb for a while. I see one of the core features is to have AS OF <some date time> be used for historical reference.

Is this similar to running an append only data structure in a normal tsdb, and then querying by date time and taking the most recent value in that data set? Or is it different.

withinboredom · 1m ago
Nice! I built one of these at a previous company for AI training. It’s nice to see an open source version. Did you look into any of the Temporal SQL papers by chance? There’s some nice syntax when you want to join across time.