News for hackers. Stuff that matters.
Re:Show HN: Caffeine – Minimum viable back end for prototyping by mccolin on Tuesday November 16, 2021 @09:31AM (#29240928)
Correct. The json data type is less performant and stores the data more or less as lightly indexed text. jsonb optimizes the storage format and allows for more JSON operations, such as extracting individual keys.

For this product, if the super-generic API doesn't offer/require a need to do complex operations, though, json may be adequate to lookup items by id and present them.

There are no comments on this comment yet.