How to properly store objects in MySQL?

Hi all. Some time I worked with nosql, and liked the ability to store objects. I wanted to find out how good or bad to store objects of type JSON in the database. Sometimes it would be very convenient. Of course as a string. Just how many have seen the listings mysql never met json objects
September 26th 19 at 12:00
3 answers
September 26th 19 at 12:02
Solution
in sql databases so it is not accepted, you will need every time to serialize and deserialize data + no sampling opportunities in such fields as in Monge. That is, either to translate it in flat view either juzat Mongu.
September 26th 19 at 12:04
mysql to json is a string. in Mongo this object. search for takes much more time than the object. ie the car drivable and on the hood
September 26th 19 at 12:06
It is better to provide such data in order in the future you will need to do a search and then will start the carousel.
Will search through the regular season, to normalize the data or write wrapper for poiskovogo engine.

Find more questions by tags JSONMySQLNoSQL