Better documentation about data import and export

r-dbi / DBI

A database interface (DBI) definition for communication between R and RDBMSs

https://dbi.r-dbi.org

GNU Lesser General Public License v2.1

296 stars 75 forks source link

Open krlmlr opened 6 years ago

krlmlr commented 6 years ago

How to get large data into and out of a database?

It's difficult to standardize fast import (https://github.com/r-dbi/DBI/issues/62), but we can document how to do it with dbExecute(). The document

would point to arkdb and perhaps other solutions
would show, for several DBMS, how to do the importing based on a given CSV file after the file is on the server
- including pointers to DBMS documentation for the SQL syntax

tylerlittlefield commented 3 years ago

+1 on this