Skip to content

DBI

R Database Interface

v1.3.0 · Feb 24, 2026 · LGPL (>= 2.1)

Description

A database interface definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations.

Downloads

CRAN

601.6K

Last 30 days

119th

2M

Last 90 days

8.4M

Last year

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

r2u CRAN

7.9K

Last 30 days

25.8K

Last 90 days

117.6K

Last year

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

autoCRAN

26

Last 7 days

177

Last 30 days

6

All-time

⚠ Shared name: this package is also shipped elsewhere on openSUSE, so this count is not exclusive to autoCRAN (it is an upper bound).

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
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-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 25, 2026
NOTE 13 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
NOTE r-oldrel-macos-x86_64

package dependencies

Package suggested but not available for checking: ‘arrow’

Code

Structure

Lines of code

21,556

Files

296

Compiled share

0%

Has compiled src

No

Language breakdown

R 5,404 (25.1%)Tests 640 (3%)Docs 7,971 (37%)Vignettes 7,541 (35%)

API

Exported functions

76

Internal functions

126

Recent export changes

v1.2.0+9 dbAppendTableArrow, dbBindArrow, dbCreateTableArrow +6 more

Testing & CI

Has tests

Yes

Test-to-code ratio

0.12

testthat edition

3

CI present

No

CI type

[]

PR gated

No

Docs

Return-value doc rate

78.7%

\dontrun example ratio

0%

Roxygen coverage

100%

Has pkgdown

No

NEWS present

Yes

Health & Security signals

Informational signals; not verdicts.

on.exit coverage

0%

Unsafe pattern score

0

Dep constraint coverage

0%

Secret pattern count

0

Bundled 3rd-party code

2 items

Portability & License

Min R version

3.0.0

System requirements

C++ standard

License

LGPL (>= 2.1)

License flags

SPDX valid, OSI approved

History

Versions

39

First release

2001-12-05

Latest release

2026-02-25

Avg cadence

122 days

Cold removal rate

100%

Dep drift

0

LOC over versions

v0.1-2: 1,489 LOCv0.1-3: 1,621 LOCv0.1-4: 1,793 LOCv0.1-5: 1,790 LOCv0.1-6: 1,790 LOCv0.1-7: 5,315 LOCv0.1-8: 5,315 LOCv0.1-9: 5,312 LOCv0.1-10: 1,924 LOCv0.1-11: 1,821 LOCv0.1-12: 1,821 LOCv0.2-0: 1,821 LOCv0.2-1: 1,810 LOCv0.2-2: 1,804 LOCv0.2-3: 1,804 LOCv0.2-4: 1,804 LOCv0.2-5: 1,805 LOCv0.2-6: 1,791 LOCv0.2-7: 1,791 LOCv0.3.0: 2,565 LOCv0.3.1: 2,566 LOCv0.4: 5,821 LOCv0.4-1: 5,847 LOCv0.5: 6,906 LOCv0.5-1: 6,937 LOCv0.6: 8,228 LOCv0.6-1: 8,228 LOCv0.7: 8,275 LOCv0.8: 9,150 LOCv1.0.0: 10,072 LOCv1.1.0: 11,252 LOCv1.1.1: 11,743 LOCv1.1.2: 12,390 LOCv1.1.3: 12,881 LOCv1.2.0: 14,134 LOCv1.2.1: 16,035 LOCv1.2.2: 18,908 LOCv1.2.3: 18,979 LOCv1.3.0: 21,556 LOC

Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.

Reverse Dependencies (384)

imports

