· maintainability

←Previous Next→

prefer-text-over-varchar

VARCHAR(n) — use TEXT (+ CHECK length if needed).

SARJ104 Rule source Tests Catalog JSON

Why

PostgreSQL gives VARCHAR(n) no storage or performance advantage, while its length cap obscures a business constraint.

Fix

Use TEXT and express a real maximum length with an explicit CHECK constraint when needed.

Examples

Before — flagged Length-limited VARCHAR column

migrations/001_users.sql

CREATE TABLE users (name VARCHAR(255) NOT NULL);

After — preferred Text column with an explicit length constraint

migrations/001_users.sql

CREATE TABLE users (
  name TEXT NOT NULL CHECK (char_length(name) <= 255)
);