Re:JSONB Has Landed in SQLite
by rav on Wednesday December 06, 2023 @10:03AM
(#38544723)
Alternatively, keep it in the JSON/JSONB column until you need to search/filter/query on it, in which case you pull it out into a column.
[ Parent
| on HN ]
Even that may not be immediately necessary. I don't think SQLite has it yet, but Postgres can build partial indexes on JSONB fields.
Though most of the time, in that situation, I would pull it out.