title: Python SQLite - How to configure it to use another temporary directory
body: <p>I have Python code that uses SQLite. However, when running on a large database (7 GB) I get the following error:</p>
  
  <pre><code>sqlite3.OperationalError: database or disk is full
  </code></pre>
  
  <p>I understand it is related to the temporary directory when it creates the tmp files.</p>
  
  <p>How can I configure the Python SQLite to use another directory (one that I will set it up with enough storage for the tmp files).</p>