Use jsonb instead of TEXT for communities settings
Reasoning: the data is json
- this adds another layer of type checks to make sure the data is sound.
- changing the type for jsonb would allow us to query for specific fields directly via the queries as well as join joins on those instead of having to rely on in sql parsing / fetching the string, then parsing it, then doing stuff with it.
- would allow us to speed some community muting things like beneficiaries using process_hive_post_operation
There are some interesting considerations here: https://heap.io/blog/engineering/when-to-avoid-jsonb-in-a-postgresql-schema
thoughts ?