Why ERP (Enterprise Resource Planning) MySQL Is Not an Analytics Store
MySQL written by an internal ERP is operational truth — geographic analysis and wait hotspots need a cleansed analytics store.
Python in Production (Python)
Posts about python
Cleansing Operational Data into PostgreSQL
Cleansing Operational Data into PostgreSQL — a production lesson from an ABC Logistics backend/data platform.
PostGIS for Fleet and Yard Truth
PostGIS for Fleet and Yard Truth — a production lesson from an ABC Logistics backend/data platform.
MongoDB for High-Frequency Telemetry
MongoDB for High-Frequency Telemetry — a production lesson from an ABC Logistics backend/data platform.
Elasticsearch for Ops Search Across Entities
Elasticsearch for Ops Search Across Entities — a production lesson from an ABC Logistics backend/data platform.
Multi-Node Clusters Without the Single-Brain Myth
Multi-Node Clusters Without the Single-Brain Myth — a production lesson from an ABC Logistics backend/data platform.
Anti-Corruption Between ERP (Enterprise Resource Planning) and Analytics
Anti-Corruption Between ERP and Analytics — a production lesson from an ABC Logistics backend/data platform.
Serving Clean Reads to Ops Frontends
Serving Clean Reads to Ops Frontends — a production lesson from an ABC Logistics backend/data platform.
Data Contracts for Geofence and Expeditions
Data Contracts for Geofence and Expeditions — a production lesson from an ABC Logistics backend/data platform.
Observing Lag Across Polyglot Stores
Observing Lag Across Polyglot Stores — a production lesson from an ABC Logistics backend/data platform.
From EDA (Exploratory Data Analysis) to Fleet Waiting Hotspots
Starting with EDA on location and wait histories, then productizing where vehicles wait most.
scikit-learn and PyTorch on Location Histories
scikit-learn and PyTorch on Location Histories — a production lesson from an ABC Logistics backend/data platform.
OSRM (Open Source Routing Machine) Shortest Path vs Driver Preferred Path
OSRM Shortest Path vs Driver Preferred Path — a production lesson from an ABC Logistics backend/data platform.
Measuring Fuel Waste and Km Extension
Measuring Fuel Waste and Km Extension — a production lesson from an ABC Logistics backend/data platform.
Quantifying Delay from Route Deviation
Quantifying Delay from Route Deviation — a production lesson from an ABC Logistics backend/data platform.
Foundation Models for Ops Narrative Insights
Foundation Models for Ops Narrative Insights — a production lesson from an ABC Logistics backend/data platform.
Wait Region Ranking as an ML (Machine Learning) Product
Wait Region Ranking as an ML Product — a production lesson from an ABC Logistics backend/data platform.
Serving Route Intelligence to the Map UI (User Interface)
Serving Route Intelligence to the Map UI — a production lesson from an ABC Logistics backend/data platform.
Evaluating Models Without Leaking PII (Personally Identifiable Information)
Evaluating Models Without Leaking PII — a production lesson from an ABC Logistics backend/data platform.
Closing the Loop from Model to Dispatcher
Closing the Loop from Model to Dispatcher — a production lesson from an ABC Logistics backend/data platform.
Django as the Ops Analysis API (Application Programming Interface) Layer
Python/Django serves PostGIS–Mongo–ES reads to MFEs and the control plane as safe JSON contracts.
API (Application Programming Interface) Boundaries for MFE (Module Federation) and Control Plane
API Boundaries for MFE and Control Plane — a production lesson from an ABC Logistics backend/data platform.
GitLab CE Pipelines to EC2 in a Closed Network
GitLab CE Pipelines to EC2 in a Closed Network — a production lesson from an ABC Logistics backend/data platform.
Immutable Artifacts and Rollback Discipline
Immutable Artifacts and Rollback Discipline — a production lesson from an ABC Logistics backend/data platform.
Continuous Penetration Testing in Delivery
Continuous Penetration Testing in Delivery — a production lesson from an ABC Logistics backend/data platform.
Secrets and Network Trust on Self-Hosted Runners
Secrets and Network Trust on Self-Hosted Runners — a production lesson from an ABC Logistics backend/data platform.
Correlating API (Application Programming Interface) Errors with Frontend Incidents
Correlating API Errors with Frontend Incidents — a production lesson from an ABC Logistics backend/data platform.
Production Readiness Checklist for Logistics APIs
Production Readiness Checklist for Logistics APIs — a production lesson from an ABC Logistics backend/data platform.