title: Python, Sqlite not saving results on the file
body: <p>I have this code in Python:</p>
  
  <pre><code>conn = sqlite3.connect("people.db")
  cursor = conn.cursor()
  
  sql = 'create table if not exists people (id integer, name VARCHAR(255))'
  cursor.execute(sql)
  conn.commit()
  
  sql = 'insert into people VALUES (3, "test")'
  cursor.execute(sql)
  conn.commit()   
  
  sql = 'insert into people VALUES (5, "test")'
  cursor.execute(sql)
  conn.commit()  
  
  print 'Printing all inserted'
  cursor.execute("select * from people")
  for row in cursor.fetchall():
      print row
  
  cursor.close()
  conn.close()
  </code></pre>
  
  <p>But seems is never saving to the database, there is always the same elements on the db as if it was not saving anything.</p>
  
  <p>On the other side If I try to access the db file via sqlite it I got this error:</p>
  
  <pre><code>Unable to open database "people.db": file is encrypted or is not a database
  </code></pre>
  
  <p>I found on some other answers to use <code>conn.commit</code> instead of <code>conn.commit()</code> but is not changing the results.</p>
  
  <p>Any idea?</p>