Skillful
Local-first platform for managing reusable AI workflows and organisational knowledge.
Rick van Lieshout
CTO, software architect and engineering leader focused on building great software, growing teams and solving complex technical challenges.
© All rights reserved.
Featured Work
A few open-source projects and tools I've built or maintained over the years.
Latest Articles
Debugging millions of PCIe errors on my Linux server with a USB stick
My Ubuntu server was generating millions of PCIe errors. A USB-C flash drive helped me trace the problem to runtime power management and find a simple workaround.
Read (9 min read)ORM, query builder, or SQL: choosing the right abstraction level
ORMs are lovely, they can help you speed up a lot, but they shouldn't pretend SQL doesn't exist and I'll explain why.
Read (12 min read)Keeping massive loads of hot data manageable with PostgreSQL partitioning
Using PostgreSQL's native partitioning to keep high-volume recent data small while cheaply moving older data into an archive.
Read (11 min read)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.
Read (14 min read)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.
Read (10 min read)