title: SQLite3 installation and usage in Ubuntu
body: <p>I seek some clarifications regarding the installation and usage of <code>SQLite3</code> in Ubuntu (e.g. Ubuntu Lucid). It seems to me that, to install it, one just need to download the precompiled binary from here: <a href="http://www.sqlite.org/download.html" rel="nofollow">http://www.sqlite.org/download.html</a>, save it in some directory, and <strong>use that binary</strong> to create a <code>.db</code> file. Then that's it. Of course, for real-world usage, I'm mostly reading/writing from/to it through its Python driver in my code: <a href="https://pypi.python.org/pypi/pysqlite" rel="nofollow">https://pypi.python.org/pypi/pysqlite</a>.</p>
  
  <p>A few questions:</p>
  
  <ol>
  <li><p>Is the above a correct way of installing SQLite3 in Linux systems?</p></li>
  <li><p>I also see two packages installed on my system: <code>libsqlite3-0</code> and <code>libsqlite3-dev</code>, which are of different version from the latest binary. Are these the ones that actually get used when I read/write from/to the <code>.db</code> file through the Python driver?</p></li>
  <li><p>What is a correct way of upgrading SQLite3? Do I just grab the latest precompiled binary from sqlite.org, and start using it to access the existing <code>.db</code> file?</p></li>
  </ol>