Use jsonb, not json

Use jsonb, not json | BeforeMerge Rules | BeforeMerge

Why this matters

json keeps the exact input text and reparses it on every operation; it can't be indexed for containment. jsonb stores a decomposed binary form, supports GIN indexes and @>/? operators, and deduplicates keys. Use json only when you must preserve whitespace and key order verbatim.

-- bad
attributes json
 
-- good
attributes jsonb
CREATE INDEX ON products USING gin (attributes);

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters