Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (2.3.10) of this package.
Take me there.
RSQLite (version 0.2-1)
SQLite interface for R
Description
Database Interface R driver for SQLite This package embeds the SQLite database engine in R.
Copy Link
Link to current version
Version
Version
2.3.10
2.3.9
2.3.8
2.3.7
2.3.6
2.3.5
2.3.4
2.3.3
2.3.2
2.3.1
2.3.0
2.2.20
2.2.19
2.2.18
2.2.17
2.2.16
2.2.15
2.2.14
2.2.13
2.2.12
2.2.11
2.2.10
2.2.9
2.2.8
2.2.7
2.2.6
2.2.5
2.2.4
2.2.3
2.2.2
2.2.1
2.2.0
2.1.5
2.1.4
2.1.3
2.1.2
2.1.1
2.1.0
2.0
1.1-2
1.1-1
1.1
1.0.0
0.11.4
0.11.3
0.11.2
0.11.1
0.11.0
0.10.0
0.9-4
0.9-3
0.9-2
0.9-1
0.9-0
0.8-4
0.8-3
0.8-2
0.8-1
0.8-0
0.7-3
0.7-2
0.7-1
0.7-0
0.6-9
0.6-8
0.6-7
0.6-4
0.6-3
0.6-2
0.6-0
0.5-6
0.5-4
0.5-3
0.5-2
0.5-1
0.4-20
0.4-19
0.4-18
0.4-15
0.4-13
0.4-9
0.4-4
0.4-1
0.4-0
0.3-5
0.3-4
0.3-3
0.3-2
0.3-1
0.3-0
0.2-1
Install
install.packages('RSQLite')
Monthly Downloads
150,030
Version
0.2-1
License
LGPL version 2 or newer
Maintainer
David James
Last Published
May 2nd, 2025
Functions in RSQLite (0.2-1)
Search all functions
metaData
R/S database interface meta-data
methods.SQLite
Support SQLite methods
describe
Describe an object through its meta-data
setDataMappings
Set data mappings between an RDBMS and R/S
getNumRows
Get number of rows/columns of an SQL table
dbManager
Instantiate a database manager
getTable
Convenience functions for Importing/Exporting RDBMS tables into R/S.
make.SQL.names
Make R/S identifiers into legal SQL identifiers.
load
Load/unload the client part of a database interface
isIdCurrent
Check whether a database handle object is valid or not
commit
RDBMS Transaction Management
SQLDataType
Determine the SQL Data Type of an R/S object
S4R
R compatibility with S version 4/Splus5+ support functions
dbExecStatement
Execute an SQL statement on a given database connection
dbConnect
Create a connection to a DBMS
getManager
Get a database manager object from a derived handle
fetch
Fetch records from a previously executed SELECT statement
quickSQL
Quick SQL Execution
isSQLKeyword
Is a name an SQL keyword?
SQLite
Instantiate the SQLite engine from the current R/S session.
callProc
Call an SQL stored procedure
dbApply
Apply R/S functions to remote groups of DBMS rows (experimental)
dbExec
Execute an SQL script on a given database connection
supportObjects
Support objects for RS-DBI