A DBI Extention Package toExplore useful new generics. Speciffically to introduce dbUpdateTable. dbUpdateTable implements a generally applicable method to update selected columns of a database table by values in a data-frame. The data-frame is written to a temporary table in the database and the update is performed using an UPDATE table, inner join. This join method generally very fast. Using R to prepare the date for updating into the table is also very paowerful.
Useful links:
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.