Small write-ups on scripts, pipelines and practical backend work.
A step-by-step Python pattern for reading CSV files, validating required columns and reporting row-level errors without guesswork.
Read moreA practical walkthrough for turning tracked detections into annotated frames, speed estimates and storage-ready rows in one steady function.
Read moreA practical Python walkthrough for turning repeated terminal commands into one clean task runner with argparse, subprocess and readable task definitions.
Read moreA tidy backend pattern for merging default settings, environment overrides and local tweaks into one final configuration object.
Read moreA steady walkthrough for starting worker threads once, opening the Streamlit page and caching the first history pull without clutter.
Read moreA clean Python pattern for parsing noisy application logs, grouping failures by service and turning raw events into a short daily report.
Read moreA practical pathlib-based workflow for archiving processed files, separating failed inputs and keeping report folders under control.
Read moreA practical guide for filtering traffic history, surfacing KPI cards and drawing the first chart layer in a Streamlit dashboard.
Read moreA grounded walkthrough for validating environment variables, applying defaults and building one trustworthy configuration object at startup.
Read moreA grounded article about building the import surface, runtime settings and frame bootstrap of a traffic analytics script before the detector starts.
Read moreA clear guide for persisting live detections in PostgreSQL and rolling them into an hourly mart without burying the retry behavior.
Read moreA calm, practical guide to retry logic, backoff timing and deciding which API failures are temporary enough to try again.
Read moreA calm technical walkthrough for validating a lightweight forecasting model and surfacing operational warnings without drowning the page.
Read moreA reflective walkthrough for designing a maintenance-friendly Python loop so cleanup, retries and everyday automation stay readable.
Read moreA reflective walkthrough for keeping state changes visible while a Python file accumulates helper functions, logs and background tasks.
Read moreA reflective walkthrough for separating settings, environment values and runtime defaults before a small Python tool grows into a real service.
Read moreA practical walkthrough for building reporting views, retention checks and release-ready SQL summaries before a dashboard starts depending on them.
Read moreA practical walkthrough for pairing upserts, conflict rules and measurement windows so a busy SQL loader stays understandable.
Read moreA practical walkthrough for defining a staging table, load contract and gentle transaction boundary before SQL ingestion starts to sprawl.
Read moreAn English article version of a Module B report covering video-stream capture, vehicle detection, tracking, and batch aggregation for traffic analysis.
Read moreAn English article version of a Module V report covering traffic forecasting horizons, dashboard filters, and transport-flow monitoring.
Read moreA small monthly snapshot gives the sidebar a more alive feel without turning it into another list of links or post counters.
Reading Map
Start from one of these pages if you want to jump straight to a useful section of the site.
Browse the main page with all recent posts
Open the Python workflow article
Read the guide about archiving files
Send feedback or suggest a new topic