Building a Multi‑Language Weather Report System Using PowerShell, GitHub Pages, and OpenWeatherMap API

Yasu — Sat, 18 Jul 2026 14:38:56 +0000

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.

DEV Community: Yasu

Building a Multi‑Language Weather Report System Using PowerShell, GitHub Pages, and OpenWeatherMap API