virta: Virtual tables for RSQLite

Description Available virtual tables Author(s) Examples

Description

This package uses SQLite's loadable extension feature to provide virtual tables.

Available virtual tables

You can enable all of the following virtual tables by calling the init_virtualtables function on an RSQLite database connection object.

Author(s)

Reijo Sund <reijo.sund@helsinki.fi> Maintainer: Reijo Sund <reijo.sund@helsinki.fi>

Examples

1
2
3
4
5
6
## basic usage looks like this
db <- dbConnect(SQLite(), dbname = ":memory:")
init_virtualtables(db)

## now you can use virtual tables in SQL queries.
dbDisconnect(db)

virta documentation built on May 2, 2019, 5:18 p.m.

Related to virta in virta...