3 ms·
This is a good thing to be aware of when choosing a database, but I think most of the time people just reach for Postgres because it's the "standard".
by phendrenad2 2y ago
This is a good thing to be aware of when choosing a database, but I think most of the time people just reach for Postgres because it's the "standard".
- pdimitar 2y agoPostgreSQL stops many data bugs at the door due to being so strict -- something many programmers start rediscovering is a good thing by choosing stricter programming languages with time. I love SQLite to bits but the test harness I have to put around my apps with it is a separate project in itself.
- phendrenad2 2y agoSomehow this is my first time hearing about that benefit of Postgres! (despite having googled for explanations of why people were switching to it). Being on HN proves more valuable than google once again...
- pdimitar 2y agoGlad to help! On a philosophical / meta level it's all quite simple: do your damnedest for the computer to do as much of your work for you as possible, really. Nothing much to it. Strict technologies slap you hard when you inevitably make a mistake so they do in fact do more of your work for you.