Programming, data and automation.

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

Shape the Import Surface of a Python Analytics Service Before the Live Loop
Keep PostgreSQL Lookups Cheap While a Vision Worker Boots Up
Turn YOLO Detections Into Per-Frame Motion Buckets Without Losing the Thread
Ship Live Metrics Into PostgreSQL, Fan Them Out, and Keep a Debug Overlay Nearby
Sketch a Streamlit Analytics Page With Filters Before the Data Arrives
Query Recent Telemetry and Draw Plotly Views Without Overcomplicating the Refresh Cycle
Switch Between Live Mode, Batch Export, and Safe Shutdown in One Python Entry File
Lay Out a Traffic Intelligence File Before the First Frame Arrives
Track Vehicles Frame by Frame and Paint a Calm Overlay in PIL
Persist Live Detections and Roll Them Into an Hourly Mart
Start the Workers Once and Cache the First History Pull
Filter a Streamlit Traffic Dashboard Without Turning the Layout Into Glue
Validate a Forecasting Loop and Surface Dispatcher Warnings Without Noise