Data

Tools

Indexes

Applications

Experiments

Open Source Science

DatabaseConnector

An R package for connecting to databases using JDBC.

https://github.com/ohdsi/databaseconnector

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Committers with academic emails
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (14.5%) to scientific vocabulary

Keywords

hades

Keywords from Contributors

interactive serializer packaging numeric network-simulation shellcodes hacking autograding observability embedded
Last synced: 10 months ago · JSON representation

Repository

An R package for connecting to databases using JDBC.

Basic Info
Statistics
  • Stars: 56
  • Watchers: 48
  • Forks: 89
  • Open Issues: 29
  • Releases: 18
Topics
hades
Created about 12 years ago · Last pushed 10 months ago
Metadata Files
Readme Changelog

README.md

DatabaseConnector

Build Status codecov.io CRAN_Status_Badge CRAN_Status_Badge

DatabaseConnector is part of HADES.

Introduction

This R package provides function for connecting to various DBMSs. Together with the SqlRender package, the main goal of DatabaseConnector is to provide a uniform interface across database platforms: the same code should run and produce equivalent results, regardless of the database back end.

Features

  • Create connections to the various database platforms:
    • MicrosoftSQL Server
    • Oracle
    • PostgresSql
    • Microsoft Parallel Data Warehouse (a.k.a. Analytics Platform System)
    • Amazon Redshift
    • Apache Impala
    • Google BigQuery
    • IBM Netezza
    • SQLite
    • Spark
    • InterSystems IRIS
  • Statements for executing queries with
    • Error reporting to file
    • Progress reporting
    • Multiple statements per query
  • Support for fetching data to Andromeda objects
  • Insert data frame to a database table
  • Supports the DBI interface, with SQL statements automatically translated to the appropriate dialect.
  • Supports the dbplyr interface.
  • Integrates with RStudio's Connections tab

Examples

r connectionDetails <- createConnectionDetails(dbms="postgresql", server="localhost", user="root", password="blah") conn <- connect(connectionDetails) querySql(conn,"SELECT COUNT(*) FROM person") disconnect(conn)

Technology

DatabaseConnector is an R package using Java's JDBC drivers and other DBI drivers.

System Requirements

Running the package requires R with the package rJava installed. Also requires Java 1.8 or higher.

Installation

  1. See the instructions here for configuring your R environment, including Java.

  2. To install the latest stable version, install from CRAN:

r install.packages("DatabaseConnector")

  1. Download the database drivers as described here.

  2. (Optionally) To use Windows Authentication for SQL Server, download the authentication DDL file as described here.

User Documentation

Documentation can be found on the package website.

PDF versions of the documentation are also available:

Support

Contributing

Read here how you can contribute to this package.

License

DatabaseConnector is licensed under Apache License 2.0. The JDBC drivers fall under their own respective licenses.

Development

DatabaseConnector is being developed in R Studio.

Development status

Stable. The code is actively being used in several projects.

Acknowledgements

  • This project is supported in part through the National Science Foundation grant IIS 1251151.

Owner

  • Name: Observational Health Data Sciences and Informatics
  • Login: OHDSI
  • Kind: organization

GitHub Events

Total
  • Create event: 8
  • Release event: 2
  • Issues event: 14
  • Watch event: 2
  • Delete event: 1
  • Member event: 1
  • Issue comment event: 42
  • Push event: 69
  • Pull request review event: 9
  • Pull request review comment event: 6
  • Pull request event: 14
  • Fork event: 8
Last Year
  • Create event: 8
  • Release event: 2
  • Issues event: 14
  • Watch event: 2
  • Delete event: 1
  • Member event: 1
  • Issue comment event: 42
  • Push event: 69
  • Pull request review event: 9
  • Pull request review comment event: 6
  • Pull request event: 14
  • Fork event: 8

Committers

Last synced: about 1 year ago

All Time
  • Total Commits: 761
  • Total Committers: 35
  • Avg Commits per committer: 21.743
  • Development Distribution Score (DDS): 0.578
Past Year
  • Commits: 68
  • Committers: 6
  • Avg Commits per committer: 11.333
  • Development Distribution Score (DDS): 0.382
Top Committers
Name Email Commits
schuemie s****e@o****g 321
Schuemie M****I@i****m 138
Admin_mschuemi A****i@i****m 95
Marc Suchard m****d@g****m 32
Benjamin De Boe b****e@i****m 20
Anastasiia Klochkova a****a@o****m 19
jgilber2 J****2@i****m 15
Adam Black a****3 14
Adam Black a****k@o****m 12
Matthew Young-Lai m****l@g****m 10
Londhe, Ajit [JRDUS] a****2@i****m 10
Vitaly Koulakov v****v@g****m 9
ssuvorov-fls s****v@o****m 7
schuemie s****e@g****m 7
yaroslavtir y****v@o****m 6
PGrafkin p****a@g****m 6
N.K c****2@a****r 4
Anthony Sena a****5@i****m 4
drowthorn d****n@i****m 4
alex-odysseus a****o@o****m 3
Tom White t****m@c****m 3
unknown m****i@W****m 3
Aaron Browne a****e@g****m 2
Cornelius Raths c****s@n****m 2
Gowtham Rao g****9@i****m 2
Gowtham Rao r****o@o****g 2
egillax e****x@g****m 2
illo o****g@g****t 2
Jie Fan l****o@g****m 1
Frank J DeFalco f****o@o****g 1
and 5 more...
Committer Domains (Top 20 + Academic)
its.jnj.com: 7 odysseusinc.com: 5 ohdsi.org: 3 google.com: 2 gmx.net: 1 nantmobile.com: 1 wprdusmjtglay.wks.jnj.com: 1 cloudera.com: 1 iqvia.com: 1 aumc.ac.kr: 1 intersystems.com: 1

