No compromises but isn’t ‘externalising’ a large video the equivalent of storing a pointer in the first example? Can’t really see any other way to understand what that means (it goes to an external system and you store where it is)
In the paper you'll notice a large portion of it analyzes Vortex, both standalone and embedded. Definitely worth a read.
> 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.
Then you could save every single state change and scroll back and forth. But I'm not sure if you were looking for that.
Postgres (and MongoDB) are the king and prince of data due to their transactional capabilities.