News for hackers. Stuff that matters.

A comment on PostgreSQL is enough. Parent comment

Re:PostgreSQL is enough by DanielHB on Tuesday February 06, 2024 @02:18PM (#39279132)
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

[ Parent | on HN ]
Re:PostgreSQL is enough by bun_terminator on Tuesday February 06, 2024 @02:21PM (#39279184)
I 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.
[ Parent | on HN ]
Re:PostgreSQL is enough by DanielHB on Wednesday February 07, 2024 @05:59AM (#39287037)
fair enough, relational DBs are optimised for querying so you often see tradeoffs like this.
[ Parent | on HN ]
Re:PostgreSQL is enough by garfij on Thursday February 08, 2024 @06:12PM (#39309089)
Other 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)
[ Parent | on HN ]