title: How to use Rsqlite to save and load data in sqlite
body: <p>I am learning SQLite and I have a big data frame in csv format and I imported into the SQLite.</p>
  
  <pre><code>db &lt;- dbConnect(SQLite(), dbname="myDB.sqlite")
  dbWriteTable(conn = db, name = "myDB", dataframe, overwrite=T,
           row.names=FALSE)
  </code></pre>
  
  <p>after that, I saw there is a myDB.sqlite in my directory but with zero byte. How can I save the dataframe in the sqlite so that I don't need to write table everytime. Thanks.</p>