GPS Data Gets Ugly Fast: A Fleet GPS Data Pipeline That Stays Queryable

Telematics devices lie in specific, documented ways: stale fixes reported as new, zero coordinates after reboot, and buffered records replayed days late. Here is how to build a fleet GPS data pipeline on PostgreSQL, PostGIS and TimescaleDB that survives all three and still answers trip and geofence queries fast.

Continue ReadingGPS Data Gets Ugly Fast: A Fleet GPS Data Pipeline That Stays Queryable

Oracle to Aurora PostgreSQL: A Migration Plan That Survives Contact

The assessment report says most objects convert automatically, and that number becomes a date on a roadmap. It measures objects, not work. Here are the six decisions that actually set the timeline of an Oracle to Aurora PostgreSQL migration, a phase sequence gated on artefacts rather than dates, and the places estimates quietly go soft.

Continue ReadingOracle to Aurora PostgreSQL: A Migration Plan That Survives Contact

The Delay Was in the Data Three Weeks Ago: Building a Construction Early Warning Dashboard

Schedule delay rarely arrives as a surprise. It sits in float erosion, aging RFIs and slipping weekly commitments long before the monthly update moves the finish date. Here is how to build a dashboard that catches it while there is still float left to spend.

Continue ReadingThe Delay Was in the Data Three Weeks Ago: Building a Construction Early Warning Dashboard

AWS Schema Conversion Tool for Oracle: What Converts and What Quietly Doesn’t

The assessment report grades syntax, not behavior. A four-tier breakdown of what AWS SCT converts cleanly, what it converts while silently changing meaning, what it only handles through the extension pack, what it refuses outright, and the whole category it never looks at.

Continue ReadingAWS Schema Conversion Tool for Oracle: What Converts and What Quietly Doesn’t

As-Planned vs As-Built Analysis: Building a Platform That Survives Cross-Examination

Most as-planned vs as-built analysis compares the baseline to the last P6 update and calls the result an as-built. It isn't one. This is how to build the data layer underneath a delay analysis: versioned XER ingestion, activity identity across renumbering, a first-appearance table that proves when every actual date entered the record, calendar-safe float, and record linking that proposes candidates instead of asserting cause.

Continue ReadingAs-Planned vs As-Built Analysis: Building a Platform That Survives Cross-Examination

Oracle to Aurora Migration: The Failures Nobody Catches Until Cutover

Most Oracle to Aurora migrations don't fail loudly. They finish green, pass validation, and quietly hand you truncated LOBs, sequences stuck at 1, and empty strings that used to be NULL. Here are the four failure families to check before you cut over, with the SQL and task settings that catch them.

Continue ReadingOracle to Aurora Migration: The Failures Nobody Catches Until Cutover