Package: DatabaseConnector 6.3.2
DatabaseConnector: Connecting to Various Database Platforms
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', and 'SQLite'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.
Authors:
DatabaseConnector_6.3.2.tar.gz
DatabaseConnector_6.3.2.tar.gz(r-4.5-noble)DatabaseConnector_6.3.2.tar.gz(r-4.4-noble)
DatabaseConnector_6.3.2.tgz(r-4.4-emscripten)DatabaseConnector_6.3.2.tgz(r-4.3-emscripten)
DatabaseConnector.pdf |DatabaseConnector.html✨
DatabaseConnector/json (API)
NEWS
# Install 'DatabaseConnector' in R: |
install.packages('DatabaseConnector', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/ohdsi/databaseconnector/issues
Pkgdown:https://ohdsi.github.io
Last updated 12 months agofrom:7ccc95d22f. Checks:OK: 1 WARNING: 1. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Nov 06 2024 |
R-4.5-linux | WARNING | Nov 06 2024 |
Exports:assertTempEmulationSchemaSetcomputeDataHashconnectcreateConnectionDetailscreateDbiConnectionDetailscreateZipFileDatabaseConnectorDriverdateAdddateDiffdateFromPartsdaydbAppendTabledbCanConnectdbClearResultdbColumnInfodbConnectdbCreateTabledbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListTablesdbmsdbReadTabledbRemoveTabledbSendQuerydbSendStatementdbUnloadDriverdbWriteTabledisconnectdownloadJdbcDriversdropEmulatedTempTableseoMonthexecuteSqlexistsTableextractQueryTimesgetAvailableJavaHeapSpacegetTableNamesinDatabaseSchemainsertTableisSqlReservedWordlowLevelExecuteSqllowLevelQuerySqllowLevelQuerySqlToAndromedamonthquerySqlquerySqlToAndromedarenderTranslateExecuteSqlrenderTranslateQueryApplyBatchedrenderTranslateQuerySqlrenderTranslateQuerySqlToAndromedarequiresTempEmulationyear
Dependencies:backportsbitbit64blobcheckmateclicliprcpp11crayonDBIdbplyrdigestdplyrfansigenericsgluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogresspurrrR6RcppreadrrJavarlangSqlRenderstringistringrtibbletidyrtidyselecttriebeardtzdburltoolsutf8vctrsvroomwithr
Connecting to a database
Rendered fromConnecting.Rmd
usingknitr::rmarkdown
on Nov 06 2024.Last update: 2023-11-29
Started: 2022-02-11
Querying a database
Rendered fromQuerying.Rmd
usingknitr::rmarkdown
on Nov 06 2024.Last update: 2023-11-29
Started: 2022-02-11
Using DatabaseConnector through DBI and dbplyr
Rendered fromDbiAndDbplyr.Rmd
usingknitr::rmarkdown
on Nov 06 2024.Last update: 2023-11-29
Started: 2023-01-30