After months of testing and iteration, I have finally nailed this down. Sharing my notes before I forget the details.
How I compared them
Same tasks, same timeframe, same hardware. I ran each option for at least one full week before forming an opinion. Quick impressions are misleading — things that seem great on day 1 can become annoying by day 5, and vice versa.
What the documentation doesn’t tell you
The official docs cover the happy path. Real life is the unhappy path. Here is what actually happens when you try to follow the tutorial step by step — and how to handle the inevitable errors.
The verdict
There is no single best option. There is a best option for YOUR specific situation. I have tried to give you enough context to make that call yourself instead of just telling you what to pick.
That is everything I know about this topic. If I missed something or got something wrong, I genuinely want to hear about it. Drop a comment or find me on agntai.net, agnthq.com.
For more technical reference, check Google Search Docs, PostgreSQL Docs.