Benefit of TEXT with CHECK over VARCHAR(X) in PostgreSQL. Brandur suggests using email TEXT CHECK (char_length(email) <= 255)
to define a column with a length limit in PostgreSQL over VARCHAR(255)
because TEXT
and VARCHAR
are equally performant but a CHECK
length can be changed later on without locking the table, whereas a VARCHAR
requires an ALTER TABLE
with an exclusive lock.
Recent articles
- Notes on the new Claude analysis JavaScript code execution tool - 24th October 2024
- Initial explorations of Anthropic's new Computer Use capability - 22nd October 2024
- Everything I built with Claude Artifacts this week - 21st October 2024