Re:Old, Good Database Design
by Zippogriff on Monday September 14, 2020 @03:29PM
(#24474116)
There's always a limit. You either define and manage it yourself or it'll be done for you when some part of your system breaks. In the end if you actually need performance and reliability everything will have a bound (if not fixed) size and larger data will be processed as a stream, anyway.
[ Parent
| on HN ]
Re:Old, Good Database Design
by colanderman on Monday September 14, 2020 @04:21PM
(#24474673)
Postgres tip: define columns as TEXT, but with a CHECK constraint that the length is what you expect. This avoids the problem with varchar(...) that views inherit the underlying column types (including the length specifier), and prevent you from changing the maximum length in the table unless you drop and recreate the view. (There are ways around this through system tables but they are wholly unwieldy.)