3 ms·
I note pretty explicitly in there that you should pick your own numbers. The idea I was trying to get across is that of order of magnitude tiers so that you do
by brandur 5y ago
I note pretty explicitly in there that you should pick your own numbers.
The idea I was trying to get across is that of order of magnitude tiers so that you don't end up with VARCHARs of a hundred random lengths.
- tyingq 5y agoSure. People just tend to grab stuff from articles written by people with your depth of expertise, so I thought it was worth noting.
- brandur 5y agoYeah, you'd need a longer field for maximum correctness for sure. Reminds me of the RFC 822 regex for validating an email address [1] (clocking in at a full page, although now there are simpler ones you can use). I tend to think that there is a point where you trade off some correctness for pragmatism. It is true that you could have a user with a 250 character email address, but in a lot of years I've never really seen a legitimate one, and the likelihood is that if you do see one then it's someone doing something weird as opposed to a legitimate customer. Email is actually one that you might want to just leave as `TEXT` and make sure you're validating with a package, which is something you might want to do anyway. However, I still think it serves as a useful example because most people have a good feel for about how long an email address is. --- [1] http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html