RSQLite 2.0 (2017-06-18)

API changes

Bug fixes



RSQLite 1.1-2 (2017-01-07)

RSQLite 1.1-1 (2016-12-10)

RSQLite 1.1 (2016-11-25)

Bundled SQLite

Breaking changes

New features

Deprecated functions

Compatibility fixes




Version 1.0.0

New features

Changes to objects

Deprecated and removed functions

Version 0.11.6

Version 0.11.5

Version 0.11.4

Version 0.11.3

Version 0.11.2

Version 0.11.1

Version 0.11.0

Version 0.10.0

Version 0.9-5

Version 0.9-4

Version 0.9-3

Version 0.9-2

Version 0.9-1

Version 0.9-0

Version 0.8-4

Version 0.8-3

Version 0.8-2

Version 0.8-1

Version 0.8-0

flags: provides additional control over connetion details. For convenience, you can specify one of SQLITE_RWC (default), SQLITE_RW, or SQLITE_RO to obtain a connection in read/write/create, read/write, or read only mode, respectively. See for details. vfs: controls the virtual filesystem used by SQLite. The default, NULL, lets SQLite select the appropriate vfs for the system. You can specify one of “unix-posix”, “unix-afp”, “unix-flock”, “unix-dotfile”, or “unix-none”. For details, see This functionality is only fully available on OSX. On non-OSX Unix, you can use unix-dotfile and unix-none. None of these modules are available on Windows where a non-NULL values of the vfs argument will be ignored with a warning.

Version 0.7-3

Version 0.7-2

Version 0.7-1

Version 0.4-12

Version 0.4-11

dbGetPreparedQuery(con, “INSERT INTO table1 VALUES (:col1)”, data.frame(col1=c(1, 2)) )

Each bind variable in the query has to be bound only once, either via named or positional parameters. If it is not bound or is bound more than once (due to a mix or positional/named parameters) an error is thrown. Any extra columns in the data frame are ignored.

If you are having a lot of string parameters, use stringsAsFactors=FALSE when creating the data.frame instance. You can also use I().

Version 0.4-9

Version 0.4-4

Version 0.4-1

Version 0.4-0

Version 0.3-5

Version 0.3-4

Version 0.3-3

Version 0.3-2

(there’s also a binary

Version 0.3-1

Version 0.2-1

Version 0.1-1