- How a Read Query Can Write to Disk: a Postgresql Story
19 Mar 2020
Here’s a funny relational database story from earlier this year. One of our clients had a medium-large database — millions of rows — and their business logic required some pretty fancy queries across that data: more sophisticated and more costly than just fetching records by id. So ended up doing quite a bit of query tuning to get everything running smoothly. This story begins with the discovery of two obviously (ahem) unrelated problems.
- You Are What You Consume
27 Jul 2021
In today’s online world, you are what you consume. I explore what this does to your mind and suggest some possible solutions.
- Why Embedded Software Development is Harder
3 Oct 2021
External hardware, distributed systems, resource constraints, realtime, hw-sw-codesign, and safety-criticality make it hard.