Create a SQLite table with R (and manipulate data) You can do all the stuff you want in R and then put the results into SQLite by either creating new data sets or appending the stuff to existing ones. Gives you a lot of flexibility.