Rick van Lieshout
CTO, software architect and engineering leader focused on building great software, growing teams and solving complex technical challenges.
© All rights reserved.
postgres
Stop seeding the whole system to test one query
When you want to know whether a GET endpoint stays fast with 100k orders, do not drag the whole system into the test. Seed the right data, test through the app, and let telemetry guide the next step.
Timezones from coordinates (lat/long): enriching ingestion with PostGIS
A datetime with an offset isn't a timezone. Here's how we use PostGIS and the Timezone Boundary Builder dataset to turn a driver's GPS coordinates into the IANA zone their planner actually needs to see.