vendredi 4 décembre 2015

Is there an "executemany" analog for R and RSQLite?

Question:
Is there a way to insert many rows (under 20k) into an SQLite3 table using r?

More work:
I have looked at similar answers, but they do not seem to speak to this:

There is a "c command" but that is not "R".

The SQLite3 help itself doesn't seem to give a way forward:

Python has "execute many" which makes large inserts operate quickly. Is there an "R" analog in RSQLite or DBI? Is there a different library that I should use?

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire