{
  "_id": "6a129dbcacfb0bcc41d0f954",
  "Package": "DBI",
  "Title": "R Database Interface",
  "Version": "1.3.0.9010",
  "Date": "2026-05-24",
  "Authors@R": "c(\nperson(\"R Special Interest Group on Databases (R-SIG-DB)\", role = \"aut\"),\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"R Consortium\", role = \"fnd\")\n)",
  "Description": "A database interface definition for communication between\nR and relational database management systems.  All classes in\nthis package are virtual and need to be extended by the various\nR/DBMS implementations.",
  "License": "LGPL (>= 2.1)",
  "URL": "https://dbi.r-dbi.org, https://github.com/r-dbi/DBI",
  "BugReports": "https://github.com/r-dbi/DBI/issues",
  "VignetteBuilder": "knitr",
  "Config/autostyle/scope": "line_breaks",
  "Config/autostyle/strict": "false",
  "Config/Needs/check": "r-dbi/DBItest",
  "Config/Needs/website": "r-dbi/DBItest, r-dbi/dbitemplate, adbi,\nAzureKusto, bigrquery, DatabaseConnector, dittodb, duckdb,\nimplyr, lazysf, odbc, pool, RAthena, IMSMWU/RClickhouse, RH2,\nRJDBC, RMariaDB, RMySQL, RPostgres, RPostgreSQL, RPresto,\nRSQLite, sergeant, sparklyr, withr",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "Config/roxygen2/version": "8.0.0.9000",
  "Repository": "https://cynkra.r-universe.dev",
  "Date/Publication": "2026-05-24 04:57:22 UTC",
  "RemoteUrl": "https://github.com/r-dbi/DBI",
  "RemoteRef": "HEAD",
  "RemoteSha": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 06:37:05 UTC",
    "User": "root"
  },
  "Author": "R Special Interest Group on Databases (R-SIG-DB) [aut],\nHadley Wickham [aut],\nKirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>),\nR Consortium [fnd]",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "MD5sum": "01011d3ab8bce51624b2e4e8db135b35",
  "_user": "cynkra",
  "_type": "src",
  "_file": "DBI_1.3.0.9010.tar.gz",
  "_fileid": "3d0ae284fa8d7c0ac37696e15924444d2d8a97ca1f287f395bd16a609fa69f4b",
  "_filesize": 1178140,
  "_sha256": "3d0ae284fa8d7c0ac37696e15924444d2d8a97ca1f287f395bd16a609fa69f4b",
  "_created": "2026-05-24T06:37:05.000Z",
  "_published": "2026-05-24T06:42:04.847Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77577773044,
      "time": 130,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7182942538"
    },
    {
      "job": 77577773040,
      "time": 136,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182943188"
    },
    {
      "job": 77577773041,
      "time": 79,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7182956066"
    },
    {
      "job": 77577773045,
      "time": 80,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182955382"
    },
    {
      "job": 77577616782,
      "time": 194,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182929912"
    },
    {
      "job": 77577773048,
      "time": 113,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182941101"
    },
    {
      "job": 77577773052,
      "time": 97,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7182939230"
    },
    {
      "job": 77577773058,
      "time": 102,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7182939908"
    },
    {
      "job": 77577773060,
      "time": 262,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182956307"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/r-dbi/DBI",
  "_commit": {
    "id": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
    "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "fledge: Bump version to 1.3.0.9010 (#681)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1779598642
  },
  "_maintainer": {
    "name": "Kirill Müller",
    "email": "kirill@cynkra.com",
    "login": "krlmlr",
    "orcid": "0000-0002-1416-3412",
    "description": "Away from most OSS work until September 2026.",
    "uuid": 1741643
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "methods",
      "role": "Depends"
    },
    {
      "package": "R",
      "version": ">= 3.0.0",
      "role": "Depends"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "blob",
      "role": "Suggests"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "version": ">= 1.8.2",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "downlit",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "glue",
      "role": "Suggests"
    },
    {
      "package": "hms",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "magrittr",
      "role": "Suggests"
    },
    {
      "package": "nanoarrow",
      "version": ">= 0.3.0.1",
      "role": "Suggests"
    },
    {
      "package": "otel",
      "role": "Suggests"
    },
    {
      "package": "otelsdk",
      "role": "Suggests"
    },
    {
      "package": "RMariaDB",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rprojroot",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "version": ">= 1.1-2",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "vctrs",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    }
  ],
  "_owner": "r-dbi",
  "_selfowned": false,
  "_usedby": 3226,
  "_updates": [
    {
      "week": "2025-31",
      "n": 2
    },
    {
      "week": "2025-36",
      "n": 4
    },
    {
      "week": "2025-41",
      "n": 3
    },
    {
      "week": "2025-44",
      "n": 2
    },
    {
      "week": "2025-45",
      "n": 3
    },
    {
      "week": "2025-46",
      "n": 4
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-07",
      "n": 5
    },
    {
      "week": "2026-09",
      "n": 2
    },
    {
      "week": "2026-10",
      "n": 5
    },
    {
      "week": "2026-11",
      "n": 4
    },
    {
      "week": "2026-17",
      "n": 4
    },
    {
      "week": "2026-18",
      "n": 1
    },
    {
      "week": "2026-19",
      "n": 9
    },
    {
      "week": "2026-20",
      "n": 8
    },
    {
      "week": "2026-21",
      "n": 3
    }
  ],
  "_tags": [
    {
      "name": "v1.2.3.9030",
      "date": "2025-08-01"
    },
    {
      "name": "v1.2.3.9031",
      "date": "2025-09-05"
    },
    {
      "name": "v1.2.3.9032",
      "date": "2025-09-06"
    },
    {
      "name": "v1.2.3.9033",
      "date": "2025-11-01"
    },
    {
      "name": "v1.2.3.9034",
      "date": "2025-11-08"
    },
    {
      "name": "v1.2.3.9035",
      "date": "2025-11-10"
    },
    {
      "name": "v1.2.3.9036",
      "date": "2025-11-12"
    },
    {
      "name": "v1.2.3.9037",
      "date": "2025-11-17"
    },
    {
      "name": "v1.2.3.9038",
      "date": "2026-01-14"
    },
    {
      "name": "v1.2.3.9039",
      "date": "2026-02-11"
    },
    {
      "name": "v1.3.0",
      "date": "2026-02-20"
    },
    {
      "name": "v1.3.0.9000",
      "date": "2026-02-26"
    },
    {
      "name": "v1.3.0.9001",
      "date": "2026-03-07"
    },
    {
      "name": "v1.3.0.9002",
      "date": "2026-03-08"
    },
    {
      "name": "v1.3.0.9003",
      "date": "2026-03-12"
    },
    {
      "name": "v1.3.0.9004",
      "date": "2026-04-24"
    },
    {
      "name": "v1.3.0.9005",
      "date": "2026-04-25"
    },
    {
      "name": "v1.3.0.9006",
      "date": "2026-05-04"
    },
    {
      "name": "v1.3.0.9007",
      "date": "2026-05-06"
    },
    {
      "name": "v1.3.0.9008",
      "date": "2026-05-13"
    },
    {
      "name": "v1.3.0.9009",
      "date": "2026-05-16"
    },
    {
      "name": "v1.3.0.9010",
      "date": "2026-05-24"
    }
  ],
  "_topics": [
    "database",
    "interface"
  ],
  "_stars": 317,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1477,
      "uuid": 1741643
    },
    {
      "user": "hadley",
      "count": 137,
      "uuid": 4196
    },
    {
      "user": "hannes",
      "count": 28,
      "uuid": 227792
    },
    {
      "user": "bborgesr",
      "count": 17,
      "uuid": 6527540
    },
    {
      "user": "nbenn",
      "count": 15,
      "uuid": 3158446
    },
    {
      "user": "indrajeetpatil",
      "count": 8,
      "uuid": 11330453
    },
    {
      "user": "jawond",
      "count": 8,
      "uuid": 61393184
    },
    {
      "user": "maelle",
      "count": 7,
      "uuid": 8360597
    },
    {
      "user": "eauleaf",
      "count": 6,
      "uuid": 81445509
    },
    {
      "user": "cutterkom",
      "count": 5,
      "uuid": 4574033
    },
    {
      "user": "renkun-ken",
      "count": 5,
      "uuid": 4662568
    },
    {
      "user": "wibeasley",
      "count": 4,
      "uuid": 1372890
    },
    {
      "user": "michaelchirico",
      "count": 2,
      "uuid": 7606389
    },
    {
      "user": "raffscallion",
      "count": 2,
      "uuid": 12927407
    },
    {
      "user": "salim-b",
      "count": 2,
      "uuid": 20040931
    },
    {
      "user": "rnorberg",
      "count": 2,
      "uuid": 2624108
    },
    {
      "user": "yutannihilation",
      "count": 2,
      "uuid": 1978793
    },
    {
      "user": "shikokuchuo",
      "count": 1,
      "uuid": 53399081
    },
    {
      "user": "web-flow",
      "count": 1,
      "uuid": 19864447
    },
    {
      "user": "jeroenjanssens",
      "count": 1,
      "uuid": 1368256
    },
    {
      "user": "jimhester",
      "count": 1,
      "uuid": 205275
    },
    {
      "user": "aryoda",
      "count": 1,
      "uuid": 11374410
    },
    {
      "user": "mdsumner",
      "count": 1,
      "uuid": 4107631
    },
    {
      "user": "mvkorpel",
      "count": 1,
      "uuid": 2980656
    },
    {
      "user": "richfitz",
      "count": 1,
      "uuid": 1558093
    },
    {
      "user": "jarauh",
      "count": 1,
      "uuid": 24244435
    },
    {
      "user": "klin333",
      "count": 1,
      "uuid": 17423839
    }
  ],
  "_userbio": {
    "uuid": 38209788,
    "type": "organization",
    "name": "cynkra",
    "description": "We support your business and the people behind it by helping you pick the right tools, implementing and supporting solutions, training and code review."
  },
  "_downloads": {
    "count": 717300,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DBI"
  },
  "_mentions": 12,
  "_devurl": "https://github.com/r-dbi/dbi",
  "_pkgdown": "https://dbi.r-dbi.org",
  "_searchresults": 28608,
  "_metadata": {
    "category": "Database",
    "cynkra_team_members": "kirill"
  },
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/DBI.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/r-dbi/dbi",
  "_realowner": "r-dbi",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1-2",
      "date": "2001-12-19"
    },
    {
      "version": "0.1-3",
      "date": "2002-05-20"
    },
    {
      "version": "0.1-4",
      "date": "2002-08-27"
    },
    {
      "version": "0.1-5",
      "date": "2003-04-07"
    },
    {
      "version": "0.1-6",
      "date": "2003-06-16"
    },
    {
      "version": "0.1-7",
      "date": "2003-11-12"
    },
    {
      "version": "0.1-8",
      "date": "2004-04-13"
    },
    {
      "version": "0.1-9",
      "date": "2005-04-07"
    },
    {
      "version": "0.1-10",
      "date": "2006-01-28"
    },
    {
      "version": "0.1-11",
      "date": "2006-10-27"
    },
    {
      "version": "0.1-12",
      "date": "2006-12-04"
    },
    {
      "version": "0.2-0",
      "date": "2007-03-21"
    },
    {
      "version": "0.2-1",
      "date": "2007-03-28"
    },
    {
      "version": "0.2-2",
      "date": "2007-04-15"
    },
    {
      "version": "0.2-3",
      "date": "2007-05-01"
    },
    {
      "version": "0.2-4",
      "date": "2007-10-17"
    },
    {
      "version": "0.2-5",
      "date": "2009-12-22"
    },
    {
      "version": "0.2-6",
      "date": "2013-04-21"
    },
    {
      "version": "0.2-7",
      "date": "2013-05-09"
    },
    {
      "version": "0.3.0",
      "date": "2014-09-02"
    },
    {
      "version": "0.3.1",
      "date": "2014-09-24"
    },
    {
      "version": "0.4",
      "date": "2016-05-02"
    },
    {
      "version": "0.4-1",
      "date": "2016-05-08"
    },
    {
      "version": "0.5",
      "date": "2016-08-11"
    },
    {
      "version": "0.5-1",
      "date": "2016-09-09"
    },
    {
      "version": "0.6",
      "date": "2017-03-09"
    },
    {
      "version": "0.6-1",
      "date": "2017-04-01"
    },
    {
      "version": "0.7",
      "date": "2017-06-18"
    },
    {
      "version": "0.8",
      "date": "2018-03-02"
    },
    {
      "version": "1.0.0",
      "date": "2018-05-02"
    },
    {
      "version": "1.1.0",
      "date": "2019-12-15"
    },
    {
      "version": "1.1.1",
      "date": "2021-01-15"
    },
    {
      "version": "1.1.2",
      "date": "2021-12-20"
    },
    {
      "version": "1.1.3",
      "date": "2022-06-18"
    },
    {
      "version": "1.2.0",
      "date": "2023-12-21"
    },
    {
      "version": "1.2.1",
      "date": "2024-01-12"
    },
    {
      "version": "1.2.2",
      "date": "2024-02-16"
    },
    {
      "version": "1.2.3",
      "date": "2024-06-02"
    },
    {
      "version": "1.3.0",
      "date": "2026-02-25"
    }
  ],
  "_exports": [
    ".SQL92Keywords",
    "ANSI",
    "dbAppendTable",
    "dbAppendTableArrow",
    "dbBegin",
    "dbBind",
    "dbBindArrow",
    "dbBreak",
    "dbCallProc",
    "dbCanConnect",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbCreateTable",
    "dbCreateTableArrow",
    "dbDataType",
    "dbDisconnect",
    "dbDriver",
    "dbExecute",
    "dbExistsTable",
    "dbFetch",
    "dbFetchArrow",
    "dbFetchArrowChunk",
    "dbGetConnectArgs",
    "dbGetDBIVersion",
    "dbGetException",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetQueryArrow",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListConnections",
    "dbListFields",
    "dbListObjects",
    "dbListResults",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbReadTable",
    "dbReadTableArrow",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendQueryArrow",
    "dbSendStatement",
    "dbSetDataMappings",
    "dbUnloadDriver",
    "dbUnquoteIdentifier",
    "dbWithTransaction",
    "dbWriteTable",
    "dbWriteTableArrow",
    "fetch",
    "Id",
    "isSQLKeyword",
    "isSQLKeyword.default",
    "make.db.names",
    "make.db.names.default",
    "show",
    "SQL",
    "sqlAppendTable",
    "sqlAppendTableTemplate",
    "sqlColumnToRownames",
    "sqlCommentSpec",
    "sqlCreateTable",
    "sqlData",
    "sqlInterpolate",
    "SQLKeywords",
    "sqlParseVariables",
    "sqlParseVariablesImpl",
    "sqlQuoteSpec",
    "sqlRownamesToColumn"
  ],
  "_help": [
    {
      "page": "DBI-package",
      "title": "DBI: R Database Interface",
      "topics": [
        "DBI-package",
        "DBI"
      ]
    },
    {
      "page": "dot-SQL92Keywords",
      "title": "Keywords according to the SQL-92 standard",
      "topics": [
        ".SQL92Keywords"
      ]
    },
    {
      "page": "dbAppendTable",
      "title": "Insert rows into a table",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbAppendTable"
      ]
    },
    {
      "page": "dbAppendTableArrow",
      "title": "Insert rows into a table from an Arrow stream",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbAppendTableArrow"
      ]
    },
    {
      "page": "transactions",
      "title": "Begin/commit/rollback SQL transactions",
      "topics": [
        "dbBegin",
        "dbCommit",
        "dbRollback",
        "transactions"
      ]
    },
    {
      "page": "dbBind",
      "title": "Bind values to a parameterized/prepared statement",
      "concept": [
        "DBIResult generics",
        "DBIResultArrow generics",
        "command execution generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbBind",
        "dbBindArrow"
      ]
    },
    {
      "page": "dbCanConnect",
      "title": "Check if a connection to a DBMS can be established",
      "concept": [
        "DBIDriver generics"
      ],
      "topics": [
        "dbCanConnect"
      ]
    },
    {
      "page": "dbClearResult",
      "title": "Clear a result set",
      "concept": [
        "DBIResult generics",
        "DBIResultArrow generics",
        "command execution generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbClearResult"
      ]
    },
    {
      "page": "dbColumnInfo",
      "title": "Information about result types",
      "concept": [
        "DBIResult generics"
      ],
      "topics": [
        "dbColumnInfo"
      ]
    },
    {
      "page": "dbConnect",
      "title": "Create a connection to a DBMS",
      "concept": [
        "DBIConnector generics",
        "DBIDriver generics"
      ],
      "topics": [
        "dbConnect"
      ]
    },
    {
      "page": "dbCreateTable",
      "title": "Create a table in the database",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbCreateTable"
      ]
    },
    {
      "page": "dbCreateTableArrow",
      "title": "Create a table in the database based on an Arrow object",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbCreateTableArrow"
      ]
    },
    {
      "page": "dbDataType",
      "title": "Determine the SQL data type of an object",
      "concept": [
        "DBIConnection generics",
        "DBIConnector generics",
        "DBIDriver generics"
      ],
      "topics": [
        "dbDataType"
      ]
    },
    {
      "page": "dbDisconnect",
      "title": "Disconnect (close) a connection",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbDisconnect"
      ]
    },
    {
      "page": "dbExecute",
      "title": "Change database state",
      "concept": [
        "DBIConnection generics",
        "command execution generics"
      ],
      "topics": [
        "dbExecute"
      ]
    },
    {
      "page": "dbExistsTable",
      "title": "Does a table exist?",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbExistsTable"
      ]
    },
    {
      "page": "dbFetch",
      "title": "Fetch records from a previously executed query",
      "concept": [
        "DBIResult generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbFetch",
        "fetch"
      ]
    },
    {
      "page": "dbFetchArrow",
      "title": "Fetch records from a previously executed query as an Arrow object",
      "concept": [
        "DBIResultArrow generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbFetchArrow"
      ]
    },
    {
      "page": "dbFetchArrowChunk",
      "title": "Fetch the next batch of records from a previously executed query as an Arrow object",
      "concept": [
        "DBIResultArrow generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbFetchArrowChunk"
      ]
    },
    {
      "page": "dbGetConnectArgs",
      "title": "Get connection arguments",
      "concept": [
        "DBIConnector generics"
      ],
      "topics": [
        "dbGetConnectArgs"
      ]
    },
    {
      "page": "dbGetInfo",
      "title": "Get DBMS metadata",
      "concept": [
        "DBIConnection generics",
        "DBIDriver generics",
        "DBIResult generics"
      ],
      "topics": [
        "dbGetInfo"
      ]
    },
    {
      "page": "dbGetQuery",
      "title": "Retrieve results from a query",
      "concept": [
        "DBIConnection generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbGetQuery"
      ]
    },
    {
      "page": "dbGetQueryArrow",
      "title": "Retrieve results from a query as an Arrow object",
      "concept": [
        "DBIConnection generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbGetQueryArrow"
      ]
    },
    {
      "page": "dbGetRowCount",
      "title": "The number of rows fetched so far",
      "concept": [
        "DBIResult generics"
      ],
      "topics": [
        "dbGetRowCount"
      ]
    },
    {
      "page": "dbGetRowsAffected",
      "title": "The number of rows affected",
      "concept": [
        "DBIResult generics",
        "command execution generics"
      ],
      "topics": [
        "dbGetRowsAffected"
      ]
    },
    {
      "page": "dbGetStatement",
      "title": "Get the statement associated with a result set",
      "concept": [
        "DBIResult generics"
      ],
      "topics": [
        "dbGetStatement"
      ]
    },
    {
      "page": "dbHasCompleted",
      "title": "Completion status",
      "concept": [
        "DBIResult generics",
        "DBIResultArrow generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbHasCompleted"
      ]
    },
    {
      "page": "DBIConnection-class",
      "title": "DBIConnection class",
      "concept": [
        "DBI classes",
        "DBIConnection generics"
      ],
      "topics": [
        "DBIConnection-class"
      ]
    },
    {
      "page": "DBIConnector-class",
      "title": "DBIConnector class",
      "concept": [
        "DBI classes",
        "DBIConnector generics"
      ],
      "topics": [
        "DBIConnector-class"
      ]
    },
    {
      "page": "DBIDriver-class",
      "title": "DBIDriver class",
      "concept": [
        "DBI classes",
        "DBIDriver generics"
      ],
      "topics": [
        "DBIDriver-class"
      ]
    },
    {
      "page": "DBIObject-class",
      "title": "DBIObject class",
      "concept": [
        "DBI classes"
      ],
      "topics": [
        "DBIObject-class"
      ]
    },
    {
      "page": "DBIResult-class",
      "title": "DBIResult class",
      "concept": [
        "DBI classes",
        "DBIResult generics"
      ],
      "topics": [
        "DBIResult-class"
      ]
    },
    {
      "page": "DBIResultArrow-class",
      "title": "DBIResultArrow class",
      "concept": [
        "DBI classes",
        "DBIResultArrow generics"
      ],
      "topics": [
        "DBIResultArrow-class",
        "DBIResultArrowDefault-class"
      ]
    },
    {
      "page": "dbIsReadOnly",
      "title": "Is this DBMS object read only?",
      "concept": [
        "DBIConnection generics",
        "DBIConnector generics",
        "DBIDriver generics",
        "DBIResult generics"
      ],
      "topics": [
        "dbIsReadOnly"
      ]
    },
    {
      "page": "dbIsValid",
      "title": "Is this DBMS object still valid?",
      "concept": [
        "DBIConnection generics",
        "DBIDriver generics",
        "DBIResult generics",
        "DBIResultArrow generics"
      ],
      "topics": [
        "dbIsValid"
      ]
    },
    {
      "page": "dbListFields",
      "title": "List field names of a remote table",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbListFields"
      ]
    },
    {
      "page": "dbListObjects",
      "title": "List remote objects",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbListObjects"
      ]
    },
    {
      "page": "dbListTables",
      "title": "List remote tables",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbListTables"
      ]
    },
    {
      "page": "dbQuoteIdentifier",
      "title": "Quote identifiers",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbQuoteIdentifier"
      ]
    },
    {
      "page": "dbQuoteLiteral",
      "title": "Quote literal values",
      "concept": [
        "DBIResult generics"
      ],
      "topics": [
        "dbQuoteLiteral"
      ]
    },
    {
      "page": "dbQuoteString",
      "title": "Quote literal strings",
      "concept": [
        "DBIResult generics"
      ],
      "topics": [
        "dbQuoteString"
      ]
    },
    {
      "page": "dbReadTable",
      "title": "Read database tables as data frames",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbReadTable"
      ]
    },
    {
      "page": "dbReadTableArrow",
      "title": "Read database tables as Arrow objects",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbReadTableArrow"
      ]
    },
    {
      "page": "dbRemoveTable",
      "title": "Remove a table from the database",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbRemoveTable"
      ]
    },
    {
      "page": "dbSendQuery",
      "title": "Execute a query on a given database connection",
      "concept": [
        "DBIConnection generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbSendQuery"
      ]
    },
    {
      "page": "dbSendQueryArrow",
      "title": "Execute a query on a given database connection for retrieval via Arrow",
      "concept": [
        "DBIConnection generics",
        "data retrieval generics"
      ],
      "topics": [
        "dbSendQueryArrow"
      ]
    },
    {
      "page": "dbSendStatement",
      "title": "Execute a data manipulation statement on a given database connection",
      "concept": [
        "DBIConnection generics",
        "command execution generics"
      ],
      "topics": [
        "dbSendStatement"
      ]
    },
    {
      "page": "dbUnquoteIdentifier",
      "title": "Unquote identifiers",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbUnquoteIdentifier"
      ]
    },
    {
      "page": "dbWithTransaction",
      "title": "Self-contained SQL transactions",
      "topics": [
        "dbBreak",
        "dbWithTransaction"
      ]
    },
    {
      "page": "dbWriteTable",
      "title": "Copy data frames to database tables",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbWriteTable"
      ]
    },
    {
      "page": "dbWriteTableArrow",
      "title": "Copy Arrow objects to database tables",
      "concept": [
        "DBIConnection generics"
      ],
      "topics": [
        "dbWriteTableArrow"
      ]
    },
    {
      "page": "Id",
      "title": "Refer to a table nested in a hierarchy (e.g. within a schema)",
      "topics": [
        "Id",
        "Id-class"
      ]
    },
    {
      "page": "rownames",
      "title": "Convert row names back and forth between columns",
      "topics": [
        "rownames",
        "sqlColumnToRownames",
        "sqlRownamesToColumn"
      ]
    },
    {
      "page": "SQL",
      "title": "SQL quoting",
      "topics": [
        "SQL",
        "SQL-class"
      ]
    },
    {
      "page": "sqlAppendTable",
      "title": "Compose query to insert rows into a table",
      "concept": [
        "SQL generation"
      ],
      "topics": [
        "sqlAppendTable",
        "sqlAppendTableTemplate"
      ]
    },
    {
      "page": "sqlCreateTable",
      "title": "Compose query to create a simple table",
      "topics": [
        "sqlCreateTable"
      ]
    },
    {
      "page": "sqlData",
      "title": "Convert a data frame into form suitable for upload to an SQL database",
      "topics": [
        "sqlData"
      ]
    },
    {
      "page": "sqlInterpolate",
      "title": "Safely interpolate values into an SQL string",
      "topics": [
        "sqlInterpolate"
      ]
    }
  ],
  "_readme": "https://github.com/r-dbi/DBI/raw/HEAD/README.md",
  "_rundeps": [],
  "_vignettes": [
    {
      "source": "DBI-1.Rmd",
      "filename": "DBI-1.html",
      "title": "A Common Database Interface (DBI)",
      "author": "R-Databases Special Interest Group",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Version",
        "Introduction",
        "DBI Classes and Methods",
        "Class DBIObject",
        "Class DBIDriver",
        "Class DBIConnection",
        "Class DBIResult",
        "Data Type Mappings",
        "Utilities",
        "Open Issues and Limitations",
        "Resources"
      ],
      "created": "2015-02-25 20:02:09",
      "modified": "2026-02-25 14:34:37",
      "commits": 8
    },
    {
      "source": "DBI-proposal.Rmd",
      "filename": "DBI-proposal.html",
      "title": "A Common Interface to Relational Databases from R and S -- A Proposal",
      "author": "David James",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Computing with Distributed Data",
        "A Common Interface",
        "Interface Classes",
        "Class dbManager",
        "Class dbConnection",
        "Class dbResult",
        "Class dbResultSet",
        "Data Type Mappings",
        "Open Issues",
        "Limitations",
        "Other Approaches",
        "Open Database Connectivity (ODBC)",
        "Java Database Connectivity (JDBC)",
        "CORBA and a 3-tier Architecture",
        "Resources",
        "Acknowledgements",
        "The S Version 4 Definitions"
      ],
      "created": "2015-02-25 19:55:44",
      "modified": "2026-02-25 14:34:37",
      "commits": 9
    },
    {
      "source": "DBI-advanced.Rmd",
      "filename": "DBI-advanced.html",
      "title": "Advanced DBI Usage",
      "author": "James Wondrasek, Kirill Müller",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Who this tutorial is for",
        "How to run more complex queries using DBI",
        "How to read part of a table from a database",
        "How to use parameters (safely) in SQL queries",
        "Quoting",
        "Parameterized queries",
        "SQL data manipulation - UPDATE, DELETE and friends",
        "SQL transactions with DBI",
        "Conclusion"
      ],
      "created": "2021-01-02 10:57:36",
      "modified": "2026-02-25 14:34:37",
      "commits": 12
    },
    {
      "source": "spec.Rmd",
      "filename": "spec.html",
      "title": "DBI specification",
      "author": "Kirill Müller",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2017-02-28 22:55:41",
      "modified": "2024-02-09 07:24:41",
      "commits": 16
    },
    {
      "source": "DBI-history.Rmd",
      "filename": "DBI-history.html",
      "title": "History of DBI",
      "author": "David James",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2019-11-22 22:01:50",
      "modified": "2023-11-08 08:52:17",
      "commits": 3
    },
    {
      "source": "backend.Rmd",
      "filename": "backend.html",
      "title": "Implementing a new backend",
      "author": "Hadley Wickham, Kirill Müller",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Getting started",
        "Testing",
        "Driver",
        "Connection",
        "Results",
        "SQL methods",
        "Metadata methods",
        "Full DBI compliance"
      ],
      "created": "2015-01-27 22:40:58",
      "modified": "2024-12-06 08:11:49",
      "commits": 7
    },
    {
      "source": "DBI.Rmd",
      "filename": "DBI.html",
      "title": "Introduction to DBI",
      "author": "James Wondrasek, Katharina Brunner, Kirill Müller",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Who this tutorial is for",
        "How to connect to a database using DBI",
        "Secure password storage",
        "How to retrieve column names for a table",
        "Read a table into a data frame",
        "Read only selected rows and columns into a data frame",
        "How to end a DBMS session",
        "Conclusion",
        "Further Reading"
      ],
      "created": "2019-11-22 22:05:18",
      "modified": "2025-05-03 05:31:42",
      "commits": 17
    },
    {
      "source": "DBI-arrow.Rmd",
      "filename": "DBI-arrow.html",
      "title": "Using DBI with Arrow",
      "author": "Kirill Müller",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Who this tutorial is for",
        "Rationale",
        "New classes and generics",
        "Prepare",
        "Read all rows from a table",
        "Run queries",
        "Prepared queries",
        "Manual flow",
        "Writing data",
        "Appending data",
        "Conclusion"
      ],
      "created": "2022-09-29 08:22:51",
      "modified": "2023-12-27 09:02:16",
      "commits": 11
    }
  ],
  "_score": 21.046515468618672,
  "_indexed": false,
  "_nocasepkg": "dbi",
  "_universes": [
    "cynkra"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/DBI",
  "_previous": "1.3.0.9009",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:39:19.000Z",
      "distro": "noble",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "f985bb62be6560cbb80eb103b17728f332430fb1254b0b174eac38e5671e9253",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:39:22.000Z",
      "distro": "noble",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "d98cfae7379cef87b271ce28bcfe64336a9024f905e3da8b8abb0db903850cb7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:41:37.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "9700b61143f2d98ea97e1599e20b629c1c5ae51756a7cebd0db559138d8914ff",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:41:29.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "adcdd5f8c6f72d9d20a2c02c9feb455d0a246772686855b1d4ac59fd2766bc43",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:39:23.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "c4c2bcfb7ecb1e8318ab8dfec73f54e8856c5850b28e34c679b85f2c0ff40709",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:38:32.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "81f27a9a7c5195a41645dfbb2676b4567cb717096770ed52aa2e808a4af923f2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:38:33.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "f6461b56a5e56d9e31f5d9032cf90594a10cccc95e7b82eb59fb173bd5239222",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.3.0.9010",
      "date": "2026-05-24T06:41:21.000Z",
      "commit": "52fab4d8a444cd1670e192f9082f0ce8b0b0d0f3",
      "fileid": "5e034e5cbc6ac26a6191c0a09cbda5a0395167c52f919f9a04b8ebea02dae5b5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354119088"
    }
  ]
}