← All posts

Category: Engineering

All posts in the Engineering category

Engineering March 12, 2026

Hexagons, Hypertables, and 240 Dead Tags: Migrating a Maritime Data Platform to TimescaleDB

How we migrated a maritime AIS platform from MongoDB to TimescaleDB, built two-layer spatial indexing with H3 and PostGIS, and found 240 dead struct tags from the old world.

Engineering March 7, 2026

Why There's a Tanker in Central Madrid

We process a million AIS messages per hour. Four out of ten are garbage. This is how we built a four-layer filtering pipeline to catch phantom ships, GPS glitches, and spoofed positions.