AdhereRViz Andromeda AzureKusto BIEN BatchExperiments BatchJobs CDMConnector CITAN ClickHouseHTTP CodelistGenerator CommonDataModel D3GB DBItest DIZutils DatabaseConnector DisImpact Eunomia FIESTA FIESTAutils FeatureExtraction GWalkR GeoTox ILORA LLMAgentR MCOE MeasurementDiagnostics NCA NetSimR OmopOnSpark OpenRange OpenSourceAP.DownloadR PANACEA PKbioanalysis PatientGenerator QBMS RAGFlowChainR RAthena RClickhouse RGreenplum RMariaDB RODBCDBI RPostgres RPresto RSQL RSQLite RSQLite.toolkit RXKCD Rduckhts ResultModelManager ReviewR SCDB SEERaBomb SQL SQLove SangerTools TestGenerator TrialEmulation VectrixDB acc acdcquery actigraph.sleepr adbi africamonitor agcounts allofus ankiR apsimx archivist arkdb basedosdados bcdata bdlp bedrockbio bidux bigrquery biolink birdscanR blsBandit brclimr brickster cansim childesr chunked ciecl clintrialx cnefetools connections connector connector.databricks contoso cranlike csdb ctrialsgov db2pq dbMatrix dbProject dbSpatial dbglm dbi.table dbplyr dbx dexter dextergui diseasystore dqcheckr dqcheckrGUI duckdbfs duckh3 duckplyr duckspatial earthUI easydb eatDB elcf4R emuR epidm etl expDB eyeris farr featdelta filehashSQLite firmmatchr framework gatoRs gcbd geobr geocodebr globaltrends gooseR gpkg greenR htsr hybridEHR hydrodownloadR iNZightTools ipanema kidsides landsepi lazysf liteq login lucas marmap mdbr mdsr metrica mfdb mitools moodleR motherduck mpathsenser mtgjsonsdk neonstore neuroimaGene noctua nodbi nordstatExtras obm occCite octopus odbc okf openSkies openappr overtureR parquetize pathdb pathfindR pestr pgTools phylosignal piecemeal pmparser pointblank pool prrd pysparklyr qryflow qst quak querychat rDeckgl rMosaic ragnar rangeMapper rapsimng rb3 rcdf readepi redquack rerddapUtils restez rocker rpgconn rsgl rsyncrosim samadb scRNAstat sdstudio sehrnett sejmRP sergeant sf shinyChatR shinyHugePlot shinyNotes shinymanager shinymgr simplegraphdb snowquery snplist soilDB soundClass spanishoddata sparkavro sparklyr sqlHelpers sqldf sqlhelper sqliter sqliteutils sqlm sqlq sqltargets srcr starwarsdb stenographer supabaseR surveydown svrep taskqueue taxadb taxizedb tcpl tidyfinance tidyhydat tidywikidatar tigreBrowserWriter toxSummary ugatsdb virtuoso when wizaRdry wrds writer zipcodeR

Dependency Network

Dependencies Reverse dependencies D4TAlink.light RJDBC RMySQL ROracle RPostgreSQL RecordLinkage TKCat biglm biglmm ckanr dbWebForms dittodb duckdb gmDatabase implyr +369 more reverse deps DBI

Version History

40 tracked
new 1.3.0 Mar 10, 2026
updated 1.3.0 ← 1.2.3 diff Feb 24, 2026
updated 1.2.3 ← 1.2.2 diff Jun 1, 2024
updated 1.2.2 ← 1.2.1 diff Feb 15, 2024
updated 1.2.1 ← 1.2.0 diff Jan 11, 2024
updated 1.2.0 ← 1.1.3 diff Dec 20, 2023
updated 1.1.3 ← 1.1.2 diff Jun 17, 2022
updated 1.1.2 ← 1.1.1 diff Dec 19, 2021
updated 1.1.1 ← 1.1.0 diff Jan 14, 2021
updated 1.1.0 ← 1.0.0 diff Dec 14, 2019
updated 1.0.0 ← 0.8 diff May 1, 2018
updated 0.8 ← 0.7 diff Mar 1, 2018
updated 0.7 ← 0.6-1 diff Jun 17, 2017
updated 0.6-1 ← 0.6 diff Apr 1, 2017
updated 0.6 ← 0.5-1 diff Mar 8, 2017