Store json in db

nimasdj · August 6, 2015, 5:22am

what is the best table structure in mysql to store json? ‘text’ or ‘blob’ or what?

s_molinari · August 6, 2015, 7:11am

Since JSON is text, a text field would be suitable.

Scott

StarLion · August 6, 2015, 3:58pm

Answer: A non-relational database.

s_molinari · August 6, 2015, 5:36pm

PostgreSQL supports the JSON data type natively too.

Scott

system · November 6, 2015, 12:37am

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.