I’m sure other people have come across this idea / wanted to implement in the past.
Is anyone aware of a hosted read-only weather database service that exposes some sort of SQL-compatible frontend?
Would be incredible to show historical geolocated weather queries in a dashboard alongside internal data within metabase.
Or does anyone have suggestions about the most practical / fastest way to DIY expose historical and daily-updated weather data to set-up such a database yourself?
Worst case, I guess I can setup an ETL worker job sort of thing that extracts data from NOAA and sticks it in a database.
Would love to see something analogous as a hosted offering or in a 1-click deploy dockerized/heroku-button-ified setup.
Thought I’d ask around before going through the trouble of making such a thing myself!