Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

If you, for whatever obscure reason, need to preserve whitespace and key ordering, that is you want something that is effectively just a text column, then you should use JSON over JSONB.

I can't think of any case at all, no matter how contrived, where you'd want to use the non-B versions of the JSON aggregate functions though.



The non-B JSON can take up less space on disk and less write time complexity.


I wonder if its just used in a query like that if the generated data structure is only in memory anyway and then serialized to JSON to send to the client. I.e. JSON VS JSONB would not make any difference?




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: