Answer the question
In order to leave comments, you need to log in
[[+content_image]]
What is the best way to store this JSON in the database?
I have an online test whose questions are serialized in JSON. The output is something like:
[[{"QID":1,"AID":1},{"SubAID":[]}],[{"QID":2,"AID":1},{"SubAID":[]}],[{"QID":3,"
AID":1},{"SubAID":[]}],{"MaxArea":"90","MinArea":"10"}]
Answer the question
In order to leave comments, you need to log in
You can store it in this form, but if you do not conduct a search or some kind of manipulation on them.
Json type is in postgresql with indexing.
www.postgresql.org/docs/9.4/static/datatype-json.html
or you can use Mongo document-oriented database
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question