title: work around for python scripts which access sqlite database on Heroku
body: <p>I have a very small, simple sqlite database, and several python scripts to access the database.  I want to run these scripts using Heroku, but it seems that Heroku doesn't support <code>sqlite3</code>.</p>
  
  <p>I have tried adding the line</p>
  
  <pre><code>sqlite3==3.0
  </code></pre>
  
  <p>to my <code>requirements.txt</code> file before running</p>
  
  <pre><code>pip install -r requirements.txt
  </code></pre>
  
  <p>but it says it can't find <code>sqlite3</code>.</p>
  
  <p>What is the easiest, most lightweight way to be able to query my sqlite database on Heroku?</p>
  
  <ol>
  <li>Do I need to convert the sqlite database?  If so, how do I do that?</li>
  <li><p>If I'm not allowed to <code>import sqlite</code> in python on Heroku, what is the alternative package I need to use and how do I change my python code which calls execute statements like </p>
  
  <p>SELECT * FROM table</p></li>
  </ol>
  
  <p>I find that the Heroku <a href="https://devcenter.heroku.com/articles/database" rel="nofollow">documentation</a> assumes that the user has a bit more expertise.  Also, it seems from other stackoverflow, blog posts that folks where somehow able to use <code>sqlite3</code> with Ruby.</p>