{ "_id": "6ae5ef213d0f299392dd511d", "Package": "DatabaseConnector", "Type": "Package", "Title": "Connecting to Various Database Platforms", "Version": "8.0.0", "Date": "2026-10-01", "Authors@R": "c(\nperson(\"Martijn\", \"Schuemie\", email = \"schuemie@ohdsi.org\", role = c(\"aut\", \"cre\")),\nperson(\"Marc\", \"Suchard\", role = c(\"aut\")),\nperson(\"Adam\", \"Black\", role = c(\"aut\")),\nperson(\"Observational Health Data Science and Informatics\", role = c(\"cph\")),\nperson(\"Microsoft Inc.\", role = c(\"cph\"), comment = \"SQL Server JDBC driver\"),\nperson(\"PostgreSQL Global Development Group\", role = c(\"cph\"), comment = \"PostgreSQL JDBC driver\"),\nperson(\"Oracle Inc.\", role = c(\"cph\"), comment = \"Oracle JDBC driver\"),\nperson(\"Amazon Inc.\", role = c(\"cph\"), comment = \"RedShift JDBC driver\")\n)", "Description": "An R 'DataBase Interface' ('DBI') compatible interface to\nvarious database platforms ('PostgreSQL', 'Oracle', 'Microsoft\nSQL Server', 'Amazon Redshift', 'Microsoft Parallel Database\nWarehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery',\n'Snowflake', 'Spark', 'SQLite', and 'InterSystems IRIS'). Also\nincludes support for fetching data as 'Andromeda' objects. Uses\neither 'Java Database Connectivity' ('JDBC') or other 'DBI'\ndrivers to connect to databases.", "SystemRequirements": "Java (>= 8)", "License": "Apache License", "VignetteBuilder": "knitr", "URL": "https://ohdsi.github.io/DatabaseConnector/,\nhttps://github.com/OHDSI/DatabaseConnector", "BugReports": "https://github.com/OHDSI/DatabaseConnector/issues", "Copyright": "See file COPYRIGHTS", "Roxygen": "list(markdown = TRUE)", "Encoding": "UTF-8", "Config/roxygen2/version": "8.1.0", "Config/pak/sysreqs": "make default-jdk libicu-dev libx11-dev", "Repository": "https://ohdsi.r-universe.dev", "Date/Publication": "2026-10-01 14:54:06 UTC", "RemoteUrl": "https://github.com/ohdsi/databaseconnector", "RemoteRef": "HEAD", "RemoteSha": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-31 12:08:50 UTC", "User": "root" }, "Author": "Martijn Schuemie [aut, cre],\nMarc Suchard [aut],\nAdam Black [aut],\nObservational Health Data Science and Informatics [cph],\nMicrosoft Inc. [cph] (SQL Server JDBC driver),\nPostgreSQL Global Development Group [cph] (PostgreSQL JDBC driver),\nOracle Inc. [cph] (Oracle JDBC driver),\nAmazon Inc. [cph] (RedShift JDBC driver)", "Maintainer": "Martijn Schuemie ", "_user": "ohdsi", "_type": "src", "_file": "DatabaseConnector_8.0.0.tar.gz", "_fileid": "https://r2.ropensci.org/47ab88aaaa308394048403265864dfbfdd9ffa4680ad392a28d8280ce9c63e8b", "_filesize": 1110691, "_sha256": "47ab88aaaa308394048403265864dfbfdd9ffa4680ad392a28d8280ce9c63e8b", "_expires": "2027-02-08T13:37:35.000Z", "_created": "2026-10-31T12:08:50.000Z", "_published": "2026-10-31T13:37:37.139Z", "_upstream": "https://github.com/ohdsi/databaseconnector", "_status": "success", "_maintainer": { "name": "Martijn Schuemie", "email": "schuemie@ohdsi.org", "login": "schuemie", "description": "", "uuid": 6713328 }, "_jobs": [ { "job": 124533269783, "time": 165, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "13042132669" }, { "job": 124533269763, "time": 155, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "13042106651" }, { "job": 124533269766, "time": 1714, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "13044468711" }, { "job": 124533269817, "time": 123, "config": "macos-release-arm64", "r": "4.6.2", "check": "WARNING", "artifact": "13044186531" }, { "job": 124532504099, "time": 219, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "13041853561" }, { "job": 124533269789, "time": 118, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "13041624348" }, { "job": 124533269805, "time": 106, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "13042271349" }, { "job": 124533269806, "time": 110, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "13041878648" }, { "job": 124533269829, "time": 107, "config": "windows-release-x86_64", "r": "4.6.2", "check": "WARNING", "artifact": "13042331277" } ], "_buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645", "_commit": { "id": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "author": "schuemie ", "committer": "schuemie ", "message": "Updating CRAN SUBMISSION\n", "time": 1790866446 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.0.0", "role": "Depends" }, { "package": "rJava", "role": "Imports" }, { "package": "SqlRender", "version": ">= 1.19.7", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "DBI", "version": ">= 1.0.0", "role": "Imports" }, { "package": "urltools", "role": "Imports" }, { "package": "bit64", "role": "Imports" }, { "package": "checkmate", "role": "Imports" }, { "package": "digest", "role": "Imports" }, { "package": "dbplyr", "version": ">= 2.6.0", "role": "Imports" }, { "package": "aws.s3", "role": "Suggests" }, { "package": "R.utils", "role": "Suggests" }, { "package": "withr", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "DBItest", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "ssh", "role": "Suggests" }, { "package": "Andromeda", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "odbc", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "bigrquery", "role": "Suggests" }, { "package": "pool", "role": "Suggests" }, { "package": "ParallelLogger", "role": "Suggests" }, { "package": "AzureStor", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" } ], "_owner": "ohdsi", "_selfowned": true, "_usedby": 19, "_updates": [ { "week": "2025-47", "n": 1 }, { "week": "2026-02", "n": 6 }, { "week": "2026-05", "n": 1 }, { "week": "2026-13", "n": 1 }, { "week": "2026-20", "n": 5 }, { "week": "2026-21", "n": 4 }, { "week": "2026-23", "n": 1 }, { "week": "2026-39", "n": 8 }, { "week": "2026-40", "n": 4 } ], "_tags": [ { "name": "v7.1.0", "date": "2026-01-09" }, { "name": "v7.2.0", "date": "2026-06-29" }, { "name": "v8.0.0", "date": "2026-10-01" } ], "_topics": [ "hades", "openjdk" ], "_stars": 57, "_contributors": [ { "user": "schuemie", "count": 497, "uuid": 6713328 }, { "user": "ablack3", "count": 54, "uuid": 10227522 }, { "user": "msuchard", "count": 34, "uuid": 149039 }, { "user": "ioannanika", "count": 27, "uuid": 45609421 }, { "user": "bdeboe", "count": 25, "uuid": 12095468 }, { "user": "aklochkova", "count": 24, "uuid": 38942654 }, { "user": "anthonysena", "count": 22, "uuid": 12902366 }, { "user": "azimov", "count": 15, "uuid": 180659 }, { "user": "myounglai", "count": 13, "uuid": 26904261 }, { "user": "wivern", "count": 11, "uuid": 1109753 }, { "user": "ssuvorov-fls", "count": 7, "uuid": 46920469 }, { "user": "pavgra", "count": 6, "uuid": 10010071 }, { "user": "wibeasley", "count": 4, "uuid": 1372890 }, { "user": "gowthamrao", "count": 3, "uuid": 13936600 }, { "user": "tomwhite", "count": 3, "uuid": 85085 }, { "user": "egillax", "count": 2, "uuid": 24678081 }, { "user": "illorocks", "count": 2, "uuid": 26260521 }, { "user": "cgreich", "count": 1, "uuid": 766334 }, { "user": "fdefalco", "count": 1, "uuid": 6586384 }, { "user": "james-cockayne", "count": 1, "uuid": 150046545 }, { "user": "lastomato", "count": 1, "uuid": 662638 }, { "user": "pollychen-lab", "count": 1, "uuid": 265131177 }, { "user": "thecedarprince", "count": 1, "uuid": 29561456 }, { "user": "clairblacketer", "count": 1, "uuid": 12911960 }, { "user": "ericavoss", "count": 1, "uuid": 6305439 } ], "_userbio": { "uuid": 6570077, "type": "organization", "name": "Observational Health Data Sciences and Informatics", "followers": 1143 }, "_downloads": { "count": 4608, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DatabaseConnector" }, "_mentions": 2, "_devurl": "https://github.com/ohdsi/databaseconnector", "_pkgdown": "https://ohdsi.github.io/DatabaseConnector/", "_searchresults": 1192, "_abi": { "exports": [ { "key": "DatabaseConnector::DatabaseConnectorConnection", "hash": "22426871af8d177e" }, { "key": "DatabaseConnector::DatabaseConnectorDbiConnection", "hash": "9fc21e0166aa4b3e" }, { "key": "DatabaseConnector::DatabaseConnectorDbiResult", "hash": "0728bf18ca83f4f3" }, { "key": "DatabaseConnector::DatabaseConnectorDriver", "hash": "19c1ec5848638b01" }, { "key": "DatabaseConnector::DatabaseConnectorJdbcConnection", "hash": "397b46d1dde0b9d9" }, { "key": "DatabaseConnector::DatabaseConnectorJdbcResult", "hash": "f8d1f4f5e436a854" } ], "imports": [ { "key": "DBI::DBIConnection", "hash": "e723731c3dbaacdb" }, { "key": "DBI::DBIDriver", "hash": "cd2584b29cba3eab" }, { "key": "DBI::DBIObject", "hash": "09f3b098e445d20c" }, { "key": "DBI::DBIResult", "hash": "8c1c65010fa94832" } ] }, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DatabaseConnector.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/ohdsi/databaseconnector", "_realowner": "ohdsi", "_cranurl": true, "_releases": [ { "version": "2.1.2", "date": "2018-05-24" }, { "version": "2.1.3", "date": "2018-06-28" }, { "version": "2.1.4", "date": "2018-08-21" }, { "version": "2.2.0", "date": "2018-10-01" }, { "version": "2.2.1", "date": "2018-11-25" }, { "version": "2.3.0", "date": "2019-02-21" }, { "version": "2.4.1", "date": "2019-07-18" }, { "version": "2.4.2", "date": "2020-01-15" }, { "version": "3.0.0", "date": "2020-06-06" }, { "version": "4.0.0", "date": "2021-03-02" }, { "version": "4.0.2", "date": "2021-04-15" }, { "version": "5.0.0", "date": "2021-11-18" }, { "version": "5.0.2", "date": "2022-02-11" }, { "version": "5.0.3", "date": "2022-06-08" }, { "version": "5.0.4", "date": "2022-06-28" }, { "version": "5.1.0", "date": "2022-09-23" }, { "version": "6.0.0", "date": "2023-01-30" }, { "version": "6.1.0", "date": "2023-03-16" }, { "version": "6.2.0", "date": "2023-04-13" }, { "version": "6.2.1", "date": "2023-05-10" }, { "version": "6.2.2", "date": "2023-06-23" }, { "version": "6.2.3", "date": "2023-06-30" }, { "version": "6.2.4", "date": "2023-09-07" }, { "version": "6.3.0", "date": "2023-11-08" }, { "version": "6.3.1", "date": "2023-11-28" }, { "version": "6.3.2", "date": "2023-12-11" }, { "version": "6.3.3", "date": "2025-01-17" }, { "version": "6.4.0", "date": "2025-01-30" }, { "version": "7.0.0", "date": "2025-09-23" }, { "version": "7.1.0", "date": "2026-01-09" }, { "version": "7.2.0", "date": "2026-06-26" }, { "version": "8.0.0", "date": "2026-10-01" } ], "_exports": [ "assertTempEmulationSchemaSet", "computeDataHash", "connect", "createConnectionDetails", "createDbiConnectionDetails", "createZipFile", "DatabaseConnectorDriver", "dbAppendTable", "dbCanConnect", "dbClearResult", "dbColumnInfo", "dbConnect", "dbCreateTable", "dbDisconnect", "dbExecute", "dbExistsTable", "dbFetch", "dbGetInfo", "dbGetQuery", "dbGetRowCount", "dbGetRowsAffected", "dbGetStatement", "dbHasCompleted", "dbIsReadOnly", "dbIsValid", "dbListFields", "dbListTables", "dbms", "dbReadTable", "dbRemoveTable", "dbSendQuery", "dbSendStatement", "dbUnloadDriver", "dbWriteTable", "disconnect", "downloadJdbcDrivers", "dropEmulatedTempTables", "executeSql", "existsTable", "extractQueryTimes", "getAvailableJavaHeapSpace", "getTableNames", "inDatabaseSchema", "insertTable", "isSqlReservedWord", "querySql", "querySqlToAndromeda", "renderTranslateExecuteSql", "renderTranslateQueryApplyBatched", "renderTranslateQuerySql", "renderTranslateQuerySqlToAndromeda", "requiresTempEmulation", "sql_escape_logical" ], "_help": [ { "page": "assertTempEmulationSchemaSet", "title": "Assert the temp emulation schema is set", "topics": [ "assertTempEmulationSchemaSet" ] }, { "page": "computeDataHash", "title": "Compute hash of data", "topics": [ "computeDataHash" ] }, { "page": "connect", "title": "connect", "topics": [ "connect" ] }, { "page": "createConnectionDetails", "title": "createConnectionDetails", "topics": [ "createConnectionDetails" ] }, { "page": "createDbiConnectionDetails", "title": "Create DBI connection details", "topics": [ "createDbiConnectionDetails" ] }, { "page": "createZipFile", "title": "Compress files and/or folders into a single zip file", "topics": [ "createZipFile" ] }, { "page": "DatabaseConnectorDriver", "title": "Create a DatabaseConnectorDriver object", "topics": [ "DatabaseConnectorDriver" ] }, { "page": "dbAppendTable-DatabaseConnectorConnection-character-method", "title": "Insert rows into a table", "topics": [ "dbAppendTable,DatabaseConnectorConnection,character-method" ] }, { "page": "dbClearResult-DatabaseConnectorDbiResult-method", "title": "Clear a result set", "topics": [ "dbClearResult,DatabaseConnectorDbiResult-method" ] }, { "page": "dbClearResult-DatabaseConnectorJdbcResult-method", "title": "Clear a result set", "topics": [ "dbClearResult,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbColumnInfo-DatabaseConnectorDbiResult-method", "title": "Information about result types", "topics": [ "dbColumnInfo,DatabaseConnectorDbiResult-method" ] }, { "page": "dbColumnInfo-DatabaseConnectorJdbcResult-method", "title": "Information about result types", "topics": [ "dbColumnInfo,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbConnect-DatabaseConnectorDriver-method", "title": "Create a connection to a DBMS", "topics": [ "dbConnect,DatabaseConnectorDriver-method" ] }, { "page": "dbCreateTable-DatabaseConnectorConnection-method", "title": "Create a table in the database", "topics": [ "dbCreateTable,DatabaseConnectorConnection-method" ] }, { "page": "dbDisconnect-DatabaseConnectorConnection-method", "title": "Disconnect (close) a connection", "topics": [ "dbDisconnect,DatabaseConnectorConnection-method" ] }, { "page": "dbExecute-DatabaseConnectorDbiConnection-character-method", "title": "Change database state", "topics": [ "dbExecute,DatabaseConnectorDbiConnection,character-method" ] }, { "page": "dbExecute-DatabaseConnectorJdbcConnection-character-method", "title": "Change database state", "topics": [ "dbExecute,DatabaseConnectorJdbcConnection,character-method" ] }, { "page": "dbExistsTable-DatabaseConnectorConnection-character-method", "title": "Does a table exist?", "topics": [ "dbExistsTable,DatabaseConnectorConnection,character-method" ] }, { "page": "dbFetch-DatabaseConnectorDbiResult-method", "title": "Fetch records from a previously executed query", "topics": [ "dbFetch,DatabaseConnectorDbiResult-method" ] }, { "page": "dbFetch-DatabaseConnectorJdbcResult-method", "title": "Fetch records from a previously executed query", "topics": [ "dbFetch,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbGetInfo-DatabaseConnectorConnection-method", "title": "Get DBMS metadata", "topics": [ "dbGetInfo,DatabaseConnectorConnection-method" ] }, { "page": "dbGetInfo-DatabaseConnectorDriver-method", "title": "Get DBMS metadata", "topics": [ "dbGetInfo,DatabaseConnectorDriver-method" ] }, { "page": "dbGetQuery-DatabaseConnectorDbiConnection-character-method", "title": "Retrieve results from a query", "topics": [ "dbGetQuery,DatabaseConnectorDbiConnection,character-method" ] }, { "page": "dbGetQuery-DatabaseConnectorJdbcConnection-character-method", "title": "Retrieve results from a query", "topics": [ "dbGetQuery,DatabaseConnectorJdbcConnection,character-method" ] }, { "page": "dbGetRowCount-DatabaseConnectorDbiResult-method", "title": "The number of rows fetched so far", "topics": [ "dbGetRowCount,DatabaseConnectorDbiResult-method" ] }, { "page": "dbGetRowCount-DatabaseConnectorJdbcResult-method", "title": "The number of rows fetched so far", "topics": [ "dbGetRowCount,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbGetRowsAffected-DatabaseConnectorDbiResult-method", "title": "The number of rows affected", "topics": [ "dbGetRowsAffected,DatabaseConnectorDbiResult-method" ] }, { "page": "dbGetRowsAffected-DatabaseConnectorJdbcResult-method", "title": "The number of rows affected", "topics": [ "dbGetRowsAffected,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbGetStatement-DatabaseConnectorDbiResult-method", "title": "Get the statement associated with a result set", "topics": [ "dbGetStatement,DatabaseConnectorDbiResult-method" ] }, { "page": "dbGetStatement-DatabaseConnectorJdbcResult-method", "title": "Get the statement associated with a result set", "topics": [ "dbGetStatement,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbHasCompleted-DatabaseConnectorDbiResult-method", "title": "Completion status", "topics": [ "dbHasCompleted,DatabaseConnectorDbiResult-method" ] }, { "page": "dbHasCompleted-DatabaseConnectorJdbcResult-method", "title": "Completion status", "topics": [ "dbHasCompleted,DatabaseConnectorJdbcResult-method" ] }, { "page": "dbIsValid-DatabaseConnectorDbiConnection-method", "title": "Is this DBMS object still valid?", "topics": [ "dbIsValid,DatabaseConnectorDbiConnection-method" ] }, { "page": "dbIsValid-DatabaseConnectorJdbcConnection-method", "title": "Is this DBMS object still valid?", "topics": [ "dbIsValid,DatabaseConnectorJdbcConnection-method" ] }, { "page": "dbListFields-DatabaseConnectorConnection-character-method", "title": "List field names of a remote table", "topics": [ "dbListFields,DatabaseConnectorConnection,character-method" ] }, { "page": "dbListTables-DatabaseConnectorConnection-method", "title": "List remote tables", "topics": [ "dbListTables,DatabaseConnectorConnection-method" ] }, { "page": "dbms", "title": "Get the database platform from a connection", "topics": [ "dbms" ] }, { "page": "dbplyr_edition.DatabaseConnectorConnection", "title": "Declare dbplyr backend edition", "topics": [ "dbplyr_edition.DatabaseConnectorConnection", "dbplyr_edition.DatabaseConnectorDbiConnection", "dbplyr_edition.DatabaseConnectorJdbcConnection" ] }, { "page": "dbReadTable-DatabaseConnectorConnection-character-method", "title": "Read database tables as data frames", "topics": [ "dbReadTable,DatabaseConnectorConnection,character-method" ] }, { "page": "dbRemoveTable-DatabaseConnectorConnection-ANY-method", "title": "Remove a table from the database", "topics": [ "dbRemoveTable,DatabaseConnectorConnection,ANY-method" ] }, { "page": "dbSendQuery-DatabaseConnectorDbiConnection-character-method", "title": "Execute a query on a given database connection", "topics": [ "dbSendQuery,DatabaseConnectorDbiConnection,character-method" ] }, { "page": "dbSendQuery-DatabaseConnectorJdbcConnection-character-method", "title": "Execute a query on a given database connection", "topics": [ "dbSendQuery,DatabaseConnectorJdbcConnection,character-method" ] }, { "page": "dbSendStatement-DatabaseConnectorConnection-character-method", "title": "Execute a data manipulation statement on a given database connection", "topics": [ "dbSendStatement,DatabaseConnectorConnection,character-method" ] }, { "page": "dbUnloadDriver-DatabaseConnectorDriver-method", "title": "Load and unload database drivers", "topics": [ "dbUnloadDriver,DatabaseConnectorDriver-method" ] }, { "page": "dbWriteTable-DatabaseConnectorConnection-ANY-method", "title": "Copy data frames to database tables", "topics": [ "dbWriteTable,DatabaseConnectorConnection,ANY-method" ] }, { "page": "disconnect", "title": "Disconnect from the server", "topics": [ "disconnect" ] }, { "page": "downloadJdbcDrivers", "title": "Download DatabaseConnector JDBC Jar files", "topics": [ "downloadJdbcDrivers" ] }, { "page": "dropEmulatedTempTables", "title": "Drop all emulated temp tables.", "topics": [ "dropEmulatedTempTables" ] }, { "page": "executeSql", "title": "Execute SQL code", "topics": [ "executeSql" ] }, { "page": "existsTable", "title": "Does the table exist?", "topics": [ "existsTable" ] }, { "page": "extractQueryTimes", "title": "Extract query times from a 'ParallelLogger' log file", "topics": [ "extractQueryTimes" ] }, { "page": "getAvailableJavaHeapSpace", "title": "Get available Java heap space", "topics": [ "getAvailableJavaHeapSpace" ] }, { "page": "getTableNames", "title": "List all tables in a database schema.", "topics": [ "getTableNames" ] }, { "page": "inDatabaseSchema", "title": "Refer to a table in a database schema", "topics": [ "inDatabaseSchema" ] }, { "page": "insertTable", "title": "Insert a table on the server", "topics": [ "insertTable" ] }, { "page": "isSqlReservedWord", "title": "Test a character vector of SQL names for SQL reserved words", "topics": [ "isSqlReservedWord" ] }, { "page": "jdbcDrivers", "title": "How to download and use JDBC drivers for the various data platforms.", "topics": [ "jdbcDrivers" ] }, { "page": "querySql", "title": "Retrieve data to a data.frame", "topics": [ "querySql" ] }, { "page": "querySqlToAndromeda", "title": "Retrieves data to a local Andromeda object", "topics": [ "querySqlToAndromeda" ] }, { "page": "renderTranslateExecuteSql", "title": "Render, translate, execute SQL code", "topics": [ "renderTranslateExecuteSql" ] }, { "page": "renderTranslateQueryApplyBatched", "title": "Render, translate, and perform process to batches of data.", "topics": [ "renderTranslateQueryApplyBatched" ] }, { "page": "renderTranslateQuerySql", "title": "Render, translate, and query to data.frame", "topics": [ "renderTranslateQuerySql" ] }, { "page": "renderTranslateQuerySqlToAndromeda", "title": "Render, translate, and query to local Andromeda", "topics": [ "renderTranslateQuerySqlToAndromeda" ] }, { "page": "requiresTempEmulation", "title": "Does the DBMS require temp table emulation?", "topics": [ "requiresTempEmulation" ] } ], "_readme": "https://github.com/ohdsi/databaseconnector/raw/HEAD/README.md", "_rundeps": [ "backports", "bit", "bit64", "blob", "checkmate", "cli", "clipr", "cpp11", "crayon", "DBI", "dbplyr", "digest", "dplyr", "generics", "glue", "hms", "lifecycle", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readr", "rJava", "rlang", "SqlRender", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "triebeard", "tzdb", "urltools", "utf8", "vctrs", "vroom", "withr" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-25-jre-headless", "headers": "openjdk-25-jre-headless", "source": "openjdk", "version": "25.0.4.1+1-1~26.04.4", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "Connecting.Rmd", "filename": "Connecting.html", "title": "Connecting to a database", "author": "Martijn J. Schuemie", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Obtaining drivers", "The JAR folder", "Obtaining drivers for SQL Server, Oracle, PostgreSQL, PDW, Spark, RedShift, Snowflake, BigQuery, and Synapse", "Obtaining drivers for Netezza, Impala and InterSystems IRIS", "Obtaining drivers for SQLite or DuckDb", "Creating a connection", "Using Windows Authentication for SQL Server", "Connecting to a SQLite database", "Connecting with Windows authentication from a non-windows machine" ], "created": "2022-02-09 08:01:42", "modified": "2026-01-08 12:51:34", "commits": 5 }, { "source": "Querying.Rmd", "filename": "Querying.html", "title": "Querying a database", "author": "Martijn J. Schuemie", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Querying", "Querying using Andromeda objects", "Querying different platforms using the same SQL", "Inserting tables", "Logging all queries" ], "created": "2022-02-09 08:01:42", "modified": "2023-01-30 11:45:32", "commits": 2 }, { "source": "DbiAndDbplyr.Rmd", "filename": "DbiAndDbplyr.html", "title": "Using DatabaseConnector through DBI and dbplyr", "author": "Martijn J. Schuemie", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Connecting", "Querying", "Using dbplyr", "Date functions", "Allowed table and field names in dbplyr", "Temp tables", "Temp tables in dbplyr", "Cleaning up emulated temp tables", "Closing the connection" ], "created": "2023-01-30 11:45:32", "modified": "2023-01-30 11:45:32", "commits": 1 } ], "_score": 13.06311344303495, "_indexed": true, "_nocasepkg": "databaseconnector", "_universes": [ "ohdsi", "schuemie" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "8.0.0", "date": "2026-10-31T12:11:22.000Z", "distro": "resolute", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/307155b544bb9d8825c3e930f3cb53e171e24fb8c96eb894f6660aa33fd05afa", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.6.1", "os": "linux", "version": "8.0.0", "date": "2026-10-31T12:11:16.000Z", "distro": "resolute", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/e81935fa4dace510346c8c271f6f5a2bb87f352eb19bf16dc6d68337c8387304", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.5.3", "os": "mac", "version": "8.0.0", "date": "2026-10-31T13:36:45.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/622cfcfe38d1eb4de4a42f41f6b037bc66ccc3f75c51fdaf0a2ed814d38b2deb", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.6.2", "os": "mac", "version": "8.0.0", "date": "2026-10-31T13:10:21.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/fb4a2d751480fe263aa3e4c281181680137ceea3cd5f67a9f6fcac7bc552790c", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.6.0", "os": "wasm", "version": "8.0.0", "date": "2026-10-31T12:11:13.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/9e88e4bb60c95885ff152ccf5e02e1033b100e1f035c471d7bee33302f619f11", "status": "success", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.7.0", "os": "win", "version": "8.0.0", "date": "2026-10-31T12:10:09.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/05a17a0c83bdd76ca4f03d3af9af93b0c65a57d2264c455ca65829403402aae9", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.5.3", "os": "win", "version": "8.0.0", "date": "2026-10-31T12:10:23.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/3e5a92b0e35a3832a359f73bdf9592aa9dcdcff66ded10a4cd1139d4f189b226", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" }, { "r": "4.6.2", "os": "win", "version": "8.0.0", "date": "2026-10-31T12:10:10.000Z", "commit": "46f8bbc7ae361e2557e53ff353b4804594f530e3", "fileid": "https://r2.ropensci.org/ab2e07da401d941f5aafe36703fc636cb686165c412bdf7c5dc11c1a74ebad16", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/41199540645" } ] }