Alexandre de Verteuil<p>Currently, I have a <a href="https://mastodon.online/tags/NodeRED" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NodeRED</span></a> data pipeline pulling weather metrics from <a href="https://mastodon.online/tags/OpenWeather" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenWeather</span></a> every hour, a table in <a href="https://mastodon.online/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> to store the JSON payloads, a View to query the historical data, <a href="https://mastodon.online/tags/PostgREST" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgREST</span></a> to provide an HTTP REST API to read and write to the tables and views.</p><p><a href="https://openweathermap.org/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">openweathermap.org/</span><span class="invisible"></span></a><br><a href="https://nodered.org/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">nodered.org/</span><span class="invisible"></span></a><br><a href="https://docs.postgrest.org/en/v12/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">docs.postgrest.org/en/v12/</span><span class="invisible"></span></a></p>