logoalt Hacker News

psadauskasyesterday at 5:55 PM3 repliesview on HN

My general rule of thumb is "Use Postgres until you've discovered why you can't use Postgres."

Anything you introduce is another moving part you have to operate and maintain, and in the beginning, Postgres can probably handle it. Wait for load, see where its failing, and then you'll have a better idea if adding another tool is worth the cost.


Replies

andaiyesterday at 5:58 PM

Doesn't the same argument apply even more to using SQLite instead?

show 2 replies
rafael-luatoday at 1:45 AM

The issue with this general rule of thumb is that we can swap Postgres for many others, including non-relational, and it works.

show 1 reply
boznzyesterday at 11:32 PM

Another rule of thumb. Use what you are comfortable with until it stops doing what you want.

show 1 reply