Skip to contents

Create a lazy source for a SQLite table

Source: R/datatable-source-sqlite.R
db_table_source.Rd

This optional adapter uses bounded LIMIT/OFFSET queries and parameterized filter values. It supports equals, contains, range, and missing table_filter() filters and sorting by quoted column names. Arbitrary queries and other SQL dialects are intentionally outside this adapter; custom table_source() callbacks can implement driver-specific pagination.

Usage

db_table_source(connection, table, owned = FALSE)

Arguments

connection

An open RSQLite connection, or a db_connection() wrapper of one.

table

A table name or DBI::Id.

owned

If TRUE, source$close() disconnects this connection. The default leaves connection ownership with the caller.

Value

An experimental table source accepted by data_table().