title: How should I structure this data in my database?
body: <p>So I've got this feature I'm building to allow users to save profile's to a list. Kind of along the lines of a playlist with a name of the list, the user's id and the unique profile data as an array with both the profile id and the state's abbreviation that the profile is in.</p>
  
  <p>More specifically I'm wondering whether or not I should have the list be a single row in a table with these columns: <code>list_id</code>, <code>list_name</code>, <code>user_id</code>, <code>serialized_list</code>. </p>
  
  <p>Where the <code>serialized_list</code> column is an array containing the state key and the profile id. </p>
  
  <p>The other alternative I came up with is something like having two tables. One with the columns: <code>list_id</code>, <code>list_name</code>, <code>user_id</code>. </p>
  
  <p>The other with a row for each list item: <code>row_id</code>, <code>list_id</code>, <code>state</code>, <code>profile_id</code>.</p>
  
  <p>I'm kind of a database n00b, so I'm not entirely sure what considerations should even be made, but I guess I'm asking which of these (or another alternative) would be better with respect to speed and maintainability?</p>