title: What causes a journal file to be created in SQLite?
body: <p>I started noticing a weird behavior with my SQLite queries for my iPhone application.  Whenever I execute an "INSERT" statement, a journal file is created beside my db file (the exact filename is "userdata.db-journal").</p>
  
  <p>If I understand the docs correctly, this journal file is used by SQLite to be able to rollback in case the operation fails.  But the file stays there after the operation is completed.</p>
  
  <p>I do the classic steps for preparing, binding and executing the query (no checks for return values for simplicity):</p>
  
  <pre><code>sqlite3 *db = NULL;
  sqlite3_open( "userdata.db", &amp;db );
  
  sqlite3_stmt *insertStmt = NULL;
  const char *query = "INSERT INTO table VALUES(?,?)";
  sqlite3_prepare_v2( db, query, -1, &amp;insertStmt, NULL );
  
  sqlite3_bind_int( insertStmt, 1, 0 );
  sqlite3_bind_int( insertStmt, 2, 0 );
  
  sqlite3_step( insertStmt );
  
  sqlite3_reset( insertStmt );
  sqlite3_clear_bindings( insertStmt );
  
  sqlite3_close( db );
  </code></pre>
  
  <p>The journal file is created after the 'sqlite3_step' function is called and stays there until I close the db.  What do I need to do to make it go away?</p>