Programming, data and automation.

Small write-ups on scripts, pipelines and practical backend work.

Ship Live Metrics Into PostgreSQL, Fan Them Out, and Keep a Debug Overlay Nearby
Track Vehicles Frame by Frame and Paint a Calm Overlay in PIL
Shape the Import Surface of a Python Analytics Service Before the Live Loop
Sketch a Streamlit Analytics Page With Filters Before the Data Arrives
Start the Workers Once and Cache the First History Pull
Keep PostgreSQL Lookups Cheap While a Vision Worker Boots Up
Query Recent Telemetry and Draw Plotly Views Without Overcomplicating the Refresh Cycle
Filter a Streamlit Traffic Dashboard Without Turning the Layout Into Glue
Turn YOLO Detections Into Per-Frame Motion Buckets Without Losing the Thread
Lay Out a Traffic Intelligence File Before the First Frame Arrives
Persist Live Detections and Roll Them Into an Hourly Mart
Switch Between Live Mode, Batch Export, and Safe Shutdown in One Python Entry File
Validate a Forecasting Loop and Surface Dispatcher Warnings Without Noise
Leave Room for a Python Runtime Maintenance Loop Before Automation Turns Brittle
Keep Python Side Effects Easy to Trace While Utility Helpers Multiply
Map Python Language Defaults Before a Utility Script Starts Growing
Shape Reporting Views and Retention Checks Before a Streamlit Dashboard Goes Live
Keep an Upsert Window Calm While Streamlit and Docker Layers Continue to Poll
Outline a Staging Data Layer Before the First Sync Gets Loud
Stage Streaming and Batch Traffic Circuits Before Hourly Metrics Start Piling Up
Tune Short-Horizon Traffic Forecasts Before a Live Dashboard Starts Guessing