News for hackers. Stuff that matters.

A comment on Old, Good Database Design. Parent comment

Re:Old, Good Database Design by simnim on Monday September 14, 2020 @03:28PM (#24474100)
What's wrong with TEXT type for postgres, mysql, etc? In Postgres you don't need to declare a length for varchar either.
[ Parent | on HN ]
Re:Old, Good Database Design by dkersten on Tuesday September 15, 2020 @12:03PM (#24482829)
Yeah, in fact, Postgres encourages the use of TEXT over VARCHAR. The documentation even states:

There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column.

https://www.postgresql.org/docs/current/datatype-character.h...

[ Parent | on HN ]