title: Which is better - execute(INSERT) or executemany(INSERT)
body: <p>Situation: Need to insert quite a bit of data into a SQLite database.</p>
  
  <p>Problem: There are two statements we can use to insert data -</p>
  
  <pre><code>data = [("111", "222", "333"), ("AAA", "BBB", "CCC"), ("XXX", "YYY", "ZZZ")]
  
  #method1
  for item in data:
      cursor.execute("INSERT INTO table(value1, value2, value3) VALUES (?,?,?)", item)
      conn.commit()
  
  #method2
  cursor.execute("INSERT INTO table(value1, value2, value3) VALUES(?,?,?)", data)
  conn.commit()
  </code></pre>
  
  <p>Question: If ignoring speeds, which one is better practice from a programming point of view? And if possible, explain why as well.</p>