Relational databases impedance mismatch and app dev's frustrations

PostgreSQL is undeniably a great tool. Yet I’ve lost too much of my life to bending my application around it. The problem is not that it’s a bad tool. It’s that a serious business application you don’t need a tool but a toolbox.

Hammer vs. toolbox
Figure 1. A relational DB gives you a really fancy, excellently made hammer. But life isn’t just nails. Sometimes, you have a screw. Or a large nail. Or a tiny one. Or you need to open a jar of pickles. You don’t need a one-size-fits-all hammer. You need a toolbox.

In short: The data model is too limited. You have tables, and that’s it. Using a single important table for a number of queries with very different needs and making it perform well in all those cases is impossible. You can get indices - but there is no guarantee the planner will pick the best one. (Plus, they cost.) The query planner is smart, but not smart enough. When it has bad estimates, it will make terrible, slow plans. In PostgreSQL, if your query has Common Table Expressions (CTEs for short; think of these as named sub-queries, or local views), especially if you have a CTE feeding into another CTE, then the planner is screwed. It has limited insight into CTEs and their row count estimates may be made up. As you combine more CTEs, the error multiplies.


Continue reading →

Consciousness work: what, why, how

There are matters more important than technology, and becoming more conscious of what is going on in your experience, and thus more free and powerful, is one of those.

(This is a transcript of my 10 min talk on the topic. You may or may not prefer watching it instead of reading.)

We are enslaved by anything we do not consciously see.

We are freed by conscious perception.

— Vernon Howard

I love this quote because it expresses so well what consciousness work is primarily about for me.

So what is consciousness work?

Look into your experience to become more conscious of what is going on and what is actually true.


Continue reading →

Consciousness sabbatical for the forseeable future

Technology is fun, but there are far more important things in life. Such as understanding what life, self, and everything really is. It has been really quiet here this year, and it will continue to be that way because to progress I need to focus. I may come back or I may not. It doesn’t really matter either way :-).

If you don’t really know what consciousness is or why it should matter, I cannot recommend enough as a starting point the book Ending Unnecessary Suffering. And even more than the book, the corresponding workshop, which makes it far easier to actually experience the stuff (and, hopefully, a fundamental perspective shift), rather than just thinking about it. Thinking is pointless (it is, after all, what gets us in all this mess), getting insights in one’s own experience is what makes a difference. All the best, and thank you for all the fish*!


Continue reading →

My digital tools and routines (2024)

My computer is my wizard’s staff, the thing that allows me to do my magic. What is my set up, what tools do I use for daily productivity, and how do I keep it safe from a disaster?


Continue reading →

Hands on Rama, day 3: Foreign keys and data integrity, macros, queries

The adventure with Rama continues! In the previous installment, I have created a simple C(R)UD for "components". Today, we will spice it up and add a foreign key and data integrity maintenance. Namely, a component can have a parent, which can also have a parent, etc.

I learn about transactional updates, about writing query topologies, and about code reuse with Rama segmacros. As usually, I excel at running into problems we can all learn from 😅.


Continue reading →

Rama: How to achieve a transactional update across partitions

While implementing my pet project on the mind-bending Rama platform, I ran into the classical need for an atomic update of a set of states, possibly at different partitions / machines. Let’s see what are our options for implementing that.


Continue reading →

Copyright © 2026 Jakub Holý
Powered by Cryogen
Theme by KingMob