I'm working on a project where I process national radar data and generate a GeoJSON with the data. The data is generated every 5 minutes and I delete the oldest data before I add the latest data. I'm currently trying to decide the best way to go about serving vector tiles from this data. My current two solutions are:
Every 5 minutes I generate a new GeoJSON for the most current data, then using PostGIS I delete the oldest data from the table and then I insert the newest data. Once generated I serve tiles using a tool called Martin.
Every 5 minutes, I delete the oldest data from a GeoJSON stored in the file system, then I add the newest data to it. Then I use Tippecanoe to generate a .mbtiles file from the stored GeoJSON and serve the vector tiles using that.
From my research, I've found information for generating tiles on the fly and serving static tiles. But I don't need either. Right now, using PostGIS seems like the best option but it feels like overkill to generate the tiles every time they're requested. There isn't too much information out there for this scenario and I'm wondering if anyone could offer some insight into what might be the most optimal way to handle this.