News for hackers. Stuff that matters.

A comment on JSONB Has Landed in SQLite. Parent comment

Re:JSONB Has Landed in SQLite by piaste on Wednesday December 06, 2023 @06:07AM (#38542462)
There's a gradual approach there, where you start out with a JSONB column, and then as each piece of the data structure stabilizes* you move it out of json fields and into its own columns/tables.

* meaning, when there's enough code that depends on it that changing it would require some planning

[ Parent | on HN ]
Re:JSONB Has Landed in SQLite by jadbox on Wednesday December 06, 2023 @07:56AM (#38543208)
This is the way I build all my apps now. Eventually the jsonb field stores nothing as it all gets moved to defined fields.
[ Parent | on HN ]
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 ]
Re:JSONB Has Landed in SQLite by piaste on Wednesday December 06, 2023 @10:34AM (#38545197)
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.

[ Parent | on HN ]