write.mdb: write.mdb

In mskilab/skidb: Collection of R functions for accessing and parsing flat file dumps of common databases and external software used by @mskilab.

write.mdb

Description

Writes data.table (or anything coercible to one) to MonetDB. If data.table has key will create an index. Additional indices may be specified. If MonetDB file already exists then will try to append to it (assuming same schema). Stored table will have altered column names (changed to lowercase, all non word characters replaced by underscores, and a col_ prefix added) to maximize compatibility with SQL.

The written database can be later accessed using mdb(fn, expression) or mdb(con, expression) where con is the output of this function (write.mdb) or con = mdb(fn).

Usage

write.mdb(
  dt,
  fn = tempdir(),
  name = "data_table",
  max.varchar = 256,
  index_on = NULL,
  overwrite = TRUE,
  verbose = TRUE
)

Arguments

dt	(keyed) data.table
fn	path to write to

Value

DBI handle to MDB ! @param index_on list of character vectors specifying additional keys (in addition to key(dt))

Author(s)

Marcin Imielinski

mskilab/skidb documentation built on Feb. 6, 2023, 2:49 a.m.