[bayesian_horse]

Always bet on PostgreSQL!

I hope AGE matures a bit in the future. There are lots of use cases for Graph Databases. One I'm interested in is bitemporality. It's easy to use ltree or CTE for tree-like structures. But what if you want to move nodes in the graph at certain times? Like a device being scheduled to be in different rooms across time. And also the history of those schedules. In a graph database you can label edges with temporal attributes and then query for a view of the graph at a certain point in time and in a certain history state by filtering the edges.

[stevesimmons]

That's a really interesting idea.

Can you recommend any good references for bitemporality in graph dbs?

[bayesian_horse]

Theres XTDB

[stevesimmons]

Thank you!

XTDB Core2 looks very interesting. I've worked a lot with Arrow, which makes it extra appealing.

[bayesian_horse]

I'm hesitant with databases like these because they are less battle-proven. I normally want my database to be as boring as possible.