Storing JSON data into MySQL database

Question

I am having a JSON file with multiple and multi-level data. Now I want to store this data into MySQL database. I searched many links but didn't suit to my data and none of it helped me.

My JSON data: http://fiddle.jshell.net/4QNYk/

I am new to JSON and Java. Please help me out.

I dont think there's anything wrong with storing it as text? — filype
– filype, Commented May 30, 2014 at 9:16
Use Postgres :) It has json data type and is able to both store and query json data effectively. wiki.postgresql.org/wiki/… (more effectively than MongoDB). — Ashalynd
– Ashalynd, Commented May 30, 2014 at 9:18
if u just want to store as it is and retrieve JSON text as it is on query then datatype of TEXT will do !! if u want to query on this JSON data in future then use MongoDB Database, — GaneshP
– GaneshP, Commented May 30, 2014 at 9:19
Could you please help me how to store it as a text in database. — user3189916
– user3189916, Commented May 30, 2014 at 9:28

frlan · Accepted Answer · 2014-05-30 09:20:28Z

2

Depending on what you want to do later with the JSON, storing it as a normal text seems to be the best idea on MySQL at the moment. Other DBMS like PostgreSQL are having some datatype for JSON -- but assuming you having you application magic at Java-side and not wanting to start fuzzying around with the JSON on database layer, text is totally fine.

Of course, if you want to search inside the JSON it's maybe not the best way of storing them. But as mentioned in the comments, there are other DBMS are better choice.

answered May 30, 2014 at 9:20

frlan

7,2953 gold badges36 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3189916 Over a year ago

hi @frlan Thanks for the quick response. Can you please help me how to store it as a normal text in MySQL.

frlan Over a year ago

No clue about Java at this point. Create a text field on you MySQL and ensure you JSON object is transfered to varchar/string/* before sending to database.

Collectives™ on Stack Overflow

Storing JSON data into MySQL database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related