News for hackers. Stuff that matters.
Re:Things to know about databases by emerongi on Monday June 27, 2022 @01:39PM (#31897944)
With Postgres, you can always just have a JSONB column for data whose shape you're unsure of. Personally, I'd rather start with Postgres and dump data into there and retain the powers of RDBMS for the future, rather than the other way around and end up finding out that I really would like to have features that come out of the box with relational databases.

I think a valid reason for not choosing a relational database is if your business plan requires that you grow to be a $100B+ company with hundreds of millions of users. Otherwise, you will probably be fine with RDBMS, even if it will require some optimizing in the future.

Re:Things to know about databases by mslot on Monday June 27, 2022 @02:33PM (#31898718)
Most $100B+ companies (e.g. Google, Meta, Amazon) were built primarily using relational databases for the first 10-15 years.
Re:Things to know about databases by packetlost on Monday June 27, 2022 @02:30PM (#31898662)
Postgres' JSON implementation perfectly adheres to the JSON spec, which actually sucks if you need to support things like NaNs, Inf, etc. It's a good option, but it doesn't work for all datasets.
Re:Things to know about databases by slaymaker1907 on Monday June 27, 2022 @02:45PM (#31898882)
Wow, TIL that NaN isn't valid JSON.
Re:Things to know about databases by qaq on Monday June 27, 2022 @06:49PM (#31901939)
No longer an issue with things like Spanner, CockroachDB etc