Recursively Merging JSONB in PostgreSQL

1 · Hootsuite · Aug. 27, 2021, 9:01 p.m.
In the Impact team at Hootsuite, we collect dozens of metrics across millions of social media posts. In addition to the metrics pulled from the social platforms themselves, we also provide social attribution of offsite metrics Google Analytics and Adobe Analytics as well as allowing customers to define their own custom metrics. We separate metrics from different sources to avoid naming collisions, that may appear in the backend storage:{ "social": { "likes": 167, "comments": 52 }, "...