Introduction
I built a fully automated weather reporting system called weather2, which updates every 4 hours and publishes multi‑language weather reports using GitHub Pages.
This project combines PowerShell, SQL Server, Python, and the OpenWeatherMap API to generate real‑time discomfort index (DI) data.
System Architecture
Windows 11 + Task Scheduler for automation
PowerShell 5.1 for data processing and HTML generation
SQL Server Express 2022 for storing weather logs
Python + pyodbc for database access
GitHub API for automatic publishing
GitHub Pages for hosting the reports
Automation Workflow
Fetch weather data from OpenWeatherMap API
Calculate discomfort index (DI)
Generate HTML reports
Translate reports into 5 languages using offline dictionaries
Upload HTML files to GitHub via REST API
GitHub Pages publishes the updated reports automatically
Multi‑Language Support
The system generates weather reports in:
🇯🇵 Japanese
🇺🇸 English
🇷🇺 Russian
🇨🇳 Chinese (Simplified)
🇰🇷 Korean
Each language is translated using offline JSON dictionaries such as:
dictionary_en.json
dictionary_ru.json
dictionary_zh.json
dictionary_ko.json
Live Demo
Here are the live weather reports:
🇯🇵 Japanese
https://yahikoyama.github.io/weather2/weather_report_now.html
🇺🇸 English
https://yahikoyama.github.io/weather2/weather_report_now_en.html
🇷🇺 Russian
https://yahikoyama.github.io/weather2/weather_report_now_ru.html (yahikoyama.github.io in Bing)
🇨🇳 Chinese
https://yahikoyama.github.io/weather2/weather_report_now_zh.html (yahikoyama.github.io in Bing)
🇰🇷 Korean
https://yahikoyama.github.io/weather2/weather_report_now_ko.html (yahikoyama.github.io in Bing)
Source Code
The full source code and database backup are included in:weather.zip
Conclusion
This project demonstrates how PowerShell, SQL Server, and GitHub Pages can be combined to build a fully automated, multi‑language weather reporting system.
I hope this helps others who want to explore automation, API integration, or GitHub Pages workflows.
Top comments (0)