title: Storing JSON data in MYSQL - effects on performance
body: <p>I am building an application and while building my database layer, i have the question should we create a column where i can store multiple items as JSON, or create columns for each item i want to store?</p>
  
  <p>When should we store JSON in the database and when should we not?</p>
  
  <p>What are the advantages and disadvantages of storing JSON in the database?</p>
  
  <p>so an example, for all the columns that don’t need to be searched or indexed, would it be more optimal to store their values in a JSON array, or should I stick to creating normalized data tables where I have multiple columns? </p>