Ask HN: What do you know about bitemporal databases?
Best to use a database with native bi-temporal support, a query planner can get very confused about tables with bi-temporal columns and few constraints, to the extent that it always fails to push the temporal conditions up through the joins resulting in massive unnecessary materialization.<p>Also - start thinking about archiving now - n lg n is fast at the start - two years later, not so much.<p>Good luck