title: Is it possible to insert (add) a row to a SQLite db table using dplyr package?
body: <p>I am new to the database connection capabilities of dplyr package, but I am very interested in using it for an SQLite connection. I followed <a href="http://cran.r-project.org/web/packages/dplyr/vignettes/databases.html" rel="noreferrer">this tutorial</a> and created an SQLite database (my_db) </p>
  
  <pre><code>my_db &lt;- src_sqlite("my_db.sqlite3", create = T)
  </code></pre>
  
  <p>and inserted a dataframe (df) as a table (my_table) of this database.</p>
  
  <pre><code>copy_to(my_db,df,"my_table")
  </code></pre>
  
  <p>Now I want to insert new rows in this table. I tried something like this (and yes I must admit it doesn't even look like promising... but I still gave it a try):</p>
  
  <pre><code>collect(build_sql("INSERT INTO my_table VALUES (",newdf,")", con=my_db))
  </code></pre>
  
  <p>Does anyone know if adding rows to an existing sqlite db table is even possible using dplyr? Or how would you deal with this problem? Many thanks in advance!</p>