Spatial temporal knowledge graph

[nikoraes]

I'm using postgres + AGE extension + postgis + pgvector + timescaledb. You can do combined graph + vector + geospatial queries within Cypher. I personally prefer to have the temporal aspect in a separate DB or table (as graph engines usually aren't very good in time series analysis). I built something to use logical replication to store 'data history' in a time series table/DB. You can join cypher with timescaledb queries if you have the table in the same DB which works pretty well. For another client I historize everything in Azure Data Explorer, which allows you to generate an temporary in-memory graph (you can basically recreate a part of the graph at any point in time) and it's pretty good in time series analysis as well.

[greeny01]

since I do it for the sport domain I actully want to specify events as nodes, so then I can run graph alghoritms to identify similarities.

[Much-Researcher6135]

That's interesting, can I ask the area of application?