Regarding json/text instead of jsonb, https://medium.com/geekculture/postgres-jsonb-usage-and-performance-analysis-cdbd1242a018 https://medium.com/geekculture/

Regarding json/text instead of jsonb, https://medium.com/geekculture/postgres-jsonb-usage-and-performance-analysis-cdbd1242a018 https://medium.com/geekculture/postgres-jsonb-usage-and-perf... Says that jsonb is better suited for my needs as I need it to be indexed for lots of searching. Almost all my queries will have a where clause on this jsonb column.