Morecast: Optimize weather models/actuals retrieval
- Dominant language
- Python
- Stars
- 65
- Forks
- 11
- Avg merge
- 21h 25m
- Merged PRs (30d)
- 70
Description
**Describe the task**
To enable skill scoring across a configurable time range, we want to be able to look up model and actual values from any date range quickly so that skill scoring can be performed dynamically.
**Acceptance Criteria**
- [ ] Be able to adjust the skill score window on the fly without affecting app performance
- [ ] Be able to retrieve actual/model 20z values for each station
**Additional context**
- Denormalize? Materialized view? Optimize queries?
Contributor guide
Research direction
No files, tests, or entry points are identified. Start by tracing how model and actual values are currently queried for stations and configurable date ranges, then compare denormalization, materialized views, and query optimization. Done means the skill-score window can change without affecting app performance and 20z actual/model values are retrievable for each station.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100