Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by bob1029 on Sunday September 05, 2021 @08:47AM
(#28423956)
For us, a "proper" column is usually something we want to index against. Things like timestamps, user ids, etc. Anything that would be useful for top-level management of whatever has the json tacked onto it.
[ Parent
| on HN ]
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by conradev on Sunday September 05, 2021 @10:14AM
(#28424501)
You could pull those out and index them using generated columns, though.
That can make things a lot easier on the application side, where the code just needs to insert the JSON blob
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by jrochkind1 on Sunday September 05, 2021 @10:31AM
(#28424612)
You don't even have to "pull those out and index them using generated columns" to index with postgres jsonb, although it's a bit more confusing to figure out the proper index and make sure your queries hit it, jsonb data is indexable on it's own.