Purpose and implementation of json field type in laravel schema builder

Question

What is the purpose $table->json('options');as the type of the database field of the laravel database database. I was looking for a hard search, but could not get any relevant information about it. Please indicate one purpose of the state list with an example.

Answer 1

Some database engines - PostgreSQL, which is the main example - have JSON-friendly data types (which MySQL currently lacks - it will simply store as the data type TEXTthere). This can be convenient for working with data (for example, the example optionsthat you are quoting), which can contain a large amount of uncharted or loosely structured data.

• http://www.postgresql.org/docs/9.4/static/datatype-json.html
• http://www.postgresql.org/docs/9.3/static/functions-json.html

Instead of having 100+ columns for a bunch of on / off parameters for the model, you can save them in a JSON object in the database.

Answer 2

This is sometimes useful, even if MySQL stores data as JSON.

, , . , ? , JSON .