title: Store JSON in an sqlite field?
body: <p>I'm writing an application that communicates with a web API, which responds with JSON. Currently, I'm translating the JSON objects to Java objects using <a href="http://code.google.com/p/google-gson/" rel="noreferrer">gson</a> (which is awesome, by the way).</p>
  
  <p>Now, I want to store some of these objects in an SQLite database. However, they have lots of properties that would never be used in queries (i.e. I won't be <code>ORDER</code>ing, <code>WHERE</code>ing, or anything like that with those properties), so I feel it's unnecessary to create columns for all of them. What I'm thinking of doing is:</p>
  
  <ul>
  <li>Only have columns for the essential data that will be used when querying the database</li>
  <li>Have one <code>TEXT</code> or <code>BLOB</code> column (which one do you recommend?) that stores the actual JSON, so I can recreate my Java object from it and access all the data.</li>
  </ul>
  
  <p>This would both make my life easier and streamline my code (I would not have to write <em>very</em> different code when dealing with data from the API vs. data from the database).</p>
  
  <p>However, although I see no downsides, it feels a bit fishy.</p>
  
  <p>What kind of trouble do you think I would run into if I use this technique?</p>