Prefer text over varchar(n)

Prefer text over varchar(n) | BeforeMerge Rules | BeforeMerge

Why this matters

In PostgreSQL text and varchar(n) share the same storage and performance; the only difference is the length check. A hardcoded varchar(n) cap is hard to change later (lock + validation) and rarely reflects a real domain rule. Prefer text, and enforce genuine limits with an explicit CHECK.

-- bad
name varchar(50)
 
-- good
name text CHECK (char_length(name) <= 50)

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters