{
  "_id": "6a26a29224555f66ed5222d5",
  "Package": "odbc",
  "Title": "Connect to ODBC Compatible Databases (using the DBI Interface)",
  "Version": "1.7.0",
  "Authors@R": "c(\nperson(\"Jim\", \"Hester\", role = \"aut\"),\nperson(\"Hadley\", \"Wickham\", , \"hadley@posit.co\", role = c(\"aut\", \"cre\")),\nperson(\"Oliver\", \"Gjoneski\", role = \"aut\"),\nperson(\"Simon\", \"Couch\", email = \"simon.couch@posit.co\", role = \"aut\"),\nperson(\"lexicalunit\", role = \"cph\",\ncomment = \"nanodbc library\"),\nperson(\"Google Inc.\", role = \"cph\",\ncomment = \"cctz library\"),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "A DBI-compatible interface to ODBC databases.",
  "License": "MIT + file LICENSE",
  "URL": "https://odbc.r-dbi.org, https://github.com/r-dbi/odbc,\nhttps://solutions.posit.co/connections/db/",
  "BugReports": "https://github.com/r-dbi/odbc/issues",
  "ByteCompile": "true",
  "Config/Needs/check": "pkgbuild",
  "Config/Needs/website": "tidyverse/tidytemplate",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.3",
  "SystemRequirements": "GNU make, An ODBC3 driver manager and drivers.",
  "Collate": "'RcppExports.R' 'aaa-odbc-data-type.R' 'connection-pane.R'\n'dbi-connection.R' 'odbc-connection.R' 'db.R' 'dbi-driver.R'\n'dbi-result.R' 'dbi-table.R' 'dbi.R' 'driver-access.R'\n'driver-bigquery.R' 'driver-databricks.R' 'driver-db2.R'\n'driver-hana.R' 'driver-hive.R' 'driver-impala.R'\n'driver-mysql.R' 'driver-netezza.R' 'driver-oracle.R'\n'driver-postgres.R' 'driver-redshift.R' 'driver-snowflake.R'\n'driver-spark.R' 'driver-sql-server.R' 'driver-sqlite.R'\n'driver-teradata.R' 'driver-vertica.R'\n'import-standalone-obj-type.R'\n'import-standalone-types-check.R' 'odbc-config.R'\n'odbc-data-sources.R' 'odbc-drivers.R' 'odbc-package.R'\n'odbc.R' 'utils.R' 'zzz.R'",
  "VignetteBuilder": "knitr",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-08 11:02:58 UTC",
    "User": "root"
  },
  "Author": "Jim Hester [aut], Hadley Wickham [aut, cre], Oliver Gjoneski\n[aut], Simon Couch [aut], lexicalunit [cph] (nanodbc library),\nGoogle Inc. [cph] (cctz library), Posit Software, PBC [cph,\nfnd]",
  "Maintainer": "Hadley Wickham <hadley@posit.co>",
  "Config/pak/sysreqs": "make unixodbc-dev",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-05-09 17:16:23 UTC",
  "RemoteUrl": "https://github.com/cran/odbc",
  "RemoteRef": "HEAD",
  "RemoteSha": "dd3117cce86bae9cabf8372d395716c212a7e666",
  "MD5sum": "ac441fd421ebf9c0e177a5e1d4a7f2c4",
  "_user": "cran",
  "_type": "src",
  "_file": "odbc_1.7.0.tar.gz",
  "_fileid": "0fd9108a11ae4608584689d2382abeac55ecc5455278470014cbecb03b52e76d",
  "_filesize": 591143,
  "_sha256": "0fd9108a11ae4608584689d2382abeac55ecc5455278470014cbecb03b52e76d",
  "_created": "2026-06-08T11:02:58.000Z",
  "_published": "2026-06-08T11:08:02.271Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 80079459144,
      "time": 173,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7478438224"
    },
    {
      "job": 80079459088,
      "time": 177,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7478438812"
    },
    {
      "job": 80079459074,
      "time": 224,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7478455539"
    },
    {
      "job": 80079459090,
      "time": 179,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7478439498"
    },
    {
      "job": 80078694136,
      "time": 267,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7478377896"
    },
    {
      "job": 80079459042,
      "time": 128,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/27133073362",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/odbc",
  "_commit": {
    "id": "dd3117cce86bae9cabf8372d395716c212a7e666",
    "author": "Hadley Wickham <hadley@posit.co>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.7.0\n",
    "time": 1778346983
  },
  "_maintainer": {
    "name": "Hadley Wickham",
    "email": "hadley@posit.co",
    "login": "hadley",
    "bluesky": "@hadley.nz",
    "description": "Chief Scientist at @posit-pbc",
    "uuid": 4196
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0.0",
      "role": "Depends"
    },
    {
      "package": "Rcpp",
      "role": "LinkingTo"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "blob",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "hms",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "Rcpp",
      "version": ">= 0.12.11",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "vctrs",
      "role": "Imports"
    },
    {
      "package": "connectcreds",
      "version": ">= 0.2.0",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "role": "Suggests"
    },
    {
      "package": "httr2",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "magrittr",
      "role": "Suggests"
    },
    {
      "package": "paws.common",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "snowflakeauth",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 26,
  "_updates": [
    {
      "week": "2025-35",
      "n": 1
    },
    {
      "week": "2025-36",
      "n": 1
    },
    {
      "week": "2025-49",
      "n": 1
    },
    {
      "week": "2025-52",
      "n": 1
    },
    {
      "week": "2026-19",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.6.2",
      "date": "2025-08-28"
    },
    {
      "name": "1.6.3",
      "date": "2025-09-05"
    },
    {
      "name": "1.6.4",
      "date": "2025-12-06"
    },
    {
      "name": "1.6.4.1",
      "date": "2025-12-24"
    },
    {
      "name": "1.7.0",
      "date": "2026-05-09"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "hadley",
      "count": 14,
      "uuid": 4196
    },
    {
      "user": "jimhester",
      "count": 7,
      "uuid": 205275
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 148777,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/odbc"
  },
  "_mentions": 2,
  "_devurl": "https://github.com/r-dbi/odbc",
  "_pkgdown": "https://odbc.r-dbi.org",
  "_searchresults": 3568,
  "_topics": [
    "unixodbc",
    "cpp"
  ],
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/odbc.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/r-dbi/odbc",
  "_realowner": "r-dbi",
  "_cranurl": false,
  "_releases": [
    {
      "version": "1.0.0",
      "date": "2017-02-05"
    },
    {
      "version": "1.0.1",
      "date": "2017-02-07"
    },
    {
      "version": "1.1.0",
      "date": "2017-06-23"
    },
    {
      "version": "1.1.1",
      "date": "2017-06-27"
    },
    {
      "version": "1.1.2",
      "date": "2017-10-02"
    },
    {
      "version": "1.1.3",
      "date": "2017-10-05"
    },
    {
      "version": "1.1.4",
      "date": "2018-01-11"
    },
    {
      "version": "1.1.5",
      "date": "2018-01-23"
    },
    {
      "version": "1.1.6",
      "date": "2018-06-09"
    },
    {
      "version": "1.2.0",
      "date": "2019-11-28"
    },
    {
      "version": "1.2.1",
      "date": "2019-12-05"
    },
    {
      "version": "1.2.2",
      "date": "2020-01-10"
    },
    {
      "version": "1.2.3",
      "date": "2020-06-18"
    },
    {
      "version": "1.3.0",
      "date": "2020-10-27"
    },
    {
      "version": "1.3.1",
      "date": "2021-03-16"
    },
    {
      "version": "1.3.2",
      "date": "2021-04-03"
    },
    {
      "version": "1.3.3",
      "date": "2021-11-30"
    },
    {
      "version": "1.3.4",
      "date": "2023-01-17"
    },
    {
      "version": "1.3.5",
      "date": "2023-06-29"
    },
    {
      "version": "1.4.0",
      "date": "2023-12-16"
    },
    {
      "version": "1.4.1",
      "date": "2023-12-21"
    },
    {
      "version": "1.4.2",
      "date": "2024-01-23"
    },
    {
      "version": "1.5.0",
      "date": "2024-06-05"
    },
    {
      "version": "1.6.0",
      "date": "2025-02-28"
    },
    {
      "version": "1.6.1",
      "date": "2025-03-27"
    },
    {
      "version": "1.6.2",
      "date": "2025-08-28"
    },
    {
      "version": "1.6.3",
      "date": "2025-09-05"
    },
    {
      "version": "1.6.4",
      "date": "2025-12-11"
    },
    {
      "version": "1.6.4.1",
      "date": "2025-12-24"
    },
    {
      "version": "1.7.0",
      "date": "2026-05-09"
    }
  ],
  "_exports": [
    "databricks",
    "dbAppendTable",
    "dbBegin",
    "dbBind",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbDataType",
    "dbDisconnect",
    "dbExecute",
    "dbExistsTable",
    "dbFetch",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsValid",
    "dbListFields",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteString",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendStatement",
    "dbWriteTable",
    "isTempTable",
    "odbc",
    "odbcDataType",
    "odbcEditDrivers",
    "odbcEditSystemDSN",
    "odbcEditUserDSN",
    "odbcListColumns",
    "odbcListConfig",
    "odbcListDataSources",
    "odbcListDrivers",
    "odbcListObjects",
    "odbcListObjectTypes",
    "odbcPreviewObject",
    "odbcSetTransactionIsolationLevel",
    "quote_value",
    "redshift",
    "show",
    "snowflake",
    "sqlCreateTable",
    "sqlData"
  ],
  "_help": [
    {
      "page": "databricks",
      "title": "Helper for Connecting to Databricks via ODBC",
      "topics": [
        "databricks",
        "DatabricksOdbcDriver-class",
        "dbConnect,DatabricksOdbcDriver-method"
      ]
    },
    {
      "page": "DBI-tables",
      "title": "Convenience functions for reading/writing DBMS tables",
      "topics": [
        "dbAppendTable,OdbcConnection-method",
        "DBI-tables",
        "dbWriteTable,OdbcConnection,character,data.frame-method",
        "dbWriteTable,OdbcConnection,Id,data.frame-method",
        "dbWriteTable,OdbcConnection,SQL,data.frame-method",
        "sqlCreateTable,OdbcConnection-method"
      ]
    },
    {
      "page": "dbListTables-OdbcConnection-method",
      "title": "List remote tables and fields for an ODBC connection",
      "topics": [
        "dbListTables,OdbcConnection-method"
      ]
    },
    {
      "page": "isTempTable",
      "title": "Helper method used to determine if a table identifier is that of a temporary table.",
      "topics": [
        "isTempTable",
        "isTempTable,OdbcConnection,Id-method",
        "isTempTable,OdbcConnection,SQL-method"
      ]
    },
    {
      "page": "dbConnect-OdbcDriver-method",
      "title": "Connect to a database via an ODBC driver",
      "topics": [
        "dbConnect",
        "dbConnect,OdbcDriver-method",
        "odbc"
      ]
    },
    {
      "page": "driver-Snowflake",
      "title": "Connecting to Snowflake via ODBC",
      "topics": [
        "dbExistsTableForWrite,Snowflake,character-method",
        "odbcConnectionColumns,Snowflake,character-method"
      ]
    },
    {
      "page": "odbcDataType",
      "title": "Return the corresponding ODBC data type for an R object",
      "topics": [
        "odbcDataType",
        "odbcDataType,ACCESS-method",
        "odbcDataType,ANY-method",
        "odbcDataType,BigQuery-method",
        "odbcDataType,Hive-method",
        "odbcDataType,Impala-method",
        "odbcDataType,Microsoft SQL Server-method",
        "odbcDataType,MySQL-method",
        "odbcDataType,NetezzaSQL-method",
        "odbcDataType,Oracle-method",
        "odbcDataType,PostgreSQL-method",
        "odbcDataType,Redshift-method",
        "odbcDataType,Snowflake-method",
        "odbcDataType,Spark SQL-method",
        "odbcDataType,SQLite-method",
        "odbcDataType,Teradata-method",
        "odbcDataType,Vertica Database-method"
      ]
    },
    {
      "page": "odbcListColumns",
      "title": "List columns in an object.",
      "topics": [
        "odbcListColumns"
      ]
    },
    {
      "page": "odbcListConfig",
      "title": "List locations of ODBC configuration files",
      "topics": [
        "odbcEditDrivers",
        "odbcEditSystemDSN",
        "odbcEditUserDSN",
        "odbcListConfig"
      ]
    },
    {
      "page": "odbcListDataSources",
      "title": "List Configured Data Source Names",
      "topics": [
        "odbcListDataSources"
      ]
    },
    {
      "page": "odbcListDrivers",
      "title": "List Configured ODBC Drivers",
      "topics": [
        "odbcListDrivers"
      ]
    },
    {
      "page": "odbcListObjects",
      "title": "List objects in a connection.",
      "topics": [
        "odbcListObjects"
      ]
    },
    {
      "page": "odbcListObjectTypes",
      "title": "Return the object hierarchy supported by a connection.",
      "topics": [
        "odbcListObjectTypes"
      ]
    },
    {
      "page": "odbcPreviewObject",
      "title": "Preview the data in an object.",
      "topics": [
        "odbcPreviewObject"
      ]
    },
    {
      "page": "odbcSetTransactionIsolationLevel",
      "title": "Set the Transaction Isolation Level for a Connection",
      "topics": [
        "odbcSetTransactionIsolationLevel"
      ]
    },
    {
      "page": "quote_value",
      "title": "Quote special character when connecting",
      "topics": [
        "quote_value"
      ]
    },
    {
      "page": "redshift",
      "title": "Helper for Connecting to Redshift via ODBC",
      "topics": [
        "dbConnect,RedshiftOdbcDriver-method",
        "redshift",
        "RedshiftOdbcDriver-class"
      ]
    },
    {
      "page": "snowflake",
      "title": "Helper for connecting to Snowflake via ODBC",
      "topics": [
        "dbConnect,SnowflakeOdbcDriver-method",
        "snowflake",
        "SnowflakeOdbcDriver-class"
      ]
    }
  ],
  "_pkglogo": "https://github.com/cran/odbc/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/cran/odbc/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "DBI",
    "glue",
    "hms",
    "lifecycle",
    "pkgconfig",
    "Rcpp",
    "rlang",
    "vctrs"
  ],
  "_sysdeps": [
    {
      "shlib": "libodbc",
      "package": "libodbc2",
      "headers": "unixodbc-dev",
      "source": "unixodbc",
      "version": "2.3.12-1ubuntu0.24.04.1",
      "name": "unixodbc",
      "homepage": "https://www.unixodbc.org",
      "description": "ODBC Driver Manager library for Unix"
    },
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "14.2.0-4ubuntu2~24.04.1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_vignettes": [
    {
      "source": "benchmarks.Rmd",
      "filename": "benchmarks.html",
      "title": "Benchmarks",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Setup",
        "Writing",
        "Reading"
      ],
      "created": "2023-12-16 02:37:32",
      "modified": "2023-12-16 02:37:32",
      "commits": 1
    },
    {
      "source": "develop.Rmd",
      "filename": "develop.html",
      "title": "Developing odbc",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Posit Professional Drivers",
        "Drivers",
        "Databases",
        "PostgreSQL",
        "MySQL",
        "SQL Server test setup",
        "SQLite",
        "Oracle",
        "On MacOS",
        "On Linux",
        "Snowflake",
        "Amazon Redshift",
        "RODBC"
      ],
      "created": "2023-12-16 02:37:32",
      "modified": "2026-05-09 17:16:23",
      "commits": 5
    },
    {
      "source": "setup.Rmd",
      "filename": "setup.html",
      "title": "Installing and Configuring Drivers",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Installation",
        "Windows",
        "MacOS",
        "Linux - Debian / Ubuntu",
        "Driver configuration",
        "Data source configuration",
        "Debugging driver and data source configurations",
        "Setting ODBCSYSINI"
      ],
      "created": "2023-12-16 02:37:32",
      "modified": "2024-06-06 02:42:23",
      "commits": 2
    }
  ],
  "_score": 10.793146504620154,
  "_indexed": false,
  "_nocasepkg": "odbc",
  "_universes": [
    "cran"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/odbc",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.7.0",
      "date": "2026-06-08T11:05:51.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "dd3117cce86bae9cabf8372d395716c212a7e666",
      "fileid": "89cebb7bc518efa807e4827ac65163049836065988b1aa76a932f26979f7364c",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27133073362"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.7.0",
      "date": "2026-06-08T11:05:50.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "dd3117cce86bae9cabf8372d395716c212a7e666",
      "fileid": "68b110b5f8c688b9d0aaf05a0ce3cba2e4d67e8f8c9f0381db0d915357bacaad",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27133073362"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.7.0",
      "date": "2026-06-08T11:06:41.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "dd3117cce86bae9cabf8372d395716c212a7e666",
      "fileid": "d3a1819ea2c3abd8cf713e33d6215ef30ae9ca504d4d984eeeb856edcaa47947",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27133073362"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.7.0",
      "date": "2026-06-08T11:05:51.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "dd3117cce86bae9cabf8372d395716c212a7e666",
      "fileid": "bd7a4036354337a3ba3496a32a06b3f454527ef61d5b217822a7d65893cc3cc5",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27133073362"
    }
  ]
}