4 ms·
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
by bayesian_horse 4y ago
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 4y agoThat's a really interesting idea. Can you recommend any good references for bitemporality in graph dbs?
- bayesian_horse 4y agoTheres XTDB
- stevesimmons 4y agoThank you! XTDB Core2 looks very interesting. I've worked a lot with Arrow, which makes it extra appealing.
- bayesian_horse 4y agoI'm hesitant with databases like these because they are less battle-proven. I normally want my database to be as boring as possible.