{
  "_id": "6a1ee769b401979e7341179a",
  "Type": "Package",
  "Package": "pool",
  "Title": "Object Pooling",
  "Version": "1.0.5.9000",
  "Authors@R": "c(\nperson(\"Joe\", \"Cheng\", , \"joe@posit.co\", role = \"aut\"),\nperson(\"Barbara\", \"Borges\", role = \"aut\"),\nperson(\"Hadley\", \"Wickham\", , \"hadley@posit.co\", role = c(\"aut\", \"cre\")),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "Enables the creation of object pools, which make it less\ncomputationally expensive to fetch a new object. Currently the\nonly supported pooled objects are 'DBI' connections.",
  "License": "MIT + file LICENSE",
  "URL": "https://github.com/rstudio/pool, https://rstudio.github.io/pool/",
  "BugReports": "https://github.com/rstudio/pool/issues",
  "VignetteBuilder": "knitr",
  "Config/Needs/website": "tidyverse/tidytemplate",
  "Config/roxygen2/version": "8.0.0",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "Repository": "https://posit-dev-shinycoreci.r-universe.dev",
  "Date/Publication": "2026-05-19 13:20:18 UTC",
  "RemoteUrl": "https://github.com/rstudio/pool",
  "RemoteRef": "HEAD",
  "RemoteSha": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-19 14:04:22 UTC",
    "User": "root"
  },
  "Author": "Joe Cheng [aut],\nBarbara Borges [aut],\nHadley Wickham [aut, cre],\nPosit Software, PBC [cph, fnd]",
  "Maintainer": "Hadley Wickham <hadley@posit.co>",
  "MD5sum": "782b5ade956898615a27f23db2dafbc8",
  "_user": "posit-dev-shinycoreci",
  "_type": "src",
  "_file": "pool_1.0.5.9000.tar.gz",
  "_fileid": "11d858bce674ef8d7f58d812771b0961bbe92bd7e25874a440b61fac742bb45b",
  "_filesize": 166656,
  "_sha256": "11d858bce674ef8d7f58d812771b0961bbe92bd7e25874a440b61fac742bb45b",
  "_created": "2026-05-19T14:04:22.000Z",
  "_published": "2026-06-02T14:23:37.144Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79093563632,
      "time": 192,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7085807018"
    },
    {
      "job": 79093563570,
      "time": 131,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085779293"
    },
    {
      "job": 79093563580,
      "time": 134,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7085801522"
    },
    {
      "job": 79093563556,
      "time": 103,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085774174"
    },
    {
      "job": 79093563153,
      "time": 224,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085717920"
    },
    {
      "job": 79093562590,
      "time": 115,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7360474195"
    },
    {
      "job": 79093563598,
      "time": 94,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7085762127"
    },
    {
      "job": 79093564217,
      "time": 118,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7085773203"
    },
    {
      "job": 79093563717,
      "time": 92,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085762032"
    }
  ],
  "_buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/rstudio/pool",
  "_commit": {
    "id": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
    "author": "Hadley Wickham <h.wickham@gmail.com>",
    "committer": "Hadley Wickham <h.wickham@gmail.com>",
    "message": "Increment version number to 1.0.5.9000\n",
    "time": 1779196818
  },
  "_maintainer": {
    "name": "Hadley Wickham",
    "email": "hadley@posit.co",
    "login": "hadley",
    "bluesky": "@hadley.nz",
    "description": "Chief Scientist at @posit-pbc",
    "uuid": 4196
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "methods",
      "role": "Depends"
    },
    {
      "package": "R",
      "version": ">= 3.6.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "version": ">= 1.2.1",
      "role": "Imports"
    },
    {
      "package": "later",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "R6",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.4.0",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "shiny",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    }
  ],
  "_owner": "rstudio",
  "_selfowned": false,
  "_usedby": 33,
  "_updates": [
    {
      "week": "2026-20",
      "n": 2
    },
    {
      "week": "2026-21",
      "n": 3
    }
  ],
  "_tags": [
    {
      "name": "v1.0.5",
      "date": "2026-05-18"
    }
  ],
  "_stars": 254,
  "_contributors": [
    {
      "user": "bborgesr",
      "count": 105,
      "uuid": 6527540
    },
    {
      "user": "hadley",
      "count": 75,
      "uuid": 4196
    },
    {
      "user": "jcheng5",
      "count": 33,
      "uuid": 129551
    },
    {
      "user": "wch",
      "count": 11,
      "uuid": 86978
    },
    {
      "user": "yupimaki",
      "count": 2,
      "uuid": 5243408
    },
    {
      "user": "schloerke",
      "count": 2,
      "uuid": 93231
    },
    {
      "user": "krlmlr",
      "count": 2,
      "uuid": 1741643
    },
    {
      "user": "renkun-ken",
      "count": 1,
      "uuid": 4662568
    },
    {
      "user": "marcosci",
      "count": 1,
      "uuid": 10864574
    },
    {
      "user": "nwstephens",
      "count": 1,
      "uuid": 7519295
    },
    {
      "user": "philippleppert",
      "count": 1,
      "uuid": 29381829
    },
    {
      "user": "smach",
      "count": 1,
      "uuid": 3394160
    },
    {
      "user": "caewok",
      "count": 1,
      "uuid": 1267134
    },
    {
      "user": "pnacht",
      "count": 1,
      "uuid": 15221358
    }
  ],
  "_userbio": {
    "uuid": 159192787,
    "type": "organization",
    "name": "posit-dev-shinycoreci"
  },
  "_downloads": {
    "count": 17038,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/pool"
  },
  "_mentions": 2,
  "_devurl": "https://github.com/rstudio/pool",
  "_pkgdown": "https://rstudio.github.io/pool/",
  "_searchresults": 1062,
  "_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/pool.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/rstudio/pool",
  "_realowner": "rstudio",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.1",
      "date": "2017-09-23"
    },
    {
      "version": "0.1.2",
      "date": "2017-11-03"
    },
    {
      "version": "0.1.3",
      "date": "2017-11-03"
    },
    {
      "version": "0.1.4",
      "date": "2018-03-10"
    },
    {
      "version": "0.1.4.1",
      "date": "2018-06-29"
    },
    {
      "version": "0.1.4.2",
      "date": "2019-01-07"
    },
    {
      "version": "0.1.4.3",
      "date": "2019-10-03"
    },
    {
      "version": "0.1.5",
      "date": "2020-11-03"
    },
    {
      "version": "0.1.6",
      "date": "2021-01-14"
    },
    {
      "version": "1.0.0",
      "date": "2023-02-11"
    },
    {
      "version": "1.0.1",
      "date": "2023-02-21"
    },
    {
      "version": "1.0.2",
      "date": "2024-01-18"
    },
    {
      "version": "1.0.3",
      "date": "2024-02-14"
    },
    {
      "version": "1.0.4",
      "date": "2024-10-07"
    },
    {
      "version": "1.0.5",
      "date": "2026-05-19"
    }
  ],
  "_exports": [
    "dbAppendTable",
    "dbAppendTableArrow",
    "dbBegin",
    "dbBreak",
    "dbCommit",
    "dbCreateTable",
    "dbCreateTableArrow",
    "dbDataType",
    "dbDisconnect",
    "dbExecute",
    "dbExistsTable",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetQueryArrow",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListFields",
    "dbListObjects",
    "dbListTables",
    "dbPool",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbReadTable",
    "dbReadTableArrow",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendQueryArrow",
    "dbSendStatement",
    "dbUnquoteIdentifier",
    "dbWithTransaction",
    "dbWriteTable",
    "dbWriteTableArrow",
    "demoDb",
    "localCheckout",
    "onActivate",
    "onDestroy",
    "onPassivate",
    "onValidate",
    "Pool",
    "poolCheckout",
    "poolClose",
    "poolCreate",
    "poolReturn",
    "poolWithTransaction",
    "sqlAppendTable",
    "sqlCreateTable",
    "sqlData",
    "sqlInterpolate",
    "sqlParseVariables"
  ],
  "_help": [
    {
      "page": "DBI-custom",
      "title": "Unsupported DBI methods",
      "topics": [
        "dbBegin,Pool-method",
        "dbCommit,Pool-method",
        "dbDisconnect,Pool-method",
        "dbGetInfo,Pool-method",
        "DBI-custom",
        "dbIsValid,Pool-method",
        "dbRollback,Pool-method",
        "dbSendQuery,Pool-method",
        "dbSendStatement,Pool,ANY-method",
        "dbWithTransaction,Pool-method"
      ]
    },
    {
      "page": "DBI-wrap",
      "title": "DBI methods (simple wrappers)",
      "topics": [
        "dbAppendTable,Pool-method",
        "dbAppendTableArrow,Pool-method",
        "dbCreateTable,Pool-method",
        "dbCreateTableArrow,Pool-method",
        "dbDataType,Pool-method",
        "dbExecute,Pool,ANY-method",
        "dbExistsTable,Pool,ANY-method",
        "dbGetQuery,Pool,ANY-method",
        "dbGetQueryArrow,Pool-method",
        "DBI-wrap",
        "dbIsReadOnly,Pool-method",
        "dbListFields,Pool,ANY-method",
        "dbListObjects,Pool-method",
        "dbListTables,Pool-method",
        "dbQuoteIdentifier,Pool,ANY-method",
        "dbQuoteLiteral,Pool-method",
        "dbQuoteString,Pool,ANY-method",
        "dbReadTable,Pool,ANY-method",
        "dbReadTableArrow,Pool-method",
        "dbRemoveTable,Pool,ANY-method",
        "dbSendQueryArrow,Pool-method",
        "dbUnquoteIdentifier,Pool-method",
        "dbWriteTable,Pool,ANY-method",
        "dbWriteTableArrow,Pool-method",
        "sqlAppendTable,Pool-method",
        "sqlCreateTable,Pool-method",
        "sqlData,Pool-method",
        "sqlInterpolate,Pool-method",
        "sqlParseVariables,Pool-method"
      ]
    },
    {
      "page": "dbPool",
      "title": "Create a pool of database connections",
      "topics": [
        "dbPool"
      ]
    },
    {
      "page": "Pool-class",
      "title": "Create a pool of reusable objects",
      "topics": [
        "Pool",
        "Pool-class",
        "poolClose",
        "poolClose,Pool-method",
        "poolCreate"
      ]
    },
    {
      "page": "poolCheckout",
      "title": "Check out and return object from the pool",
      "topics": [
        "localCheckout",
        "poolCheckout",
        "poolCheckout,Pool-method",
        "poolReturn",
        "poolReturn,ANY-method"
      ]
    },
    {
      "page": "poolWithTransaction",
      "title": "Self-contained database transactions using pool",
      "topics": [
        "poolWithTransaction"
      ]
    },
    {
      "page": "tbl.Pool",
      "title": "Use pool with dbplyr",
      "topics": [
        "copy_to.Pool",
        "tbl.Pool"
      ]
    }
  ],
  "_readme": "https://github.com/rstudio/pool/raw/HEAD/README.md",
  "_rundeps": [
    "DBI",
    "later",
    "R6",
    "Rcpp",
    "rlang"
  ],
  "_vignettes": [
    {
      "source": "why-pool.Rmd",
      "filename": "why-pool.html",
      "title": "Why pool?",
      "engine": "knitr::rmarkdown",
      "headings": [
        "One connection per app",
        "One connection per query",
        "Pool: the best of both worlds"
      ],
      "created": "2023-01-29 16:54:13",
      "modified": "2024-10-03 12:15:05",
      "commits": 2
    }
  ],
  "_score": 13.07298538984206,
  "_indexed": false,
  "_nocasepkg": "pool",
  "_universes": [
    "posit-dev-shinycoreci"
  ],
  "_indexurl": "https://rstudio.r-universe.dev/pool",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:07:30.000Z",
      "distro": "noble",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "3f6cdbf0236912f7366740a3f06a41eb13fa6fdfecd9e26c328161dc8f7edc60",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:06:32.000Z",
      "distro": "noble",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "136b5100425f7943e02cf528e385a0c881f2f0f6e8347d167bd3c4a415c95dd8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:07:22.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "b3866954d2c92ed606f6a35a231d217faaeaa9ea2280002a2b66bc1e7f60af1d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:06:24.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "30a26eeff2e207c14039fb7ed16ac536070edb9d23cfbe299d5f459406c10736",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:05:49.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "fa01a340a253f11bb934dcb59b66488e6528afa2bfc398f76d8cfbe67d59ebb9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:06:16.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "df689abac4fdd3167e2e03cade25d65fe7002d1c887a47a7fc8ddc06f5b93f88",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:05:48.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "54eec6d8856779d03b4f89cd65ef4baaf6e91a61c51d9504b50b296ace1fa920",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.5.9000",
      "date": "2026-06-02T14:23:10.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "3c8ba5cfcf2921b49b28ea44289ad4400c4485ab7bf7c397f897e390bed277e0",
      "status": "success",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/26102160359"
    }
  ]
}