What is the best way to store a pretty large JSON object in MySQL

Question

I'm building a Laravel app the core features are driven with rather large JSON objects. (the largest ones are between 1000-1500 lines).

I know there are better data base choices than MySQL for storing files and blocks of data, but for various reasons I will need to use MySQL for the application.

So my question is, how to I store my JSON objects most effective in MySQL? I will not need to do any queries on the column that holds the data, there will be other columns for identifying it. Something like this:

id, title, created-at, updated-at, JSON-blobthingy

Any ideas?

Answer 1

You could compress the data before inserting it if you don't need it searchable. I'm using the 'zlib' library for that

Answer 2

• You could use the JSON data type if you have MySQL version 5.7.8 or above.
• You could store the JSON file on the server, and simply reference its location via MySQL.
• You could use also one of the TEXT types.

Answer 3

The best answer i can give is to use MySQL 5.7. On this version the new column type JSON are supported. Which handles large JSON very well (obviously).

https://dev.mysql.com/doc/refman/5.7/en/json.html