News for hackers. Stuff that matters.
Re:Giving you more characters by Pxtl on Tuesday September 26, 2017 @10:22PM (#15344397)
Almost every SQL database has arbitrary limits on text. Personally I find it ludicrously anachronistic.
Re:Giving you more characters by snuxoll on Tuesday September 26, 2017 @10:30PM (#15344429)
I mean, there’s good reasons to limit the size of fields in database tuples - relational databases are made for storing small to medium amounts of normalized data, you can abuse them (and I have, storing a couple million 60-200K PDF’s in a Postgres database at work) but you can shoot yourself in the foot by creating tons of 60% full pages and the stupid amount of extra IOPS those wide columns create.

Still, not allowing unrestricted text and binary columns is still silly, so I agree for the most part - but you still need to know what you’re getting yourself into when you start making wide tables.