title: Python insert numpy array into sqlite3 database
body: <p>I'm trying to store a numpy array of about 1000 floats in a sqlite3 database but I keep getting the error "InterfaceError: Error binding parameter 1 - probably unsupported type".</p>
  
  <p>I was under the impression a BLOB data type could be anything but it definitely doesn't work with a numpy array. Here's what I tried:</p>
  
  <pre><code>import sqlite3 as sql
  import numpy as np
  con = sql.connect('test.bd',isolation_level=None)
  cur = con.cursor()
  cur.execute("CREATE TABLE foobar (id INTEGER PRIMARY KEY, array BLOB)")
  cur.execute("INSERT INTO foobar VALUES (?,?)", (None,np.arange(0,500,0.5)))
  con.commit()
  </code></pre>
  
  <p>Is there another module I can use to get the numpy array into the table? Or can I convert the numpy array into another form in Python (like a list or string I can split) that sqlite will accept? Performance isn't a priority. I just want it to work!</p>
  
  <p>Thanks!</p>