title: SQLite VARCHAR default size
body: <p>In SQLite, when I say:</p>
  
  <pre><code>CREATE TABLE my_table 
  (
      my_column VARCHAR 
  );
  </code></pre>
  
  <p>without specifying the size of <code>VARCHAR</code>, what is the default size that is used? </p>
  
  <p>I can't seem to find it at sqlite.org or figure out from my database file.</p>
  
  <p>I know that SQLite doesn't enforce size when trying to stuff <code>varchar(500)</code> into <code>varchar(30)</code>, but are there tradeoffs in initial size specification and what are best practices?</p>