Fork me on GitHub
#sql
<
2018-10-24
>
maleghast09:10:12

Hello 🙂 Does anyone here have any experience trying to use Transit with JSONB under PostgreSQL

val_waeselynck17:10:32

You don't win anything by encoding in JSONB vs a CLOB - because Transit will make you lose the possibility of actually querying the JSONB from SQL

maleghast09:10:49

(I realise that this rather pushes the boundaries of what is SQL, but this seemed like the right channel to ask in, absent a #postgres channel)

mpenet12:10:28

we use jsonb, but if you need to rely on indexing/querying in these fields that might be tricky with transit

mpenet12:10:38

since it will rename keys in particular

mpenet12:10:28

I guess you can run with caching disabled (json verbose?)