RSQLite: SQLite Interface for R

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations. Optionally, when libcurl is available at build time, an experimental HTTP/HTTPS virtual file system (VFS) can be enabled to allow read-only access to remote immutable SQLite database files via URIs.

Version:	3.53.3
Depends:	R (≥ 3.1.0)
Imports:	bit64, blob (≥ 1.2.0), DBI (≥ 1.2.0), memoise, methods, pkgconfig, rlang
LinkingTo:	cpp11 (≥ 0.4.0)
Suggests:	callr, cli, DBItest (≥ 1.8.0), decor, gert, gh, hms, httpuv, knitr, magrittr, rmarkdown, rvest, testthat (≥ 3.0.0), withr, xml2
Published:	2026-06-30
DOI:	10.32614/CRAN.package.RSQLite
Author:	Kirill Müller [aut, cre], Hadley Wickham [aut], David A. James [aut], Seth Falcon [aut], D. Richard Hipp [ctb] (for the included SQLite sources), Dan Kennedy [ctb] (for the included SQLite sources), Joe Mistachkin [ctb] (for the included SQLite sources), SQLite Authors [ctb] (for the included SQLite sources), Liam Healy [ctb] (for the included SQLite sources), R Consortium [fnd], RStudio [cph]
Maintainer:	Kirill Müller <kirill at cynkra.com>
BugReports:	https://github.com/r-dbi/RSQLite/issues
License:	LGPL-2.1 | LGPL-3 [expanded from: LGPL (≥ 2.1)]
URL:	https://rsqlite.r-dbi.org, https://github.com/r-dbi/RSQLite
NeedsCompilation:	yes
Materials:	README, NEWS
In views:	Databases
CRAN checks:	RSQLite results

Documentation:

Reference manual:	RSQLite.html , RSQLite.pdf
Vignettes:	RSQLite (source, R code)

Downloads:

Package source:	RSQLite_3.53.3.tar.gz
Windows binaries:	r-devel: RSQLite_3.53.3.zip, r-release: RSQLite_3.53.3.zip, r-oldrel: RSQLite_3.53.3.zip
macOS binaries:	r-release (arm64): RSQLite_3.53.3.tgz, r-oldrel (arm64): RSQLite_3.53.3.tgz, r-release (x86_64): RSQLite_3.53.3.tgz, r-oldrel (x86_64): RSQLite_3.53.3.tgz
Old sources:	RSQLite archive

Reverse dependencies:

Reverse depends:	CITAN, D4TAlink.light, ECOTOXr, gde, RecordLinkage, RSQLite.toolkit, snplist, sqldf
Reverse imports:	acc, acdcquery, ACRER, actigraph.sleepr, actiRhythm, activAnalyzer, AdhereRViz, agcounts, ankiR, apsimx, archivist, BatchExperiments, BatchJobs, bdlp, bidux, blsBandit, BoSSA, cansim, chms, ciecl, cranlike, D3GB, datrProfile, dexter, dqcheckr, dqcheckrGUI, earthUI, eatDB, elcf4R, emuR, eplusr, Eunomia, expDB, FeatureExtraction, FIESTA, FIESTAutils, filehashSQLite, firmmatchr, framework, fspls2, gcbd, geeLite, geomultistar, GRAB, GWASinspector, htsr, hybridEHR, hydrodownloadR, kidsides, landsepi, liteq, LLMAgentR, marmap, MatchingPursuit, metrica, moodleR, mpathsenser, NCA, neuroimaGene, nlpembeds, nordstatExtras, openappr, PAGE, PAMmisc, PAMpal, parquetize, pathdb, pestr, piecemeal, prrd, pubchem.bio, QBMS, qst, qtl2, rangeMapper, rapsimng, rb3, rcprd, readepi, ReviewR, roadDB, rsyncrosim, scopr, SEERaBomb, sehrnett, sendigR, SGP, shiny.telemetry, shinymanager, shinymgr, shinyNotes, simplegraphdb, snowquery, soundClass, sqliter, sqliteutils, SSN2, SSNbler, tabs, taxizedb, taxonomizr, tidyhydat, tidywikidatar, tigreBrowserWriter, toxSummary, trackeR, VectrixDB, vegdata, zipcodeR, zot
Reverse suggests:	aisdk, arkdb, baseballr, biglm, biglmm, bigreadr, bigsnpr, btw, camtrapR, caroline, cdata, CDMConnector, cfbfastR, chunked, CohortMethod, CommonDataModel, connections, connector, convey, cookiemonster, corrr, COVID19, ctrdata, cytominer, DatabaseConnector, datadiff, dataverifyr, dbglm, DBI, dbi.table, DBItest, dbplot, dbplyr, dbx, diegr, diseasystore, dittodb, dlookr, dm, dplyneage, dplyr, easydb, editbl, emburden, etl, ETLUtils, FakeDataR, fastRhockey, featdelta, filematrix, finbif, geoflow, geogenr, GitStats, glue, gooseR, gpkg, GWSDAT, healthdb, hoopR, InterpretMSSpectrum, iNZightTools, ipumsr, janitor, learnr, LexisNexisTools, lgrExtra, macleish, maGUI, mfdb, mlr3db, modeldb, mstherm, NetSimR, nflfastR, nodbi, oai, oce, octopus, odbc, oddsapiR, OhdsiReportGenerator, orbital, orderly, palimpsestr, PatientLevelPrediction, pdfminer, PhysicalActivity, pmparser, pointblank, pool, PortfolioTesteR, ProjectTemplate, prqlr, qryflow, quantmod, querychat, R6P, radiant.data, RaMS, rcdf, rdataretriever, redquack, repana, reproducible, ResultModelManager, retraction, rocker, rolap, rqdatatable, rquery, RSQL, rvisual, SCDB, scrime, sf, shinyauthr, shinyChatR, shinylogs, soilDB, soilKey, SpaDES.core, sqlhelper, sqlq, sqltargets, srcr, srvyr, stenographer, stepmetrics, stevemisc, storr, stream, survey, svrep, taxify, tidylearn, tidypredict, tidyquery, ursa, vectra, vtreat, wehoop, when, winch, withr, writer
Reverse enhances:	login

Linking:

Please use the canonical form https://CRAN.R-project.org/package=RSQLite to link to this page.