EU Air Traffic
→Live and historical European airspace: ADS-B positions, OpenSky movements, schedules and weather stream through Kafka into a Bronze and Silver lake, a dbt warehouse on DuckDB and a read-only serving copy behind a public dashboard.
Projects
Production platforms, open-source tools, and research projects. Each project page has the full write-up.
Pipelines, warehouses and streaming
Live and historical European airspace: ADS-B positions, OpenSky movements, schedules and weather stream through Kafka into a Bronze and Silver lake, a dbt warehouse on DuckDB and a read-only serving copy behind a public dashboard.
A $0 anomaly-detection platform over free satellite and sensor data. Four public sources flow into a versioned Hugging Face lake, dbt and DuckDB build seven gold marts, an IsolationForest scores anomalies, and an edge dashboard serves it from Turso.
GDPR-native streaming and medallion lakehouse for European commerce: real-time fraud scoring, DuckDB and Turso serving, and a six-layer Article 17 erasure cascade with a verifiable audit trail.
Models, MLOps and applied AI
Privacy-first, self-hosted writing assistant: a browser extension with a 156,000-word offline engine and more than 40 rule patterns, an AI router that only sees what local rules miss, and a Hono backend that deploys to five runtimes.
A multi-camera surveillance and behavioral monitoring platform that runs on ordinary hardware. It does real-time face recognition with anti-spoofing liveness checks, tracks occupancy and gate traffic, remembers where tracked assets were last seen, sends alerts, and includes an AI copilot that answers questions about the live database in plain English.
Versioned memory for LLM agents, built on Git's branching model: observation-thought-action logs, commits, branches and merges for an agent's context, implemented in seven languages that share one .GCC/ on-disk format.
A self-hosted LLM inference gateway and MLOps control plane: an OpenAI-compatible API with multi-backend routing, content guardrails, cost tracking, a model registry with canary and blue-green deploys, and Prometheus and OpenTelemetry observability.
Papers, benchmarks and prototypes