DatabaseConnector
‹8.0.0
- 8.0.01 Oct 2026, current
- 7.2.026 Jun 2026
- 7.1.09 Jan 2026
- 7.0.023 Sep 2025
- 6.4.030 Jan 2025
- 6.3.316 Jan 2025
- 6.3.211 Dec 2023
- 6.3.128 Nov 2023
- 6.3.08 Nov 2023
- 6.2.47 Sep 2023
- 6.2.330 Jun 2023
- 6.2.223 Jun 2023
- 6.2.110 May 2023
- 6.2.013 Apr 2023
- 6.1.016 Mar 2023
- 6.0.030 Jan 2023
- 5.1.023 Sep 2022
- 5.0.428 Jun 2022
- 5.0.38 Jun 2022
- 5.0.211 Feb 2022
- 5.0.018 Nov 2021
- 4.0.215 Apr 2021
- 4.0.02 Mar 2021
- 3.0.06 Jun 2020
- 2.4.215 Jan 2020
- 2.4.118 Jul 2019
- 2.3.021 Feb 2019
- 2.2.125 Nov 2018
- 2.2.01 Oct 2018
- 2.1.421 Aug 2018
- 2.1.328 Jun 2018
- 2.1.224 May 2018
Connecting to Various Database Platforms
- CRAN checks, method
Method
Checks and health
CRAN runs every current package through
R CMD checkon a set of machines and publishes a result for each one. The health shown on a package page comes from these results alone.- Problems
- Notes alone never count against a package, but a warning, an error or a failure on any platform is a problem. Open CRAN deadlines are a fact of their own, shown as a clock after the mark, so the mark always says what the checks found.
- Checks only
- Health reflects CRAN's check results and nothing else. Even a package with no tests, no coverage or no recent release can have every platform OK.
- Once a day
- Results are collected once a day from files CRAN publishes. Each platform is one machine set-up, named by its R version, operating system, architecture and compiler, such as r-devel-linux-x86_64-fedora-clang.
- Platforms counted
- The 13 in 3 of 13 is the number of platform rows CRAN published for that package on the day of collection. The set of machines changes over time, so the number is not fixed, and a package missing from a platform counts as neither passing nor failing there.
- All OK13 platforms
- CRAN 30-day downloads, method
- 4,540+40.3% up on the 30 days before, the better direction
- Dependent packages, method
Method
Reverse dependencies
Dependent packages are other packages that list this one under
Depends,ImportsorLinkingToin theirDESCRIPTIONfile. Those fields list the packages a package needs to install, so dependents break if this one is archived or broken.- As declared
- The counts follow the declarations as written, not whether a package uses the other one when it runs.
- Suggests apart
- Packages that list this one only under
Suggestsinstall and run without it, and use it for tests, examples or an optional feature. They are counted as Suggested by, never among the dependents, and a package that also lists it under one of the three fields is a dependent and is not counted again. - Zero
- Zero dependents means no current CRAN package declares a need for this one, though some may suggest it. On 26 Oct 2026, 19,530 of the 25,531 current CRAN packages had no dependent package.
- 185 more suggest it
- Test coverage, method
Method
Test coverage
Test coverage is measured by downloading each CRAN package's current source file, installing its dependencies, building it and running its tests under covr.
- Almost half of CRAN has no tests to run
- Only CRAN packages are measured. Many have no percentage, most often because the package has no tests, and that blank is a recorded outcome, not missing data.
- NOT_CRAN
- Tests run with NOT_CRAN=true, so tests that skip themselves on CRAN run here, and the figure can differ from what CRAN's own checks see.
- Current version only
- Only the current version is measured, and a new version on CRAN is measured again. Older rows are kept but never filled in later. This is one package's run.
- Never 0%
- On a package page three states stay apart: measured, no tests, and not measured. Neither of the last two is ever shown as 0%.
- 0%of lines run by tests
- Advisories, method
Method
Security advisories
Advisories come from the R Consortium advisory database, a community record of security problems in R packages, as OSV publishes it.
- The copy
- The record is read once a day. The data is published under the Apache License 2.0 and is credited on the advisories list.
- Box under the name
- Under the package's name, a box names any advisory that affects the current release, with its fix or that there is none.
- Ranges
- Advisories state ranges, such as from 0.9.12 up to but not including 1.8.8. Each range is checked against every version CRAN has published, using the version rules R itself uses, so a release that came out after the advisory was written is still caught by its range.
- Not the package
- The rating is for the library flaw itself, not for how exposed the R package is, and it is never added up into a figure for the package.
- None known
About
Method, About Method Licence figures come from the Licences
License field of each package's DESCRIPTION file, read the way R itself reads it. No licence file is opened.tools::analyze_license() and R's own licence database, as CRAN's checks read it.| is read, so one string can offer two families.
An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', 'SQLite', and 'InterSystems ...
Full description
An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', 'SQLite', and 'InterSystems IRIS'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.
- Maintainer
- Martijn Schuemie
- Licence
- Apache License
- Latest release
- 1 Oct 2026
- First release
- 24 May 2018
More details
- Releases
- 32
- Needs compilation
- No
- Needs R
- >= 4.0.0
- Config/roxygen2/version
- 8.1.0
- Date
- 2026-10-01
- SystemRequirements
- Java (>= 8)
Task views (1)
Subjects (1) Method, SubjectsMethod
Subjects and collections
Subjects are the site's own grouping of CRAN packages, found by clustering. Collections are sets of packages that communities declare, such as the tidyverse.
- Subjects
- Subjects are found by clustering the words of current CRAN packages and the packages they use. No one edits them by hand.
- Collections
- Collections are sets that communities declare, through a package that installs the set or an organization on GitHub. The site finds them by rules.
- Who made each
- Subjects are marked Site and collections Community. Subjects, collections and task views are never mixed in one list.
- The day of the data
- Subjects and collections were last worked out on 22 Oct 2026.
Cite
Package
Run in R for the authors' preferred citation:
citation("DatabaseConnector")Schuemie, M., Amazon Inc., Microsoft Inc., Observational Health Data Science and Informatics, Oracle Inc., PostgreSQL Global Development Group, Black, A., & Suchard, M. (2026). DatabaseConnector: Connecting to Various Database Platforms (Version 8.0.0) [Computer software]. https://doi.org/10.32614/CRAN.package.DatabaseConnector
About
This package has no citation file, so citation() returns this entry built from DESCRIPTION.
R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
Balamuta, J. J. (2026). R Observatory: Metrics for DatabaseConnector version 8.0.0 [Data set]. HJJB, LLC. Data release v2026-10-26. https://doi.org/10.5281/zenodo.21843040
About
From data release v2026-10-26, which the citation names so these numbers can be found later.
Health
All 13 check platforms pass.
r-devel-linux-x86_64-debian-clangThe unreleased R on Linux, x86_64, debian-clang
OK
- Version checked
- 8.0.0
- Time taken
- 137 s
r-devel-linux-x86_64-debian-gccThe unreleased R on Linux, x86_64, debian-gcc
OK
- Version checked
- 8.0.0
- Time taken
- 96 s
r-devel-linux-x86_64-fedora-clangThe unreleased R on Linux, x86_64, fedora-clang
OK
- Version checked
- 8.0.0
- Time taken
- 101 s
r-devel-linux-x86_64-fedora-gccThe unreleased R on Linux, x86_64, fedora-gcc
OK
- Version checked
- 8.0.0
- Time taken
- 94 s
r-devel-windows-x86_64The unreleased R on Windows, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 185 s
r-oldrel-macos-arm64The previous release of R on macOS, arm64
OK
- Version checked
- 8.0.0
- Time taken
- 56 s
r-oldrel-macos-x86_64The previous release of R on macOS, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 130 s
r-oldrel-windows-x86_64The previous release of R on Windows, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 222 s
r-patched-linux-x86_64The patched release of R on Linux, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 133 s
r-release-linux-x86_64The current release of R on Linux, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 126 s
r-release-macos-arm64The current release of R on macOS, arm64
OK
- Version checked
- 8.0.0
- Time taken
- 41 s
r-release-macos-x86_64The current release of R on macOS, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 148 s
r-release-windows-x86_64The current release of R on Windows, x86_64
OK
- Version checked
- 8.0.0
- Time taken
- 186 s
- 13 OK
Over time
No change since 7 Oct 2026
As a list (9)
| Changed | Worst status | OK | Notes | Warnings | Errors |
|---|---|---|---|---|---|
| 7 Oct 2026 | OK | 13 | 0 | 0 | 0 |
| 11 Jul 2026 | Note | 12 | 1 | 0 | 0 |
| 9 Jun 2026 | OK | 13 | 0 | 0 | 0 |
| 8 Jun 2026 | Error | 12 | 0 | 0 | 1 |
| 6 Jun 2026 | OK | 13 | 0 | 0 | 0 |
| 4 Jun 2026 | Note | 12 | 1 | 0 | 0 |
| 6 Apr 2026 | OK | 14 | 0 | 0 | 0 |
| 4 Apr 2026 | Error | 13 | 0 | 0 | 1 |
| 10 Mar 2026 | OK | 14 | 0 | 0 | 0 |
Since March 2026
Downloads
Method, Downloads Method Download figures count requests logged by each distribution channel. They are not counts of installs or of users, because each channel publishes its own totals and this site reads them.Downloads
- Total downloads in the last 30 days
- 4,642+41% up on the 30 days before, the better directionIt is the sum of 4 channels: CRAN, r2u, autoCRAN and c2d4u.
CRAN rank
1,640 of 26,529
CRAN
4,540 downloads in the last 30 days
- Rank
- 1,640 of 26,529
- Change
- +40.3% up on the 30 days before, the better direction
It is in the total. Take it out
r2u
85 downloads in the last 30 days
- Rank
- 2,508 of 30,526
- Change
- +227% up on the 30 days before, the better direction
It is in the total. Take it out
autoCRAN
15 downloads in the last 30 days
- Rank
- 3,047 of 29,130
- Change
- +7.1% up on the 30 days before, the better direction
It is in the total. Take it out
c2d4u, no longer updated
2 downloads in the last 30 days
- Rank
- 4,900 of 7,575
- Change
- −85.7% down on the 30 days before, the worse direction
It is in the total. Take it out
The total is 4,642 downloads in the last 30 days. It is the sum of 4 channels: CRAN, r2u, autoCRAN and c2d4u.
Over time
Dependencies
- Needs
- 13
- Dependent packages
- 18
- Suggested by
- 5
Needs (13)
Optional extras (19)
Dependent packages (18)
| Package | Title | Downloads in 30 days |
|---|---|---|
| FeatureExtraction | Generating Features for a Cohort | 1,286 |
| CommonDataModel | OMOP CDM DDL and Documentation Generator | 1,143 |
| CohortGenerator | Cohort Generation for the OMOP Common Data Model | 912 |
| DataQualityDashboard | Execute and View Data Quality Checks on OMOP CDM Database | 880 |
| ResultModelManager | Result Model Manager | 861 |
| PatientLevelPrediction | Develop Clinical Prediction Models Using the Common Data Model | 732 |
| Characterization | Implement Descriptive Studies Using the Common Data Model | 697 |
| Achilles | Achilles Data Source Characterization | 662 |
| CohortMethod | Comparative Cohort Method with Large Scale Propensity and Outcome Models | 563 |
| SelfControlledCaseSeries | Self-Controlled Case Series | 542 |
| OhdsiReportGenerator | Observational Health Data Sciences and Informatics Report Generator | 390 |
| SelfControlledCohort | Self-Controlled Cohort Population-Level Estimation | 362 |
| CohortIncidence | Cohort Incidence Analysis for the OMOP Common Data Model | 342 |
| OhdsiShinyAppBuilder | Viewing Observational Health Data Sciences and Informatics Results via 'shiny' Modules | 335 |
| OdysseusPathwayModule | Cohort Pathway Analysis with Pre-Index Event Support | 278 |
| OdysseusCharacterizationModule | Handy and Minimalistic Common Data Model Characterization | 269 |
| OdysseusSurvivalModule | Cohort-Based Single-Event Survival Utilities | 156 |
| PheValuator | Rapid Phenotype Evaluation | 17 |
Code
Method, Code Method Code metrics come from reading the released source of each package version. The package is never installed, loaded or run.Code metrics
README, vignettes, a NEWS file and the shares read from its help pages. Files kept only in the repository, such as a pkgdown configuration or CI files, are read by the repository scan instead.
- Functions
- 141
- Public exports
- 27
- Lines of R code
- 5,461
- Median complexity
- 2
Functions (141)
Size and composition
Lines by kind (11,603)
| Kind | Lines | Share |
|---|---|---|
| R code | 5,461 | 47% |
| Tests | 1,152 | 10% |
| Documentation | 4,478 | 39% |
| Guides | 512 | 4% |
Lines by language
| Language | Lines | Share |
|---|---|---|
| R | 6,613 | 57% |
| Rd | 4,478 | 39% |
| Vignettes | 512 | 4% |
Languages are counted from file extensions.
- Files
- 133
- R functions
- 141
- Object systems
- S3: 23 methods, S4: 6 classes, S4: 43 methods
Complexity
- Median
- 2
- Mean
- 4.39
- Highest
- 59
- Median lines per function
- 15
About complexity
Cyclomatic complexity counts the independent paths through a function: 1 is a straight line, higher is harder to test. R functions only.
Call graph figures
- R functions
- 141
- Calls
- 237
- Unconnected
- 18
- Groups
- 3
Growth (32 releases)
Release changes
Tests
The tests ran and coverage was measured.
- Lines run by tests
- 0%
- Expressions run by tests
- 0%
- Test cases
- 51
- Exports named in tests
- 88.9%
Coverage by file (16)
Coverage run
- Lines counted
- 2,714
- Lines the tests ran
- 0
- Tests passed
- Yes
- Measured with
- covr 3.6.5 on R 4.6.1
Test suite
- Has tests
- Yes
- Test frameworks
- testthat, tinytest
- Test cases
- 51
- Lines of tests
- 1,152
- Test lines per line of code
- 0.21
Documentation
- Exports documented
- 100%
- Arguments documented
- 89.3%
- Return value documented
- 74.1%
- Help pages with examples
- 23.2%
- Examples run in checks
- 18.8%
Other documentation
- README
- Yes, 399 words
- Release notes file
- Yes
- Help pages
- 69
- Lines of documentation
- 4,478
People
Method, People Method People on the site are the names packages give them in their Author and maintainer identity
DESCRIPTION files: authors from the author list, and the maintainer from the Maintainer field. Spellings of one name become one person only where the rules below allow it, and when in doubt the rules keep people apart.
Maintainer since 2.1.2 (2018), author
Amazon Inc., an organisation
Copyright holder
Microsoft Inc., an organisation
Copyright holder
Observational Health Data Science and Informatics, an organisation
Copyright holder
Oracle Inc., an organisation
Copyright holder
PostgreSQL Global Development Group, an organisation
Copyright holder
Author
Author
Earlier names (1)
- Starschema Ltd.
Repository
Method, figures by host Method Repository signals are the figures read from the source repository a package links to: stars, forks, issues, commits, releases and the time issues take to close. They are read from GitHub, GitLab and Codeberg.Repository signals
URL and BugReports fields of its DESCRIPTION file. Read-only mirrors, the cran and bioc accounts on GitHub and git.bioconductor.org, are left out.
OHDSI / databaseconnector on github.com
- Stars
- 57no change on 30 days ago
- Forks
- 96
- Open issues
- 22
- Last commit
- 1 Oct 2026
Activity
- Commits
- 1,090
- Open pull requests
- 4
- Tagged releases
- 22
- Latest tagged release
- v8.0.0, 1 Oct 2026
- Issues closed in
- 134 days (median)
- Pull requests closed in
- 6 days (median)
- Pull requests merged
- 76%
- Created
- 3 Apr 2014
- Licence file reads as
- –
Development practices (10)
| Kind | Found |
|---|---|
| Continuous integration | GitHub Actions, R CMD check workflow The R CMD check workflow runs on Linux, macOS and Windows |
| Governance and community | PR template |
| Docs source | pkgdown GitHub Pages site last deployed 2026-10-01 |
| Coverage | Coverage reporting |
| CRAN release process | cran-comments.md, CRAN-SUBMISSION |
| Lint, format, editor | RStudio project |
| Git structural | .gitattributes |
Method, repository practices Method Beta Each week a scan of the public source repository a package links to looks for the tools a maintainer has set up, and the Repository section lists the findings. Repositories on GitHub and GitLab are scanned.Repository practices
R CMD build reads .Rbuildignore and leaves out files used only in development, such as .github/, .lintr, renv/, a Dockerfile and cran-comments.md, so the released source file holds almost none of them. The repository is the one place these files stay visible.
History
Method, History Method Archived is built from CRAN's archive records, its list of check deadlines and Bioconductor's package records. Every figure is counted to 26 Oct 2026, the day the data was read.Packages leaving
| Version | Released | R |
|---|---|---|
| 8.0.0 current | 1 Oct 2026 | 4.6.1 |
| 7.2.0 | 26 Jun 2026 | 4.6.1 |
| 7.1.0 | 9 Jan 2026 | 4.5.2 |
| 7.0.0 | 23 Sep 2025 | 4.5.1 |
| 6.4.0 | 30 Jan 2025 | 4.4.2 |
| 6.3.3 | 16 Jan 2025 | 4.4.2 |
| 6.3.2 | 11 Dec 2023 | 4.3.2 |
| 6.3.1 | 28 Nov 2023 | 4.3.2 |
Earlier versions (24)
| Version | Released | R |
|---|---|---|
| 6.3.0 | 8 Nov 2023 | 4.3.2 |
| 6.2.4 | 7 Sep 2023 | 4.3.1 |
| 6.2.3 | 30 Jun 2023 | 4.3.1 |
| 6.2.2 | 23 Jun 2023 | 4.3.1 |
| 6.2.1 | 10 May 2023 | 4.3.0 |
| 6.2.0 | 13 Apr 2023 | 4.2.3 |
| 6.1.0 | 16 Mar 2023 | 4.2.3 |
| 6.0.0 | 30 Jan 2023 | 4.2.2 |
| 5.1.0 | 23 Sep 2022 | 4.2.1 |
| 5.0.4 | 28 Jun 2022 | 4.2.1 |
| 5.0.3 | 8 Jun 2022 | 4.2.0 |
| 5.0.2 | 11 Feb 2022 | 4.1.2 |
| 5.0.0 | 18 Nov 2021 | 4.1.2 |
| 4.0.2 | 15 Apr 2021 | 4.0.5 |
| 4.0.0 | 2 Mar 2021 | 4.0.4 |
| 3.0.0 | 6 Jun 2020 | 4.0.0 |
| 2.4.2 | 15 Jan 2020 | 3.6.2 |
| 2.4.1 | 18 Jul 2019 | 3.6.1 |
| 2.3.0 | 21 Feb 2019 | 3.5.2 |
| 2.2.1 | 25 Nov 2018 | 3.5.0 |
| 2.2.0 | 1 Oct 2018 | 3.5.0 |
| 2.1.4 | 21 Aug 2018 | 3.5.0 |
| 2.1.3 | 28 Jun 2018 | 3.5.0 |
| 2.1.2 | 24 May 2018 | 3.5.0 |
Release notes (8.0.0)
Changes:
Changing required Java version to 21. Most database platforms will still run using Java 8, but more and more JDBC drivers will need higher Java versions.
Updating Snowflake and DataBricks driver. DataBricks driver now requires Java >= 11.
Setting JDBC_QUERY_RESULT_FORMAT=JSON when connecting to Snowflake to avoid 'You must start Java with --add-opens=java.base/java.nio=org.apache.arrow.memory.core,ALL-UNNAMED' error.