title: Python, SQLite3: How to insert a list of integers into a cell in the table
body: <p>I have a list of integers with >2000 items and so I can't split each value into a column of its own due to the 2000 column limit for SQL:</p>
  
  <pre><code>a = [1, 0, 0, 1, 0,....]
  </code></pre>
  
  <p>and another str value </p>
  
  <pre><code>version = 'dog'
  </code></pre>
  
  <p>How should I be writing the code so that I can input the list, as is, into a single cell, possibly a BLOB type cell?</p>
  
  <pre><code>import sqlite3 as sql
  con = sql.connect('test.db')
  cur = con.cursor()
  cur.execute("CREATE TABLE tablename(Version TEXT, A BLOB)")
  cur.execute("CREATE INDEX Idx_Version ON tablename(Version)")
  
  tuples = tuple([tuple(version, a)])
  cur.execute('INSERT INTO tablename VALUES (?, ?)', tuples)
  </code></pre>
  
  <p>I'm fairly new to SQL and would appreciate any help I can get</p>