Skip to content

Instantly share code, notes, and snippets.

@sickel

sickel/forecast.sql

Created March 15, 2024 06:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sickel/9ae88a47f665c0962120078ed93e103a to your computer and use it in GitHub Desktop.
Save sickel/9ae88a47f665c0962120078ed93e103a to your computer and use it in GitHub Desktop.
Download ZIP
Database table to store forecasts from met.no
Raw
forecast.sql
create table forecast(
parameter varchar not null,
value numeric not null,
unit varchar,
timestamp timestamp not null);
alter table forecast add primary key(parameter,timestamp);
@sickel
Copy link
Author

sickel commented Mar 15, 2024

see https://gist.github.com/sickel/18e9aee3d20e4151600ca385150f7cb6 for a script to insert data into this table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment