Managing Time in Relational DatabasesTom Johnston, Randall Weis
Managing Time in Relational Databases
by Tom Johnston, Randall Weis · first published 2010
4mentions
2recommended by
4HN commenters
2017–2021first – last mentioned
50% recommend50% neutral
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
There are a couple of good books on bitemporality, Richard Snodgrass' "Developing time-oriented database applications in SQL" is pretty much the bible on the subject and goes into great detail. "Managing Time in Relational Databases" by Tom Johnston and Randall Weis is another great book, a little more hands on with the code. I'd love to see someone translate the concepts in both books to a useful postgres package. As Snodgrass…
on “The Value of Bitemporality – Whose Time Is It Anyway?” ↗Good recommendation; I also got a lot of mileage out of: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data How to Design, Update and Query Temporal Data > be careful if you tend to over-engineer or are perfectionist One of the downsides of these books is that…
on “Postgres audit tables saved us from taking down production” ↗…Applications in SQL. Hugh Darwen & C.J. Date, "An Overview and Analysis of Proposals Based on the TSQL2 Approach". Krishna Kulkarni & Jan-Eike Michels, "Temporal features in SQL:2011". Tom Johnston, Managing Time in Relational Databases. (I haven't read this one yet.) Tom Johnston, Bitemporal Data. Magnus Hagander, "A TARDIS for Your ORM": https://www.youtube.com/watch?v=TRgni5q0YM8 Also I've yet to see anyone even talk about managing…
on “Datomic: this is not the history you're looking for” ↗I 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 ;)
on “Building a scalable time-series database on PostgreSQL” ↗