3 ms·
Almost every SQL database has arbitrary limits on text. Personally I find it ludicrously anachronistic.
by Pxtl 9y ago
Almost every SQL database has arbitrary limits on text. Personally I find it ludicrously anachronistic.
- snuxoll 9y agoI 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.