![]() Json/jsonb is just another "data type" for Postgres columns. They are a useful tool, but most of the benefits of a relational database come from the ability to query and join structured data, and the referential integrity that brings. Instead, you could store the payload as a jsonb object in a single column.ĭon't go overboard with json/jsonb columns. For example, if you wanted to store responses for various webhooks, you might not know the format of the response when creating the table. Generally you should use a jsonb column when you have data that is unstructured or has a variable schema. While this makes it slightly slower to input due to added conversion overhead, it is significantly faster to process, since no reparsing is needed. jsonb stores database in a decomposed binary format. ![]() Database functions must reparse the content on each execution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |