{
  "_id": "6a32bbf43efcd9bda4392384",
  "Package": "RSQLite",
  "Title": "SQLite Interface for R",
  "Version": "3.53.2",
  "Date": "2026-06-12",
  "Authors@R": "c(\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(c(\"David\", \"A.\"), \"James\", role = \"aut\"),\nperson(\"Seth\", \"Falcon\", role = \"aut\"),\nperson(\"D. Richard\", \"Hipp\", role = \"ctb\",\ncomment = \"for the included SQLite sources\"),\nperson(\"Dan\", \"Kennedy\", role = \"ctb\",\ncomment = \"for the included SQLite sources\"),\nperson(\"Joe\", \"Mistachkin\", role = \"ctb\",\ncomment = \"for the included SQLite sources\"),\nperson(, \"SQLite Authors\", role = \"ctb\",\ncomment = \"for the included SQLite sources\"),\nperson(\"Liam\", \"Healy\", role = \"ctb\",\ncomment = \"for the included SQLite sources\"),\nperson(\"R Consortium\", role = \"fnd\"),\nperson(, \"RStudio\", role = \"cph\")\n)",
  "Description": "Embeds the SQLite database engine in R and provides an\ninterface compliant with the DBI package. The source for the\nSQLite engine and for various extensions is included. System\nlibraries will never be consulted because this package relies\non static linking for the plugins it includes; this also\nensures a consistent experience across all installations.\nOptionally, when libcurl is available at build time, an\nexperimental HTTP/HTTPS virtual file system (VFS) can be\nenabled to allow read-only access to remote immutable SQLite\ndatabase files via URIs.",
  "License": "LGPL (>= 2.1)",
  "URL": "https://rsqlite.r-dbi.org, https://github.com/r-dbi/RSQLite",
  "BugReports": "https://github.com/r-dbi/RSQLite/issues",
  "VignetteBuilder": "knitr",
  "Config/Needs/website": "r-dbi/dbitemplate",
  "Config/autostyle/scope": "line_breaks",
  "Config/autostyle/strict": "false",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Collate": "'SQLiteConnection.R' 'SQLKeywords_SQLiteConnection.R'\n'SQLiteDriver.R' 'SQLite.R' 'SQLiteResult.R' 'coerce.R'\n'compatRowNames.R' 'copy.R' 'cpp11.R' 'datasetsDb.R'\n'dbAppendTable_SQLiteConnection.R' 'dbBeginTransaction.R'\n'dbBegin_SQLiteConnection.R' 'dbBind_SQLiteResult.R'\n'dbClearResult_SQLiteResult.R' 'dbColumnInfo_SQLiteResult.R'\n'dbCommit_SQLiteConnection.R' 'dbConnect_SQLiteConnection.R'\n'dbConnect_SQLiteDriver.R' 'dbDataType_SQLiteConnection.R'\n'dbDataType_SQLiteDriver.R' 'dbDisconnect_SQLiteConnection.R'\n'dbExistsTable_SQLiteConnection_Id.R'\n'dbExistsTable_SQLiteConnection_character.R'\n'dbFetch_SQLiteResult.R' 'dbGetException_SQLiteConnection.R'\n'dbGetInfo_SQLiteConnection.R' 'dbGetInfo_SQLiteDriver.R'\n'dbGetPreparedQuery.R'\n'dbGetPreparedQuery_SQLiteConnection_character_data.frame.R'\n'dbGetRowCount_SQLiteResult.R'\n'dbGetRowsAffected_SQLiteResult.R'\n'dbGetStatement_SQLiteResult.R' 'dbHasCompleted_SQLiteResult.R'\n'dbIsValid_SQLiteConnection.R' 'dbIsValid_SQLiteDriver.R'\n'dbIsValid_SQLiteResult.R' 'dbListObjects_SQLiteConnection.R'\n'dbListResults_SQLiteConnection.R'\n'dbListTables_SQLiteConnection.R'\n'dbQuoteIdentifier_SQLiteConnection_SQL.R'\n'dbQuoteIdentifier_SQLiteConnection_character.R'\n'dbReadTable_SQLiteConnection_character.R'\n'dbRemoveTable_SQLiteConnection_character.R'\n'dbRollback_SQLiteConnection.R' 'dbSendPreparedQuery.R'\n'dbSendPreparedQuery_SQLiteConnection_character_data.frame.R'\n'dbSendQuery_SQLiteConnection_character.R'\n'dbUnloadDriver_SQLiteDriver.R'\n'dbUnquoteIdentifier_SQLiteConnection_SQL.R'\n'dbWriteTable_SQLiteConnection_character_character.R'\n'dbWriteTable_SQLiteConnection_character_data.frame.R'\n'db_bind.R' 'deprecated.R' 'export.R' 'fetch_SQLiteResult.R'\n'httpvfs.R' 'httpvfs_config.R'\n'import-standalone-check_suggested.R'\n'import-standalone-purrr.R' 'initExtension.R' 'initRegExp.R'\n'isSQLKeyword_SQLiteConnection_character.R'\n'make.db.names_SQLiteConnection_character.R' 'pkgconfig.R'\n'show_SQLiteConnection.R' 'sqlData_SQLiteConnection.R'\n'table.R' 'transactions.R' 'utils.R' 'version.R' 'zzz.R'",
  "Config/roxygen2/version": "8.0.0.9000",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-17 15:17:56 UTC",
    "User": "root"
  },
  "Author": "Kirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>), Hadley Wickham [aut],\nDavid A. James [aut], Seth Falcon [aut], D. Richard Hipp [ctb]\n(for the included SQLite sources), Dan Kennedy [ctb] (for the\nincluded SQLite sources), Joe Mistachkin [ctb] (for the\nincluded SQLite sources), SQLite Authors [ctb] (for the\nincluded SQLite sources), Liam Healy [ctb] (for the included\nSQLite sources), R Consortium [fnd], RStudio [cph]",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-06-17 12:00:19 UTC",
  "RemoteUrl": "https://github.com/cran/RSQLite",
  "RemoteRef": "HEAD",
  "RemoteSha": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
  "MD5sum": "1534ee936a2ec50908b5e9beb5966356",
  "_user": "cran",
  "_type": "src",
  "_file": "RSQLite_3.53.2.tar.gz",
  "_fileid": "0b21a72b640b9dd18c1be2313e7b2b838914872ecbfa8a64e32cd3c9823b937d",
  "_filesize": 4534650,
  "_sha256": "0b21a72b640b9dd18c1be2313e7b2b838914872ecbfa8a64e32cd3c9823b937d",
  "_created": "2026-06-17T15:17:56.000Z",
  "_published": "2026-06-17T15:23:32.346Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 81932638335,
      "time": 195,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7699886711"
    },
    {
      "job": 81932638276,
      "time": 227,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7699900723"
    },
    {
      "job": 81932638281,
      "time": 210,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7699894442"
    },
    {
      "job": 81932638423,
      "time": 211,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7699893799"
    },
    {
      "job": 81931331771,
      "time": 340,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7699798560"
    },
    {
      "job": 81932638428,
      "time": 177,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7699878554"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/RSQLite",
  "_commit": {
    "id": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
    "author": "Kirill Müller <kirill@cynkra.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 3.53.2\n",
    "time": 1781697619
  },
  "_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": "R",
      "version": ">= 3.1.0",
      "role": "Depends"
    },
    {
      "package": "cpp11",
      "version": ">= 0.4.0",
      "role": "LinkingTo"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "blob",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "memoise",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "pkgconfig",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "cli",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "version": ">= 1.8.0",
      "role": "Suggests"
    },
    {
      "package": "decor",
      "role": "Suggests"
    },
    {
      "package": "gert",
      "role": "Suggests"
    },
    {
      "package": "gh",
      "role": "Suggests"
    },
    {
      "package": "hms",
      "role": "Suggests"
    },
    {
      "package": "httpuv",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "magrittr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rvest",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 1168,
  "_updates": [
    {
      "week": "2025-29",
      "n": 1
    },
    {
      "week": "2025-34",
      "n": 1
    },
    {
      "week": "2025-46",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2026-06",
      "n": 1
    },
    {
      "week": "2026-19",
      "n": 1
    },
    {
      "week": "2026-21",
      "n": 1
    },
    {
      "week": "2026-25",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "2.4.2",
      "date": "2025-07-18"
    },
    {
      "name": "2.4.3",
      "date": "2025-08-20"
    },
    {
      "name": "2.4.4",
      "date": "2025-11-10"
    },
    {
      "name": "2.4.5",
      "date": "2025-11-30"
    },
    {
      "name": "2.4.6",
      "date": "2026-02-06"
    },
    {
      "name": "3.52.0",
      "date": "2026-05-10"
    },
    {
      "name": "3.53.1",
      "date": "2026-05-23"
    },
    {
      "name": "3.53.2",
      "date": "2026-06-17"
    }
  ],
  "_stars": 3,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 53,
      "uuid": 1741643
    },
    {
      "user": "seth",
      "count": 24,
      "uuid": 1619
    },
    {
      "user": "daj025",
      "count": 4,
      "uuid": 13022669
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 609,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 249787,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSQLite"
  },
  "_mentions": 27,
  "_devurl": "https://github.com/r-dbi/rsqlite",
  "_pkgdown": "https://rsqlite.r-dbi.org",
  "_searchresults": 14944,
  "_topics": [
    "curl",
    "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/readme.html",
    "extra/readme.md",
    "extra/RSQLite.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/r-dbi/rsqlite",
  "_realowner": "r-dbi",
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.2-1",
      "date": "2001-11-03"
    },
    {
      "version": "0.3-0",
      "date": "2002-10-01"
    },
    {
      "version": "0.3-1",
      "date": "2003-04-07"
    },
    {
      "version": "0.3-2",
      "date": "2003-06-18"
    },
    {
      "version": "0.3-3",
      "date": "2003-11-12"
    },
    {
      "version": "0.3-4",
      "date": "2004-06-22"
    },
    {
      "version": "0.3-5",
      "date": "2005-01-31"
    },
    {
      "version": "0.4-0",
      "date": "2005-04-07"
    },
    {
      "version": "0.4-1",
      "date": "2006-01-19"
    },
    {
      "version": "0.4-4",
      "date": "2006-10-07"
    },
    {
      "version": "0.4-9",
      "date": "2006-10-27"
    },
    {
      "version": "0.4-13",
      "date": "2006-11-09"
    },
    {
      "version": "0.4-15",
      "date": "2006-12-04"
    },
    {
      "version": "0.4-18",
      "date": "2007-01-05"
    },
    {
      "version": "0.4-19",
      "date": "2007-01-18"
    },
    {
      "version": "0.4-20",
      "date": "2007-02-28"
    },
    {
      "version": "0.5-1",
      "date": "2007-03-21"
    },
    {
      "version": "0.5-2",
      "date": "2007-03-28"
    },
    {
      "version": "0.5-3",
      "date": "2007-03-29"
    },
    {
      "version": "0.5-4",
      "date": "2007-05-01"
    },
    {
      "version": "0.6-0",
      "date": "2007-06-10"
    },
    {
      "version": "0.6-2",
      "date": "2007-07-18"
    },
    {
      "version": "0.5-6",
      "date": "2007-07-18"
    },
    {
      "version": "0.6-3",
      "date": "2007-10-03"
    },
    {
      "version": "0.6-4",
      "date": "2007-10-30"
    },
    {
      "version": "0.6-7",
      "date": "2008-01-27"
    },
    {
      "version": "0.6-8",
      "date": "2008-02-27"
    },
    {
      "version": "0.6-9",
      "date": "2008-06-11"
    },
    {
      "version": "0.7-0",
      "date": "2008-08-24"
    },
    {
      "version": "0.7-1",
      "date": "2008-10-26"
    },
    {
      "version": "0.7-2",
      "date": "2009-08-14"
    },
    {
      "version": "0.7-3",
      "date": "2009-10-04"
    },
    {
      "version": "0.8-0",
      "date": "2009-12-22"
    },
    {
      "version": "0.8-1",
      "date": "2010-01-07"
    },
    {
      "version": "0.8-2",
      "date": "2010-01-22"
    },
    {
      "version": "0.8-3",
      "date": "2010-02-11"
    },
    {
      "version": "0.8-4",
      "date": "2010-03-10"
    },
    {
      "version": "0.9-0",
      "date": "2010-05-07"
    },
    {
      "version": "0.9-1",
      "date": "2010-05-29"
    },
    {
      "version": "0.9-2",
      "date": "2010-07-24"
    },
    {
      "version": "0.9-3",
      "date": "2010-11-07"
    },
    {
      "version": "0.9-4",
      "date": "2010-11-24"
    },
    {
      "version": "0.10.0",
      "date": "2011-10-02"
    },
    {
      "version": "0.11.0",
      "date": "2011-12-01"
    },
    {
      "version": "0.11.1",
      "date": "2011-12-07"
    },
    {
      "version": "0.11.2",
      "date": "2012-09-16"
    },
    {
      "version": "0.11.3",
      "date": "2013-04-16"
    },
    {
      "version": "0.11.4",
      "date": "2013-05-26"
    },
    {
      "version": "1.0.0",
      "date": "2014-10-24"
    },
    {
      "version": "1.1",
      "date": "2016-11-27"
    },
    {
      "version": "1.1-1",
      "date": "2016-12-10"
    },
    {
      "version": "1.1-2",
      "date": "2017-01-08"
    },
    {
      "version": "2.0",
      "date": "2017-06-19"
    },
    {
      "version": "2.1.0",
      "date": "2018-03-29"
    },
    {
      "version": "2.1.1",
      "date": "2018-05-06"
    },
    {
      "version": "2.1.2",
      "date": "2019-07-24"
    },
    {
      "version": "2.1.3",
      "date": "2019-12-03"
    },
    {
      "version": "2.1.4",
      "date": "2019-12-05"
    },
    {
      "version": "2.1.5",
      "date": "2019-12-18"
    },
    {
      "version": "2.2.0",
      "date": "2020-01-07"
    },
    {
      "version": "2.2.1",
      "date": "2020-09-30"
    },
    {
      "version": "2.2.2",
      "date": "2021-01-08"
    },
    {
      "version": "2.2.3",
      "date": "2021-01-24"
    },
    {
      "version": "2.2.4",
      "date": "2021-03-12"
    },
    {
      "version": "2.2.5",
      "date": "2021-03-27"
    },
    {
      "version": "2.2.6",
      "date": "2021-04-11"
    },
    {
      "version": "2.2.7",
      "date": "2021-04-22"
    },
    {
      "version": "2.2.8",
      "date": "2021-08-21"
    },
    {
      "version": "2.2.9",
      "date": "2021-12-06"
    },
    {
      "version": "2.2.10",
      "date": "2022-02-17"
    },
    {
      "version": "2.2.11",
      "date": "2022-03-23"
    },
    {
      "version": "2.2.12",
      "date": "2022-04-02"
    },
    {
      "version": "2.2.13",
      "date": "2022-04-29"
    },
    {
      "version": "2.2.14",
      "date": "2022-05-07"
    },
    {
      "version": "2.2.15",
      "date": "2022-07-17"
    },
    {
      "version": "2.2.16",
      "date": "2022-08-17"
    },
    {
      "version": "2.2.17",
      "date": "2022-09-10"
    },
    {
      "version": "2.2.18",
      "date": "2022-10-04"
    },
    {
      "version": "2.2.19",
      "date": "2022-11-24"
    },
    {
      "version": "2.2.20",
      "date": "2022-12-22"
    },
    {
      "version": "2.3.0",
      "date": "2023-02-17"
    },
    {
      "version": "2.3.1",
      "date": "2023-04-03"
    },
    {
      "version": "2.3.2",
      "date": "2023-10-29"
    },
    {
      "version": "2.3.3",
      "date": "2023-11-04"
    },
    {
      "version": "2.3.4",
      "date": "2023-12-08"
    },
    {
      "version": "2.3.5",
      "date": "2024-01-21"
    },
    {
      "version": "2.3.6",
      "date": "2024-03-31"
    },
    {
      "version": "2.3.7",
      "date": "2024-05-27"
    },
    {
      "version": "2.3.8",
      "date": "2024-11-17"
    },
    {
      "version": "2.3.9",
      "date": "2024-12-03"
    },
    {
      "version": "2.3.10",
      "date": "2025-05-02"
    },
    {
      "version": "2.3.11",
      "date": "2025-05-04"
    },
    {
      "version": "2.4.0",
      "date": "2025-05-31"
    },
    {
      "version": "2.4.1",
      "date": "2025-06-08"
    },
    {
      "version": "2.4.2",
      "date": "2025-07-18"
    },
    {
      "version": "2.4.3",
      "date": "2025-08-20"
    },
    {
      "version": "2.4.4",
      "date": "2025-11-10"
    },
    {
      "version": "2.4.5",
      "date": "2025-11-30"
    },
    {
      "version": "2.4.6",
      "date": "2026-02-06"
    },
    {
      "version": "3.52.0",
      "date": "2026-05-10"
    },
    {
      "version": "3.53.1",
      "date": "2026-05-23"
    },
    {
      "version": "3.53.2",
      "date": "2026-06-17"
    }
  ],
  "_exports": [
    "datasetsDb",
    "dbAppendTable",
    "dbAppendTableArrow",
    "dbBegin",
    "dbBeginTransaction",
    "dbBind",
    "dbBindArrow",
    "dbBuildTableDefinition",
    "dbCanConnect",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbCreateTable",
    "dbCreateTableArrow",
    "dbDataType",
    "dbDisconnect",
    "dbDriver",
    "dbExecute",
    "dbExistsTable",
    "dbFetch",
    "dbFetchArrow",
    "dbFetchArrowChunk",
    "dbGetConnectArgs",
    "dbGetException",
    "dbGetInfo",
    "dbGetPreparedQuery",
    "dbGetQuery",
    "dbGetQueryArrow",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListFields",
    "dbListObjects",
    "dbListResults",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbReadTable",
    "dbReadTableArrow",
    "dbRemoveTable",
    "dbRollback",
    "dbSendPreparedQuery",
    "dbSendQuery",
    "dbSendQueryArrow",
    "dbSendStatement",
    "dbUnloadDriver",
    "dbUnquoteIdentifier",
    "dbWithTransaction",
    "dbWriteTable",
    "dbWriteTableArrow",
    "fetch",
    "Id",
    "initExtension",
    "initRegExp",
    "isIdCurrent",
    "isSQLKeyword",
    "make.db.names",
    "rsqliteVersion",
    "show",
    "sqlData",
    "SQLite",
    "SQLITE_RO",
    "SQLITE_RW",
    "SQLITE_RWC",
    "sqliteBuildTableDefinition",
    "sqliteCopyDatabase",
    "sqliteHasHttpVFS",
    "sqliteHttpConfig",
    "sqliteHttpStats",
    "sqliteHttpVfsCompiled",
    "sqliteIsTransacting",
    "sqliteQuickColumn",
    "sqliteRemote",
    "sqliteSetBusyHandler",
    "SQLKeywords"
  ],
  "_help": [
    {
      "page": "datasetsDb",
      "title": "A sample sqlite database",
      "topics": [
        "datasetsDb"
      ]
    },
    {
      "page": "sqlite-transaction",
      "title": "SQLite transaction management",
      "topics": [
        "dbBegin,SQLiteConnection-method",
        "dbBegin_SQLiteConnection",
        "dbCommit,SQLiteConnection-method",
        "dbCommit_SQLiteConnection",
        "dbRollback,SQLiteConnection-method",
        "dbRollback_SQLiteConnection",
        "sqlite-transaction",
        "sqliteIsTransacting"
      ]
    },
    {
      "page": "dbReadTable",
      "title": "Read a database table",
      "topics": [
        "dbReadTable,SQLiteConnection,character-method",
        "dbReadTable_SQLiteConnection_character"
      ]
    },
    {
      "page": "dbWriteTable",
      "title": "Write a local data frame or file to the database",
      "topics": [
        "dbWriteTable,SQLiteConnection,character,character-method",
        "dbWriteTable,SQLiteConnection,character,data.frame-method",
        "dbWriteTable_SQLiteConnection_character_character",
        "dbWriteTable_SQLiteConnection_character_data.frame"
      ]
    },
    {
      "page": "initExtension",
      "title": "Add useful extension functions",
      "topics": [
        "initExtension"
      ]
    },
    {
      "page": "rsqliteVersion",
      "title": "RSQLite version",
      "topics": [
        "rsqliteVersion"
      ]
    },
    {
      "page": "SQLite",
      "title": "Connect to an SQLite database",
      "topics": [
        "RSQLite-package",
        "dbConnect,SQLiteConnection-method",
        "dbConnect,SQLiteDriver-method",
        "dbConnect_SQLiteConnection",
        "dbConnect_SQLiteDriver",
        "dbDisconnect,SQLiteConnection-method",
        "dbDisconnect_SQLiteConnection",
        "RSQLite",
        "SQLite",
        "SQLITE_RO",
        "SQLITE_RW",
        "SQLITE_RWC"
      ]
    },
    {
      "page": "sqliteCopyDatabase",
      "title": "Copy a SQLite database",
      "topics": [
        "sqliteCopyDatabase"
      ]
    },
    {
      "page": "sqliteHasHttpVFS",
      "title": "Check for HTTP VFS support",
      "topics": [
        "sqliteHasHttpVFS"
      ]
    },
    {
      "page": "sqliteHttpConfig",
      "title": "Configure experimental HTTP VFS behavior (optional)",
      "topics": [
        "sqliteHttpConfig"
      ]
    },
    {
      "page": "sqliteHttpStats",
      "title": "Experimental HTTP VFS statistics",
      "topics": [
        "sqliteHttpStats"
      ]
    },
    {
      "page": "sqliteHttpVfsCompiled",
      "title": "Was HTTP VFS compiled into this build?",
      "topics": [
        "sqliteHttpVfsCompiled"
      ]
    },
    {
      "page": "sqliteRemote",
      "title": "Convenience helper for opening remote SQLite databases over HTTP/HTTPS",
      "topics": [
        "sqliteRemote"
      ]
    },
    {
      "page": "sqliteSetBusyHandler",
      "title": "Configure what SQLite should do when the database is locked",
      "topics": [
        "sqliteSetBusyHandler"
      ]
    }
  ],
  "_readme": "https://github.com/cran/RSQLite/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "lifecycle",
    "memoise",
    "pkgconfig",
    "rlang",
    "vctrs"
  ],
  "_sysdeps": [
    {
      "shlib": "libcurl",
      "package": "libcurl4t64",
      "headers": "libcurl4-openssl-dev",
      "source": "curl",
      "version": "8.5.0-2ubuntu10.9",
      "name": "curl",
      "homepage": "https://curl.se/",
      "description": "easy-to-use client-side URL transfer library (OpenSSL flavour)"
    },
    {
      "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": "RSQLite.Rmd",
      "filename": "RSQLite.html",
      "title": "RSQLite",
      "author": "Hadley Wickham",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Creating a new database",
        "Loading data",
        "Queries",
        "Batched queries",
        "Multiple parameterised queries",
        "Statements"
      ],
      "created": "2016-11-27 15:31:52",
      "modified": "2022-08-17 06:00:14",
      "commits": 6
    }
  ],
  "_score": 14.672903289205163,
  "_indexed": false,
  "_nocasepkg": "rsqlite",
  "_universes": [
    "cran"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RSQLite",
  "_previous": "3.53.1",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "3.53.2",
      "date": "2026-06-17T15:21:18.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
      "fileid": "9d552c25d18bbc6d9516e3c7d378fd4e6c559640bfe348c19ccf69ddae7a03ed",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "3.53.2",
      "date": "2026-06-17T15:21:37.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
      "fileid": "89232cc41a2a10400b2b3db880380282b1ca09ccf4e10cdecf3eae99036123e4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "3.53.2",
      "date": "2026-06-17T15:21:34.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
      "fileid": "398ed84bac789d5efa1577d1ac67563101ca487d81821f282ff3923d97568579",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "3.53.2",
      "date": "2026-06-17T15:21:28.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
      "fileid": "a0f49a2dcb56de5253eba64a2d575576862ca5bc8d0e0bf2757862d54a577591",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "3.53.2",
      "date": "2026-06-17T15:21:31.000Z",
      "arch": "emscripten",
      "commit": "d89d10f088fab87d43f73fd0bb04f4ffa2921850",
      "fileid": "bb45b4c22d119bcdfb09e1314e908b0c9df6ad2d4f2d4d4800a69e97fe705051",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27699343271"
    }
  ]
}