Does this make any sense in single-player games, where the db would run locally on the user's machine? Does it have any benefit to run all game state through a local db? I'm not a game dev, but I'm imagining that if I'd write a custom game engine, I'd have to write just the "frontend" aka. graphics engine if I'd have a robust state manager (+tooling) as a separate piece of software.
Some algorithms are much more easily represented as SQL or that plus a little wrapper code. E.g., somebody re-wrote E-Graphs Good using SQL as their primitives, and that viewpoint made a bunch of other features and optimizations obvious. Stated somewhat differently, do you want to write the algorithm to do a 3-connected recursive join in linear time, or do you want to slap the join into a DB and move on with your lif…
Noria
https://github.com/mit-pdos/noria
https://www.youtube.com/watch?v=kVv9Pik6QGY
https://thesquareplanet.com/research/
Materialize/TimelyDataflow
https://scholar.google.com/citations?hl=en&user=YYJ3aycAAAAJ...