Question··Adi Wijaya·
4
·513 views·3 comments

JSONB vs separate columns for sparse fields?

Designing a CRM-like app where contacts have ~50 possible fields but most rows fill 5-10. Should I use one JSONB column or 50 nullable columns?

3 Comments

Log in to join the conversation

Go to forum & log in

Loading comments…

JSONB vs separate columns for sparse fields? — WoWSQL Community