write_sqlite: Functions for writing data frames or delimiter-separated...

In rpkgs/curlR: What the Package Does (One Line, Title Case)

Functions for writing data frames or delimiter-separated files to database tables.

Description

Functions for writing data frames or delimiter-separated files to database tables.

Usage

write_sqlite(file, name, value, overwrite = FALSE, append = FALSE)

read_sqlite(file, name)

Arguments

file	file path
name	a character string specifying a table name. SQLite table names are not case sensitive, e.g., table names ABC and abc are considered equal.
value	a data.frame (or coercible to data.frame) object or a file name (character). In the first case, the data.frame is written to a temporary file and then imported to SQLite; when value is a character, it is interpreted as a file name and its contents imported to SQLite.
overwrite	a logical specifying whether to overwrite an existing table or not. Its default is FALSE.
append	a logical specifying whether to append to an existing table in the DBMS. Its default is FALSE.

rpkgs/curlR documentation built on Jan. 30, 2023, 7:26 p.m.