Issues and Pull Requests

Last synced: 10 months ago

All Time
  • Total issues: 130
  • Total pull requests: 48
  • Average time to close issues: 6 months
  • Average time to close pull requests: 27 days
  • Total issue authors: 61
  • Total pull request authors: 17
  • Average comments per issue: 3.67
  • Average comments per pull request: 1.96
  • Merged pull requests: 32
  • Bot issues: 0
  • Bot pull requests: 1
Past Year
  • Issues: 11
  • Pull requests: 16
  • Average time to close issues: 2 months
  • Average time to close pull requests: 23 days
  • Issue authors: 9
  • Pull request authors: 6
  • Average comments per issue: 1.55
  • Average comments per pull request: 1.69
  • Merged pull requests: 11
  • Bot issues: 0
  • Bot pull requests: 1
View more stats
Top Authors
Issue Authors
  • schuemie (22)
  • ablack3 (17)
  • alondhe (7)
  • azimov (7)
  • anthonysena (7)
  • javier-gracia-tabuenca-tuni (6)
  • gowthamrao (2)
  • egillax (2)
  • katy-sadowski (2)
  • ssuvorov-fls (2)
  • alex-odysseus (2)
  • illoRocks (2)
  • IoannaNika (2)
  • KingAl (2)
  • drowlingua (2)
Pull Request Authors
  • ablack3 (19)
  • azimov (6)
  • anthonysena (5)
  • bdeboe (4)
  • ssuvorov-fls (3)
  • dependabot[bot] (2)
  • alex-odysseus (2)
  • eric-fey-hus (2)
  • MPagel (2)
  • javier-gracia-tabuenca-tuni (1)
  • wibeasley (1)
  • clairblacketer (1)
  • drowlingua (1)
  • jdposada (1)
  • gowthamrao (1)
Top Labels
Issue Labels
enhancement (17) bug (12) good first issue (2) exploratory (1) help wanted (1) question (1)
Pull Request Labels
dependencies (2)

Packages

  • Total packages: 3
  • Total downloads:
    • cran 3,211 last-month
  • Total docker downloads: 21,884
  • Total dependent packages: 7
    (may contain duplicates)
  • Total dependent repositories: 133
    (may contain duplicates)
  • Total versions: 96
  • Total maintainers: 1
proxy.golang.org: github.com/ohdsi/databaseconnector
  • Versions: 34
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent packages count: 5.5%
Average: 5.7%
Dependent repos count: 5.8%
Last synced: 10 months ago
proxy.golang.org: github.com/ohdsi/DatabaseConnector
  • Versions: 34
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent packages count: 5.5%
Average: 5.7%
Dependent repos count: 5.8%
Last synced: 10 months ago
cran.r-project.org: DatabaseConnector

Connecting to Various Database Platforms

  • Versions: 28
  • Dependent Packages: 7
  • Dependent Repositories: 133
  • Downloads: 3,211 Last month
  • Docker Downloads: 21,884
Rankings
Forks count: 0.8%
Dependent repos count: 1.8%
Stargazers count: 6.0%
Downloads: 7.6%
Dependent packages count: 8.1%
Average: 8.2%
Docker downloads count: 25.0%
Maintainers (1)
schuemie@ohdsi.org
Last synced: 10 months ago

Dependencies

DESCRIPTION cran
  • R >= 2.10 depends
  • DBI >= 1.0.0 imports
  • SqlRender >= 1.8.3 imports
  • bit64 * imports
  • methods * imports
  • rJava * imports
  • readr * imports
  • rlang * imports
  • stringr * imports
  • urltools * imports
  • utils * imports
  • Andromeda >= 0.6.0 suggests
  • DBItest * suggests
  • R.utils * suggests
  • RSQLite * suggests
  • aws.s3 * suggests
  • dplyr * suggests
  • knitr * suggests
  • rmarkdown * suggests
  • ssh * suggests
  • testthat * suggests
  • withr * suggests
.github/workflows/R_CMD_check_main_weekly.yaml actions
  • actions/checkout v3 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
  • r-lib/actions/setup-tinytex v2 composite
.github/workflows/R_CMD_check_Hades.yaml actions
  • actions/checkout v2 composite
  • actions/create-release v1 composite
  • actions/download-artifact v2 composite
  • actions/upload-artifact v2 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
  • r-lib/actions/setup-tinytex v2 composite
.github/workflows/reverse_dependency.yml actions
  • actions/checkout v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
  • r-lib/actions/setup-tinytex v2 composite