sqliteRemote: Convenience helper for opening remote SQLite databases over...

In RSQLite: SQLite Interface for R

Convenience helper for opening remote SQLite databases over HTTP/HTTPS

Description

lifecycle::badge("experimental")

Constructs a URI filename and sets the appropriate VFS and immutable flags. Requires the optional http extension to be available; see sqliteHasHttpVFS().

Usage

sqliteRemote(url, immutable = TRUE, ...)

Arguments

url	Remote HTTP/HTTPS URL to a SQLite database file.
immutable	Logical, append immutable=1 to the URI.
...	Passed through to DBI::dbConnect().

Value

A SQLiteConnection object.

Examples

if (sqliteHasHttpVFS()) {
  con <- sqliteRemote("https://example.org/db.sqlite")
  dbGetQuery(con, "SELECT name FROM sqlite_master WHERE type='table'")
  dbDisconnect(con)
}

RSQLite documentation built on July 1, 2026, 1:06 a.m.