Comment by all2
6 months ago
Spelling error "sttill"
> P.S. If you're sttill managing data in spreadsheets, this post isn't for you. Yet.
---
Since I discovered the ECS pattern, I've been curious about backing it with a database. One of the big issues seems to be IO on the database side. I wonder if Spiral might solve this issue.
Have a look at something like spacetimeDB - caveat, I've only read about it and not directly used it:
https://github.com/ClockworkLabs/SpacetimeDB
This was part of my inspiration. They do some interesting things with their systems, like hot reloads, that makes the dev loop a lot tighter.
If the ECS data is grid-like, perhaps you could use a columnar database for time series?
Then you could save every single state change and scroll back and forth. But I'm not sure if you were looking for that.
This would make netcode state rollback easy. But I'm not sure the DB is the right place for that.