Document situations when jsonb is appropriate to use (and when it's not)
PostgreSQL has a jsonb
datatype and corresponding operators. This means, we can store JSON and query its contents from the database. This has various associated problems and is not meant to replace proper relational modeling (normalization etc.).
In this issue, we document when choosing jsonb
is appropriate. We have a couple of examples where this is being used and where it makes sense to use it. It'll be useful to find scenarios where it's not appropriate to use and explain why and what the alternative is.
This is a follow-up to #219134 (comment 350176395).
Edited by Andreas Brandl