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.

How a Read Query Can Write to Disk: a Postgresql Story

In today’s online world, you are what you consume. I explore what this does to your mind and suggest some possible solutions.

You Are What You Consume

External hardware, distributed systems, resource constraints, realtime, hw-sw-codesign, and safety-criticality make it hard.

Reading List