- Title: Weather Monitoring System with Python-MySQL Connectivity
- Developer: R JAYAM
- Subject: Computer Science (Class XII)
- Status: Stable / Deployment Ready
SkyCast is a professional desktop application developed for the Class 12 Computer Science practical examination. It bridges the gap between a Python-based Graphical User Interface (GUI) and a MySQL backend, demonstrating how modern software handles live data from the internet and stores it locally for persistent record-keeping.
- 🌐 Global Search: Fetches real-time weather data (temperature, humidity, wind) via OpenWeatherMap API.
- 🗄️ Data Persistence: Automated search logging and history tracking using MySQL Connector.
- 📍 Smart Geocoding: Instant coordinate translation for any city using
geopy. - 🕒 Timezone Aware: Dynamic clock synchronization using
pytzandtimezonefinder. - 📦 Standalone App: Packaged into a portable
.exefile usingauto-py-to-exefor zero-install deployment.
| Module | Purpose |
|---|---|
| mysql.connector | Establishing Python-MySQL database connectivity. |
| requests | Fetching and parsing JSON data from REST APIs. |
| geopy | Performing geocoding for city coordinates. |
| timezonefinder | Finding local timezones based on coordinates. |
| pytz | Handling global time conversions. |
| auto-py-to-exe | Converting the Python script into a Windows Executable (.exe). |
- Python 3.x installed.
- MySQL Server installed and running.
Ensure MySQL is running and create the necessary database. Update your connection credentials (host, user, password) in the Python script.
CREATE DATABASE weather_db;
-- Create your tables as per the project documentation###3. Installation
Clone the repository and install the required dependencies:
git clone https://github.com/RJ331155/Project-Weather-app.git
pip install <module_name>
###4. Execution
To launch the application from the source code:
python
"WEATHER APP.py"
The EXE
[🚀 Download Standalone EXE](https://github.com/RJ331155/Project-Weather-app/raw/main/WEATHER2APP/WEATHER%20APP.exe)
##🖥️ Distribution A standalone Windows version is provided in the repository. This allows the application to run as a .exe on any machine without requiring a Python installation, provided a MySQL server is accessible to the application.
Declaration: This project is original work developed for the fulfillment of the Class 12 Computer Science Practical curriculum.