Featured

Fleet Performance Watchdog

Asynchronous concurrent endpoint monitor and SSL expiration daemon featuring SQLModel time-series and webhook alerts.

Client: David the Gnomad Inc.
  • Python
  • Asyncio
  • SQLModel
  • FastAPI
  • pyOpenSSL
  • devops
  • monitoring
  • python
  • api

The Business Case

Unplanned website downtime and expired SSL certificates damage brand trust and disrupt operations. Fleet Watchdog offers a lightweight, self-hosted alternative to heavy enterprise monitoring suites. It polls dozens of endpoints concurrently, logs latencies in a local time-series database, and triggers immediate webhook notifications on failure, ensuring issues are caught before users notice them.

Technical Highlights

1. High-Concurrency Asynchronous Engine

By leveraging Python’s asyncio loop and httpx connection pooling, the daemon monitors hundreds of sites simultaneously without blocking system resources or thread execution.

2. Time-Series Metric Storage

The application logs latency trends and status histories to a local SQLite database using SQLModel. The database runs in WAL (Write-Ahead Logging) mode to support concurrent writes, and includes automatic metric pruning to manage disk usage.

3. Dynamic Alert Routing & SSL Inspection

Using pyOpenSSL, the daemon parses SSL certificate lifecycles to detect upcoming expirations. On failure or recovery, the alert system routes structured payloads to Slack, Discord, or generic webhooks.