{
  "_id": "6a13e8f6acfb0bcc41d2dbc0",
  "Package": "RSQLite",
  "Title": "SQLite Interface for R",
  "Version": "3.53.0.9001",
  "Date": "2026-05-24",
  "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.",
  "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",
  "Roxygen": "list(markdown = TRUE)",
  "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'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",
  "Repository": "https://cynkra.r-universe.dev",
  "Date/Publication": "2026-05-24 04:55:33 UTC",
  "RemoteUrl": "https://github.com/r-dbi/RSQLite",
  "RemoteRef": "HEAD",
  "RemoteSha": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-05-25 06:05:26 UTC",
    "User": "root"
  },
  "Author": "Kirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>),\nHadley Wickham [aut],\nDavid A. James [aut],\nSeth Falcon [aut],\nD. Richard Hipp [ctb] (for the included SQLite sources),\nDan Kennedy [ctb] (for the included SQLite sources),\nJoe Mistachkin [ctb] (for the included SQLite sources),\nSQLite Authors [ctb] (for the included SQLite sources),\nLiam Healy [ctb] (for the included SQLite sources),\nR Consortium [fnd],\nRStudio [cph]",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "MD5sum": "5121f5cf5d929ede96fe958428600637",
  "_user": "cynkra",
  "_type": "src",
  "_file": "RSQLite_3.53.0.9001.tar.gz",
  "_fileid": "89cdc8571db8580afbe604c45f323dd9fb2dc5f3210a1d097240882594b64ae7",
  "_filesize": 4491499,
  "_sha256": "89cdc8571db8580afbe604c45f323dd9fb2dc5f3210a1d097240882594b64ae7",
  "_created": "2026-05-25T06:05:26.000Z",
  "_published": "2026-05-25T06:15:18.724Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77664782858,
      "time": 198,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7192636615"
    },
    {
      "job": 77664782897,
      "time": 207,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7192638652"
    },
    {
      "job": 77664782941,
      "time": 216,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192639678"
    },
    {
      "job": 77664782854,
      "time": 204,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192637801"
    },
    {
      "job": 77664782868,
      "time": 125,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7192623009"
    },
    {
      "job": 77664782825,
      "time": 318,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7192658457"
    },
    {
      "job": 77664782857,
      "time": 123,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192622815"
    },
    {
      "job": 77664782827,
      "time": 490,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192691028"
    },
    {
      "job": 77664276546,
      "time": 323,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192599771"
    },
    {
      "job": 77664782824,
      "time": 183,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192633929"
    },
    {
      "job": 77664782845,
      "time": 299,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7192654966"
    },
    {
      "job": 77664782814,
      "time": 298,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7192654750"
    },
    {
      "job": 77664782817,
      "time": 270,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7192649548"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/r-dbi/RSQLite",
  "_commit": {
    "id": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
    "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "fledge: Bump version to 3.53.0.9001 (#726)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1779598533
  },
  "_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": "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": "r-dbi",
  "_selfowned": false,
  "_usedby": 1153,
  "_updates": [
    {
      "week": "2025-22",
      "n": 4
    },
    {
      "week": "2025-23",
      "n": 3
    },
    {
      "week": "2025-24",
      "n": 1
    },
    {
      "week": "2025-26",
      "n": 1
    },
    {
      "week": "2025-27",
      "n": 1
    },
    {
      "week": "2025-29",
      "n": 7
    },
    {
      "week": "2025-31",
      "n": 6
    },
    {
      "week": "2025-32",
      "n": 2
    },
    {
      "week": "2025-36",
      "n": 4
    },
    {
      "week": "2025-37",
      "n": 2
    },
    {
      "week": "2025-39",
      "n": 5
    },
    {
      "week": "2025-40",
      "n": 6
    },
    {
      "week": "2025-41",
      "n": 3
    },
    {
      "week": "2025-42",
      "n": 1
    },
    {
      "week": "2025-44",
      "n": 3
    },
    {
      "week": "2025-45",
      "n": 10
    },
    {
      "week": "2025-46",
      "n": 4
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 3
    },
    {
      "week": "2025-49",
      "n": 1
    },
    {
      "week": "2025-50",
      "n": 2
    },
    {
      "week": "2025-51",
      "n": 2
    },
    {
      "week": "2026-01",
      "n": 2
    },
    {
      "week": "2026-02",
      "n": 4
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-05",
      "n": 4
    },
    {
      "week": "2026-06",
      "n": 9
    },
    {
      "week": "2026-08",
      "n": 3
    },
    {
      "week": "2026-09",
      "n": 4
    },
    {
      "week": "2026-10",
      "n": 2
    },
    {
      "week": "2026-11",
      "n": 5
    },
    {
      "week": "2026-12",
      "n": 2
    },
    {
      "week": "2026-18",
      "n": 1
    },
    {
      "week": "2026-19",
      "n": 17
    },
    {
      "week": "2026-20",
      "n": 8
    },
    {
      "week": "2026-21",
      "n": 5
    }
  ],
  "_tags": [
    {
      "name": "v2.3.11.9002",
      "date": "2025-05-31"
    },
    {
      "name": "v2.4.0",
      "date": "2025-05-31"
    },
    {
      "name": "v2.4.0.9000",
      "date": "2025-06-01"
    },
    {
      "name": "v2.4.0.9001",
      "date": "2025-06-08"
    },
    {
      "name": "v2.4.1",
      "date": "2025-06-08"
    },
    {
      "name": "v2.4.1.9000",
      "date": "2025-06-09"
    },
    {
      "name": "v2.4.1.9001",
      "date": "2025-06-30"
    },
    {
      "name": "v2.4.1.9002",
      "date": "2025-07-17"
    },
    {
      "name": "v2.4.1.9003",
      "date": "2025-07-18"
    },
    {
      "name": "v2.4.2",
      "date": "2025-07-18"
    },
    {
      "name": "v2.4.2.9000",
      "date": "2025-07-19"
    },
    {
      "name": "v2.4.2.9001",
      "date": "2025-08-01"
    },
    {
      "name": "v2.4.3",
      "date": "2025-08-01"
    },
    {
      "name": "v2.4.3.9000",
      "date": "2025-08-02"
    },
    {
      "name": "v2.4.3.9001",
      "date": "2025-08-05"
    },
    {
      "name": "v2.4.3.9002",
      "date": "2025-09-05"
    },
    {
      "name": "v2.4.3.9003",
      "date": "2025-09-06"
    },
    {
      "name": "v2.4.3.9004",
      "date": "2025-09-14"
    },
    {
      "name": "v2.4.3.9005",
      "date": "2025-09-26"
    },
    {
      "name": "v2.4.3.9006",
      "date": "2025-09-28"
    },
    {
      "name": "v2.4.3.9007",
      "date": "2025-09-29"
    },
    {
      "name": "v2.4.3.9008",
      "date": "2025-09-30"
    },
    {
      "name": "v2.4.3.9009",
      "date": "2025-10-02"
    },
    {
      "name": "v2.4.3.9010",
      "date": "2025-10-12"
    },
    {
      "name": "v2.4.3.9011",
      "date": "2025-10-13"
    },
    {
      "name": "v2.4.3.9012",
      "date": "2025-10-29"
    },
    {
      "name": "v2.4.3.9013",
      "date": "2025-11-03"
    },
    {
      "name": "v2.4.3.9014",
      "date": "2025-11-05"
    },
    {
      "name": "v2.4.4",
      "date": "2025-11-05"
    },
    {
      "name": "v2.4.4.9000",
      "date": "2025-11-06"
    },
    {
      "name": "v2.4.4.9001",
      "date": "2025-11-07"
    },
    {
      "name": "v2.4.4.9002",
      "date": "2025-11-08"
    },
    {
      "name": "v2.4.4.9003",
      "date": "2025-11-10"
    },
    {
      "name": "v2.4.4.9004",
      "date": "2025-11-12"
    },
    {
      "name": "v2.4.4.9005",
      "date": "2025-11-17"
    },
    {
      "name": "v2.4.4.9006",
      "date": "2025-11-30"
    },
    {
      "name": "v2.4.5",
      "date": "2025-11-30"
    },
    {
      "name": "v2.4.5.9000",
      "date": "2025-12-01"
    },
    {
      "name": "v2.4.5.9001",
      "date": "2025-12-10"
    },
    {
      "name": "v2.4.5.9002",
      "date": "2025-12-18"
    },
    {
      "name": "v2.4.5.9003",
      "date": "2026-01-02"
    },
    {
      "name": "v2.4.5.9004",
      "date": "2026-01-07"
    },
    {
      "name": "v2.4.5.9005",
      "date": "2026-01-11"
    },
    {
      "name": "v2.4.5.9006",
      "date": "2026-01-14"
    },
    {
      "name": "v2.4.5.9007",
      "date": "2026-02-02"
    },
    {
      "name": "v2.4.5.9008",
      "date": "2026-02-05"
    },
    {
      "name": "v2.4.6",
      "date": "2026-02-05"
    },
    {
      "name": "v2.4.6.9000",
      "date": "2026-02-06"
    },
    {
      "name": "v2.4.6.9001",
      "date": "2026-02-22"
    },
    {
      "name": "v2.4.6.9002",
      "date": "2026-02-26"
    },
    {
      "name": "v2.4.7",
      "date": "2026-02-26"
    },
    {
      "name": "v2.4.7.9000",
      "date": "2026-02-27"
    },
    {
      "name": "v2.4.7.9001",
      "date": "2026-03-08"
    },
    {
      "name": "v2.4.7.9002",
      "date": "2026-03-13"
    },
    {
      "name": "v2.4.7.9003",
      "date": "2026-03-14"
    },
    {
      "name": "v2.4.7.9004",
      "date": "2026-03-22"
    },
    {
      "name": "v2.4.7.9005",
      "date": "2026-05-04"
    },
    {
      "name": "v2.4.7.9006",
      "date": "2026-05-09"
    },
    {
      "name": "v2.4.8",
      "date": "2026-05-09"
    },
    {
      "name": "v3.51.99.9001",
      "date": "2026-05-09"
    },
    {
      "name": "v3.52.0",
      "date": "2026-05-09"
    },
    {
      "name": "v3.52.0.9000",
      "date": "2026-05-13"
    },
    {
      "name": "v3.52.0.9001",
      "date": "2026-05-16"
    },
    {
      "name": "v3.53.0.9000",
      "date": "2026-05-22"
    },
    {
      "name": "v3.53.1",
      "date": "2026-05-22"
    },
    {
      "name": "v3.53.0.9001",
      "date": "2026-05-24"
    }
  ],
  "_topics": [
    "database",
    "sqlite3",
    "cpp"
  ],
  "_stars": 336,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 2258,
      "uuid": 1741643
    },
    {
      "user": "hadley",
      "count": 382,
      "uuid": 4196
    },
    {
      "user": "bpvgoncalves",
      "count": 20,
      "uuid": 7214777
    },
    {
      "user": "wibeasley",
      "count": 18,
      "uuid": 1372890
    },
    {
      "user": "anderic1",
      "count": 16,
      "uuid": 33925151
    },
    {
      "user": "antonov548",
      "count": 15,
      "uuid": 22891541
    },
    {
      "user": "gaborcsardi",
      "count": 13,
      "uuid": 660288
    },
    {
      "user": "tschiefer",
      "count": 12,
      "uuid": 11596155
    },
    {
      "user": "wush978",
      "count": 10,
      "uuid": 1252618
    },
    {
      "user": "indrajeetpatil",
      "count": 8,
      "uuid": 11330453
    },
    {
      "user": "jeanetteclark",
      "count": 8,
      "uuid": 24237074
    },
    {
      "user": "rfhb",
      "count": 7,
      "uuid": 626690
    },
    {
      "user": "mkuhn",
      "count": 5,
      "uuid": 7827
    },
    {
      "user": "jjallaire",
      "count": 5,
      "uuid": 104391
    },
    {
      "user": "jeroen",
      "count": 3,
      "uuid": 216319
    },
    {
      "user": "maelle",
      "count": 3,
      "uuid": 8360597
    },
    {
      "user": "michaelchirico",
      "count": 3,
      "uuid": 7606389
    },
    {
      "user": "seth",
      "count": 3,
      "uuid": 1619
    },
    {
      "user": "shrektan",
      "count": 2,
      "uuid": 8368933
    },
    {
      "user": "shutinet",
      "count": 1,
      "uuid": 18209786
    },
    {
      "user": "psychobas",
      "count": 1,
      "uuid": 44177662
    },
    {
      "user": "troels",
      "count": 1,
      "uuid": 3203
    },
    {
      "user": "tschoonj",
      "count": 1,
      "uuid": 65736
    },
    {
      "user": "stewid",
      "count": 1,
      "uuid": 1815965
    },
    {
      "user": "rkingdc",
      "count": 1,
      "uuid": 6014582
    },
    {
      "user": "nunotexbsd",
      "count": 1,
      "uuid": 43720668
    },
    {
      "user": "mikmart",
      "count": 1,
      "uuid": 13412395
    },
    {
      "user": "lolow",
      "count": 1,
      "uuid": 28093
    },
    {
      "user": "kjellpk",
      "count": 1,
      "uuid": 13562939
    },
    {
      "user": "kevinushey",
      "count": 1,
      "uuid": 1976582
    },
    {
      "user": "jimhester",
      "count": 1,
      "uuid": 205275
    },
    {
      "user": "hannes",
      "count": 1,
      "uuid": 227792
    },
    {
      "user": "edwindj",
      "count": 1,
      "uuid": 542492
    },
    {
      "user": "copilot",
      "count": 1,
      "uuid": 198982749
    },
    {
      "user": "ankane",
      "count": 1,
      "uuid": 220358
    }
  ],
  "_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": 234750,
    "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": 11072,
  "_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/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": true,
  "_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"
    }
  ],
  "_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",
    "sqliteIsTransacting",
    "sqliteQuickColumn",
    "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": "sqliteSetBusyHandler",
      "title": "Configure what SQLite should do when the database is locked",
      "topics": [
        "sqliteSetBusyHandler"
      ]
    }
  ],
  "_readme": "https://github.com/r-dbi/RSQLite/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "lifecycle",
    "memoise",
    "pkgconfig",
    "rlang",
    "vctrs"
  ],
  "_sysdeps": [
    {
      "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": "2015-02-04 21:45:08",
      "modified": "2022-08-16 02:39:01",
      "commits": 10
    }
  ],
  "_score": 19.266872939600596,
  "_indexed": false,
  "_nocasepkg": "rsqlite",
  "_universes": [
    "cynkra"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RSQLite",
  "_previous": "3.53.0.9000",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:40.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "84f9d5fb7e945694e374d19180888c3d87655c7ccc24a056fe0eccbe5f674342",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:47.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "febe5aebe3ef4ef35c1f08adaac85196367f2426df778d7b2b15beefbb46ec9f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:56.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "9c7a3bba4d47b623a99d6665195b46dc65892a116b237955be0edcbdfc2eaa46",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:47.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "f7116103f5af8e8224180922ad527e466b9f4fc5f88079309623eec06d251c72",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:01.000Z",
      "arch": "aarch64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "32eaf867c03f5377bd6e334c8a214068748200dd0a2e6cf16241a82a285e8572",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:10:05.000Z",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "2521ab08bd7ca93e028d173c439ce9a8f986fed240fd105d19b560542531b21a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:07:58.000Z",
      "arch": "aarch64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "d734474d1910f40cf13b8dc340b4f0b512b6968bac56ade5133961c8a2cc0cca",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:11:16.000Z",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "24b79e991e1d321d68d1564f09c5af46dc845e8a84d1c9b6464a76723d9bde2d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:09:05.000Z",
      "arch": "emscripten",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "45f4336ec7f580de1e571c02f1860935509667e3643bfbc7210af0b2eb3a122f",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:07:56.000Z",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "21e4139e98106bb2135419d63061d953974e8a680d9399c7a915ad28ec1a62b4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:08:03.000Z",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "19075b5b1d821adc5f3c8332d29433ab29272153221450a89137d6eaf38fa639",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "3.53.0.9001",
      "date": "2026-05-25T06:07:55.000Z",
      "arch": "x86_64",
      "commit": "b4f4badc1ae8c38b6b942a2097be4ce2f7ee9e2f",
      "fileid": "7e1994b71ce486aa4c3ec007908c293803c1fd59f33c4a6da3b9b9c6e251cd54",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272463"
    }
  ]
}