3 ms·

Can you provide more detail on #9?

• thephyber 9y ago
  Likely moving from `text` or `json` to `jsonb` data type in Postgres: > There are two JSON data types: json and jsonb. They accept almost identical sets of values as input. The major practical difference is one of efficiency. The json data type stores an exact copy of the input text, which processing functions must reparse on each execution; while jsonb data is stored in a decomposed binary format that makes it slightly slower to input due to added conversion overhead, but significantly faster to process, since no reparsing is needed. jsonb also supports indexing, which can be a significant advantage.[1] [1] https://www.postgresql.org/docs/9.4/static/datatype-json.html https://www.postgresql.org/docs/9.4/static/datatype-json.htm...
• mozumder 9y ago
  I convert row data to JSON directly in Postgres query, and send that raw data: SELECT row_to_json(t)::TEXT ...
  • bane 9y ago
    Ahh, perfect, thanks!