title: Figuring out my sqlite version
body: <p>I wanted to check which version of sqlite I had, which has become way more confusing than I expected. To start fresh, I created a new conda environment with:</p>
  
  <pre><code>conda create --name my_env_name python=3.6 sqlite hdf5 pandas
  </code></pre>
  
  <p>The shell message said it would install <code>sqlite: 3.13.0-1</code> in the new environment, along with a few other packages.</p>
  
  <p>Then, after activating that new conda environment, I immediately ran <code>pip freeze</code>, but the list of packages I see does not include any entry for <code>sqlite</code>.</p>
  
  <p>Finally, I just enter <code>python</code> from the terminal (in this conda env) to enter a system python in my shell. The opening message says python version 3.6.1, confirming I'm in that newly created environment. But then </p>
  
  <pre><code>import sqlite3
  sqlite3.version
  </code></pre>
  
  <p>outputs <code>'2.6.0'</code></p>
  
  <p>What's going on? Do I have sqlite3 version 3.13 installed or 2.6? If my sqlite3 version is 2.6, how do I get something newer? That would be pretty old.</p>