Use MySQL JSON field in Laravel
I have been working on an application which needs to store a lot of metadata about user profile, we discussed with the team about using NoSQL database (MongoDB) since its a JSON data set which can be extended and customized for the specific user profile due to its schemaless structure. As we know from MySQL 5.7.8 JSON field types are supported natively, not only we can store data as JSON but we can run the where clauses on it. So we used this fields type instead of using a full NoSQL DB, Let’s see how we can use it in a Laravel app. Continue reading…