db_table_source: Create a lazy source for a SQLite table

In termr: Modern Reactive Terminal Applications with Data Workflows

Create a lazy source for a SQLite table

Description

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().

termr documentation built on Oct. 21, 2026, 5:13 p.m.