4 ms·
Apologies for kind-of sidetracking, but I went back and read the blog post about Cozo’s time travel feature and wanted to add this approach: since relationships
by joshspankit 4y ago
Apologies for kind-of sidetracking, but I went back and read the blog post about Cozo’s time travel feature and wanted to add this approach: since relationships are cheap, you can have a “current status” relationship and multiple “past and current status” relationships. When the user updates their status it replaces the “current status” while also adding itself as a “past and current status”.
That way querying for the current status is a 1:1 graph lookup and you can reserve timestamp lookups for querying past statuses.