title: Writing blob from SQLite to file using Python
body: <p>A clueless Python newbie needs help. I muddled through creating a simple script that inserts a binary file into a blog field in a SQLite database:</p>
  
  <pre><code>import sqlite3
  conn = sqlite3.connect('database.db')
  cursor = conn.cursor()
  input_note = raw_input(_(u'Note: '))
      input_type = 'A'
      input_file = raw_input(_(u'Enter path to file: '))
          with open(input_file, 'rb') as f:
              ablob = f.read()
              f.close()
          cursor.execute("INSERT INTO notes (note, file) VALUES('"+input_note+"', ?)", [buffer(ablob)])
          conn.commit()
      conn.close()
  </code></pre>
  
  <p>Now I need to write a script that grabs the contents of the blob field of a specific record and writes the binary blob to a file. In my case, I use the SQLite database to store .odt documents, so I want to grab and save them as .odt files. How do I go about that? Thanks!</p>