News for hackers. Stuff that matters.
Re:Postgres: Boundless `Text` and Back Again by jph on Friday September 10, 2021 @02:24PM (#28485340)
We had similar experiences, and now use varchar 99, varchar 999, varchar 9999. The purpose of the "9" digits is to highlight that it's our plausible guesstimate for "good enough" and can be increased later, rather than any definite unchangeable limit.
Re:Postgres: Boundless `Text` and Back Again by brandur on Friday September 10, 2021 @02:42PM (#28485534)
Nice — I like the idea of the "9" convention. It serves to catch the eye (9s are positively _harsh_ compared to other numbers) and show that it's meant more as a ballpark rather than a precisely chosen number for this specific field.