Skip to content

RSQLite

SQLite Interface for R

v2.4.6 · Feb 6, 2026 · LGPL (>= 2.1)
CRAN GitHub Mirror

Description

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine (version 3.51.2) 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.

Downloads

203.1K

Last 30 days

234th

600.6K

Last 90 days

2.4M

Last year

Trend: -6.4% (30d vs prior 30d)

CRAN Check Status

5 NOTE
9 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang NOTE
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 NOTE
r-oldrel-macos-arm64 NOTE
r-oldrel-macos-x86_64 NOTE
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 NOTE
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (5 non-OK)
NOTE r-devel-linux-x86_64-debian-clang

compiled code

File ‘RSQLite/libs/RSQLite.so’:
  Found non-API call to R: ‘R_NamespaceRegistry’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.
NOTE r-devel-windows-x86_64

compiled code

File 'RSQLite/libs/x64/RSQLite.dll':
  Found non-API call to R: 'R_NamespaceRegistry'

Compiled code should not call non-API entry points in R.

See 'Writing portable packages' in the 'Writing R Extensions' manual,
and section 'Moving into C API compliance' for issues with the use of
non-API entry points.
NOTE r-oldrel-macos-arm64

installed package size

installed size is 11.4Mb
  sub-directories of 1Mb or more:
    libs  10.6Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is 12.4Mb
  sub-directories of 1Mb or more:
    libs  11.6Mb
NOTE r-patched-linux-x86_64

compiled code

File ‘RSQLite/libs/RSQLite.so’:
  Found non-API call to R: ‘R_NamespaceRegistry’

Compiled code should not call non-API entry points in R.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.

Check History

NOTE 12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
NOTE r-oldrel-macos-arm64

installed package size

installed size is 11.4Mb
  sub-directories of 1Mb or more:
    libs  10.6Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is 12.4Mb
  sub-directories of 1Mb or more:
    libs  11.6Mb

Reverse Dependencies (244)

depends

CITAN D4TAlink.light ECOTOXr RSQLite.toolkit RecordLinkage gde snplist sqldf

imports

ActiSleep AdhereRViz BatchExperiments BatchJobs BoSSA D3GB Eunomia FIESTA FIESTAutils FeatureExtraction GRAB GWASinspector LLMAgentR NCA NetSimR PAGE PAMmisc PAMpal QBMS ReviewR SEERaBomb SGP SSN2 SSNbler VectrixDB acc acdcquery activAnalyzer agcounts ankiR apsimx archivist bdlp bidux blsBandit cansim ciecl cranlike datrProfile dexter eatDB emuR eplusr expDB filehashSQLite firmmatchr framework gcbd geeLite geomultistar globaltrends htsr hybridEHR hydrodownloadR kidsides landsepi liteq marmap metrica moodleR mpathsenser nlpembeds openappr parquetize pestr piecemeal prrd pubchem.bio qst qtl2 rangeMapper rapsimng rb3 rcdf rcprd readepi rsyncrosim scopr sehrnett sendigR shiny.telemetry shinyNotes shinymanager shinymgr simplegraphdb snowquery soundClass sqliter sqliteutils tabs taxizedb taxonomizr tidyhydat tidywikidatar tigreBrowserWriter toxSummary trackeR zipcodeR

suggests

CDMConnector COVID19 CohortMethod CommonDataModel DBI DBItest DatabaseConnector ETLUtils FakeDataR GWSDAT GitStats InterpretMSSpectrum LexisNexisTools OhdsiReportGenerator PatientLevelPrediction PhysicalActivity PortfolioTesteR ProjectTemplate R6P RSQL RaMS ResultModelManager SCDB SpaDES.core aisdk arkdb baseballr biglm biglmm bigreadr bigsnpr camtrapR caroline cdata cfbfastR chunked connections connector convey cookiemonster corrr ctrdata cytominer datadiff dataverifyr dbglm dbi.table dbplot dbplyr dbx diseasystore dittodb dlookr dm dplyr earthUI easydb editbl emburden etl fastRhockey filematrix finbif geoflow geogenr glue gooseR gpkg healthdb hoopR iNZightPlots iNZightTools ipumsr janitor learnr lgrExtra maGUI macleish mfdb mlr3db modeldb mstherm nflfastR nodbi oai oce octopus odbc oddsapiR orbital orderly pdfminer pmparser pointblank pool prqlr qryflow quantmod querychat radiant.data rdataretriever redquack repana reproducible rocker rolap rqdatatable rquery scrime sf shinyChatR shinyauthr shinylogs soilDB sqlhelper sqlq sqltargets srcr srvyr stenographer stepmetrics stevemisc storr stream survey svrep taxadb tidier tidypredict tidyquery ursa vismeteor vtreat wehoop when winch withr writer

Dependency Network

Dependencies Reverse dependencies bit64 blob DBI memoise pkgconfig rlang CITAN D4TAlink.light ECOTOXr RSQLite.toolkit RecordLinkage gde snplist sqldf ActiSleep AdhereRViz BatchExperiments BatchJobs BoSSA D3GB Eunomia +229 more reverse deps RSQLite

Version History

new 2.4.6 Mar 10, 2026
updated 2.4.6 ← 2.4.5 diff Feb 5, 2026
updated 2.4.5 ← 2.4.4 diff Nov 29, 2025
updated 2.4.4 ← 2.4.3 diff Nov 9, 2025
updated 2.4.3 ← 2.4.2 diff Aug 19, 2025
updated 2.4.2 ← 2.4.1 diff Jul 18, 2025
updated 2.4.1 ← 2.4.0 diff Jun 7, 2025
updated 2.4.0 ← 2.3.11 diff May 30, 2025
updated 2.3.11 ← 2.3.10 diff May 3, 2025
updated 2.3.10 ← 2.3.9 diff May 1, 2025
updated 2.3.9 ← 2.3.8 diff Dec 2, 2024
updated 2.3.8 ← 2.3.7 diff Nov 16, 2024
updated 2.3.7 ← 2.3.6 diff May 26, 2024
updated 2.3.6 ← 2.3.5 diff Mar 31, 2024
updated 2.3.5 ← 2.3.4 diff Jan 20, 2024
updated 2.3.4 ← 2.3.3 diff Dec 7, 2023
updated 2.3.3 ← 2.3.2 diff Nov 3, 2023
updated 2.3.2 ← 2.3.1 diff Oct 27, 2023
updated 2.3.1 ← 2.3.0 diff Apr 2, 2023
updated 2.3.0 ← 2.2.20 diff Feb 16, 2023