3 ms·
Ah, sounds like you are again thinking about bitemporal reasoning over relational data. We are not really built for that use case. Instead of focusing on fund
by cevian 10y ago
Ah, sounds like you are again thinking about bitemporal reasoning over relational data.
We are not really built for that use case. Instead of focusing on fundamentally relational data such as people or jobs (which you are free to store alongside our stuff, using plain postgres functionality), we store event or metrics data. This data can be easily joined against the relational data (e.g., using a person_id stored in both event and relational tables).
- nickpeterson 10y agoI reread 'managing time in relational databases' like 3 times one summer and now every time I mess with time in databases I have a heart attack. That makes sense, thanks for answering ;)