Hello Theo,
This is an excellent use case for TileDB. We have a more flexible way of updating arrays than Zarr, which can easily solve this specific problem. I’ll message you directly to schedule a call and discuss in more detail. We’d certainly be happy to publish any solution we build afterwards.
Stavros