write_qst: Write a data.frame to an SQLite database

In torfason/qst: Store Tables in SQL Database

Write a data.frame to an SQLite database

Description

This function writes a data.frame to an SQLite database. The database has one table, named data, containing the data. Additional tables, prefixed with meta_, may be added in the future to support additional data types not supported in a native way by SQLite.

Usage

write_qst(x, path, ..., unique_indexes = NULL, indexes = NULL)

Arguments

x	A data.frame to be written to file. Supported column types are integer, numeric and character.
path	The path to write to.
...	Other parameters passed to methods.
unique_indexes	A list of character vectors. Each element of the list will create a new unique index over the specified column(s). Duplicate rows will result in failure.
indexes	A list of character vectors. Each element of the list will create a new index.

Value

The original data frame passed in x

Examples

# Write the cars data set to a file
cars_db <- tempfile()
write_qst(cars, cars_db, indexes=list("speed"))
unlink(cars_db)

torfason/qst documentation built on Oct. 3, 2023, 11:05 p.m.