ambientweather2sqlite 0.6.0

A project to record weather observations from an AmbientWeather station over the local network - no API needed!

AmbientWeather to SQLite

A project to record minute-by-minute weather observations from an AmbientWeather station over the local network - no API needed!

Key Features

• Local Network Operation: Direct connection to weather stations without external API dependencies
• Continuous Data Collection: Automated daemon process collecting data at 60-second intervals
• Dynamic Schema Management: Automatic database schema evolution as new sensors are detected
• HTTP JSON API: Optional web server providing live data access, Includes hourly and daily aggregation endpoints.
• Interactive Configuration: Command-line setup wizard for initial configuration
• Cross-Platform Distribution: Available via PyPI with pipx installation
• Zero Dependencies: Pure Python with no (potentially) untrusted 3rd parties.

Installation

• macOS: brew install pipx && pipx install ambientweather2sqlite
• Ubuntu / Debian: sudo apt update && sudo apt install pipx && pipx install ambientweather2sqlite
• Fedora: sudo dnf install pipx && pipx install ambientweather2sqlite

Setup

On the first run of ambientweather2sqlite you will be asked to provide the station's LiveData URL and the database path.

This config file is saved to your current directory by default but may be stored anywhere.

On subsequent runs, you can pass the file name as a command line argument or it will be automatically detected in your current directory or at ~/.aw2sqlite.toml

HTTP JSON API

The optional web server provides live data access and aggregation endpoints:

Endpoints

• / - Live weather data
• /daily - Daily aggregated data
• /hourly - Hourly aggregated data for a specific date

Daily Aggregation

Query parameters:

• q - Aggregation fields (e.g., avg_outHumi, max_gustspeed)
• days - Number of prior days (default: 7)
• tz - Timezone for timestamp conversion (required)

Examples:

/daily?tz=America/New_York&q=avg_outHumi&days=7
/daily?tz=Europe/London&q=min_outTemp&q=sum_eventrain

Hourly Aggregation

Query parameters:

• date - Date in YYYY-MM-DD format (required)
• q - Aggregation fields
• tz - Timezone for timestamp conversion (required)

Examples:

/hourly?date=2025-06-27&tz=America/Chicago&q=avg_outHumi
/hourly?date=2025-06-27&tz=%2B05%3A30&q=max_gustspeed

Timezone Support

Timezone strings can be:

• IANA timezone names: America/New_York, Europe/London, Asia/Tokyo
• UTC offsets: +05:30, -08:00
• URL-encoded when necessary: %2B05%3A30 for +05:30

Development

Pull requests and issue reports are welcome. For major changes, please open an issue first to discuss what you would like to change.

Core Architecture

Control Flow

Legal

© Harold Martin - released under GPLv3

AmbientWeather is a trademark of Ambient, LLC.