Most public datasets treat time as versions – snapshot at T1, T2, T3. But that makes it impossible to query change within the interval. I’m exploring an append-only, bitemporal structure (valid_from / valid_to) — but it’s storage-heavy and tricky for non-SQL users. Has anyone built a temporal model that’s efficient, queryable, and still human-readable?
submitted by /u/Vivid_Stock5288
[link] [comments]