Objective-C: Add JSON response to SQLite DB

Question

I am getting a JSON response and would like to add it to an SQLite db. The results come back as an array and in each array there will be about 30 keys with values. What would be the most efficient approach to adding all those to my table? The keys coming from the JSON would be the columns in the sqlite db.

Would it be best to do a for loop on each array item then another for loop in side to get the values and add it to a string then add them to the database that way? Or is there a better approach using FMDB to add a JSON response directly to the database if the json keys match the database table columns?

Answer 1

I ended up doing a loop and getting the json keys and using those as the columns.