4 ms·
Besides what others are saying here, data integrity is a lot easier with a relational database if your data is heavily relational. I have managed systems with <
by DanielHB 3y ago
Besides what others are saying here, data integrity is a lot easier with a relational database if your data is heavily relational. I have managed systems with <1gb of data that would have been much harder to build without primary and foreign keys
About data types, what limitations are you referring to? jsonb is well supported in many dbs and throwing random large binary blobs in the middle with your normal data is a bad idea with or without a relational database.
I can see the appeal to replace noSQL solutions though, a lot of people are using S3 (and other storage solutions) as a makeshift database lately
- bun_terminator 3y agoI think my wtf moment was that you can't have real variable length strings. And I'm pretty pampered by c++ highly nuanced numeric types with varying sizes and signed/unsigned.
- DanielHB 3y agofair enough, relational DBs are optimised for querying so you often see tradeoffs like this.
- garfij 3y agoOther people have said it in this thread, but I think your experience is being severely clouded by Oracle. Postgres, MySql, and all have the `TEXT` datatype which are variable length (though with some upper bound)