title: Simulating variable column names in sqlite
body: <p>I want to store entries (a set of key=>value pairs) in a database, but the keys vary from entry to entry.</p>
  
  <p>I thought of storing with two tables, (1) of the keys for each entry and (2) of the values of specific keys for each entry, where entries share a common id field in both tables, but I am not sure how to pull entries as a key=>value pairs in sql with this sort of configuration.</p>
  
  <p>Is there a better method?  If this is not possible in sqlite, is it possible in mysql?  Thanks!</p>