{
  "_id": "6ad20324fdc1a00814f1eb8e",
  "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.1.0",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "Repository": "https://posit-dev-shinycoreci.r-universe.dev",
  "Date/Publication": "2026-09-16 12:22:44 UTC",
  "RemoteUrl": "https://github.com/rstudio/pool",
  "RemoteRef": "HEAD",
  "RemoteSha": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-16 10:54: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>",
  "_user": "posit-dev-shinycoreci",
  "_type": "src",
  "_file": "pool_1.0.5.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/95127a0cdb2e7f3ea6b7a1ae9f943d1a2d6955ec19067b701a46c4f26205c10d",
  "_filesize": 165674,
  "_sha256": "95127a0cdb2e7f3ea6b7a1ae9f943d1a2d6955ec19067b701a46c4f26205c10d",
  "_expires": "2027-01-24T10:57:35.000Z",
  "_created": "2026-10-16T10:54:22.000Z",
  "_published": "2026-10-16T10:57:40.641Z",
  "_buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 116937977489,
      "time": 126,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12041217460"
    },
    {
      "job": 116937977412,
      "time": 155,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12042215179"
    },
    {
      "job": 116937977282,
      "time": 145,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12042100372"
    },
    {
      "job": 116937977370,
      "time": 104,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12042085242"
    },
    {
      "job": 116936857092,
      "time": 185,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12041630771"
    },
    {
      "job": 116937977425,
      "time": 83,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12040984368"
    },
    {
      "job": 116937977454,
      "time": 121,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12040969996"
    },
    {
      "job": 116937977297,
      "time": 125,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12041477051"
    },
    {
      "job": 116937977326,
      "time": 84,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12041446947"
    }
  ],
  "_upstream": "https://github.com/rstudio/pool",
  "_commit": {
    "id": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
    "author": "Hadley Wickham <h.wickham@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Upkeep 2026-09 (#206)\n\n* Re-document\n* `use_tidy_github_actions()`\n* `use_tidy_agents()`",
    "time": 1789561364
  },
  "_maintainer": {
    "name": "Hadley Wickham",
    "email": "hadley@posit.co",
    "login": "hadley",
    "bluesky": "@hadley.nz",
    "description": "Chief Scientist at @posit-pbc",
    "uuid": 4196
  },
  "_distro": "resolute",
  "_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": 31,
  "_updates": [
    {
      "week": "2026-20",
      "n": 2
    },
    {
      "week": "2026-21",
      "n": 3
    },
    {
      "week": "2026-38",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.0.5",
      "date": "2026-05-18"
    }
  ],
  "_stars": 256,
  "_contributors": [
    {
      "user": "bborgesr",
      "count": 105,
      "uuid": 6527540
    },
    {
      "user": "hadley",
      "count": 76,
      "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": "sims1253",
      "count": 1,
      "uuid": 6530123
    },
    {
      "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",
    "followers": 0
  },
  "_downloads": {
    "count": 20772,
    "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": 1026,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/pool.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_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.328597878962501,
  "_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-10-16T10:56:25.000Z",
      "distro": "resolute",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/c4373651bebc94bf179e501ad85d92442c7edcb09df7d35e5da13d61163000d9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:51.000Z",
      "distro": "resolute",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/e7bd489b4d2900e8c13435a5e2de2e3700918ebe0a78918220d3de8e307f1e15",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:43.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/abd9d112515de8eedc407ff6892a9e62ac7594567578f00da08e704cad350057",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:10.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/94af2518495da0e18c6633086f27662e81a7e61958a25e4997596678c38a8a25",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:06.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/464fe2c4ea84b769d2f0749631d8369e4f2d92e74e26f7abd5deee43b0f03bcb",
      "status": "success",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:09.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/f28d09ddc350d2c8ee723ed1438f792849ae6fb1e4dab6d43ebc8551ebbbf549",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:56:28.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/ba56f42871d9a8ca29fe13261ee405cfb29c566b7a0cda45d9d5411e582b4944",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-10-16T10:55:38.000Z",
      "commit": "a87d5a9cb78719e2dc6708cbec76730e9c6cdd44",
      "fileid": "https://r2.ropensci.org/4baf674901ba784c8680556726fa9bf645c6a035ae6c2df2fa1d2558eefca269",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev-shinycoreci/actions/runs/38889951065"
    }
  ]
}