Hacker News new | ask | show | jobs
by VWWHFSfQ 489 days ago
> Be brave. Just try it.

This is the exact opposite attitude I would want to have when it comes to choosing the best way to store and manage my data. My data is actually important. I understand that might not be true for a lot of other people. I also have a lot of data, and non-trivial amounts of data has incredible inertia. It's very difficult to move and "redo" if you mess it up.

For all these reasons, I just use postgres.
1 comments
chrsig 489 days ago
On the flip side, sqlite is also a great choice in those circumstances. so regardless of attitude, outcome seems good to me.

incredibly well tested for scenarios where data loss is likely, code is in the public domain, available on all major operating systems, included in language standard libraries... it's one of the most ubiquitous pieces of software out there.

link
VWWHFSfQ 489 days ago
I'm not going to use a database that doesn't even have a proper date/time type and treats everything as a string.
link
chrsig 489 days ago
ok, that seems like a bit of a moved goal post, but you do you.

is there any particular impact you see that having? Postgres has had it's share of data integrity issues due to things like locale differences between primary and replica, where strings would get sorted differently.

I'm not advocating for one over the other. I love both, but neither are perfect.

https://www.citusdata.com/blog/2020/12/12/dont-let-collation...

https://wiki.postgresql.org/wiki/Todo:ICU

link