safeSrcSQLite: open a dplyr::src to an sqlite database, without the locking...

In MotusWTS/motusServer: Operate a server to process data for http://motus.org

open a dplyr::src to an sqlite database, without the locking issue

Description

By default, dbConnect(RSQLite::SQLite(), ...) connects and immediately tries to set synchronous mode. If the database is locked, this fails before we can use pragma busy_timeout to set a timeout handler. This can be circumvented if synchronous=NULL is added to the call to dbConnect.

Usage

safeSrcSQLite(path, create = FALSE)

Arguments

path	path to database
create	should database be created if it doesn't already exist; default: FALSE

Details

So this function just augments dplyr::src_sqlite with that workaround.

Value

a dplyr::src_sqlite object.

Note

parameters, return value, and semantics are identical to dplyr::src_sqlite except that a locked sqlite database will be handled gracefully with retries.

Author(s)

minor changes from dplyr::src_sqlite by John Brzustowski

See Also

safeSQLiteConnect which this function calls.

MotusWTS/motusServer documentation built on Aug. 8, 2024, 10:23 p.m.