{
  "_id": "6a1ee796b401979e7341184a",
  "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://rstudio.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:00:06 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": "69cf026fb3e6acf7156365c513ed5017",
  "_user": "rstudio",
  "_type": "src",
  "_file": "pool_1.0.5.9000.tar.gz",
  "_fileid": "7361a8c04c786a840d760d648ad8c54d70011a7ec5b29d45a2338a7d7ac39189",
  "_filesize": 166623,
  "_sha256": "7361a8c04c786a840d760d648ad8c54d70011a7ec5b29d45a2338a7d7ac39189",
  "_created": "2026-05-19T14:00:06.000Z",
  "_published": "2026-06-02T14:24:22.980Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79093635998,
      "time": 140,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7085667593"
    },
    {
      "job": 79093635697,
      "time": 146,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085669757"
    },
    {
      "job": 79093635657,
      "time": 92,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7085646511"
    },
    {
      "job": 79093635738,
      "time": 86,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085643892"
    },
    {
      "job": 79093635493,
      "time": 186,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085604945"
    },
    {
      "job": 79093635244,
      "time": 108,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7360480106"
    },
    {
      "job": 79093635581,
      "time": 109,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7085653682"
    },
    {
      "job": 79093636965,
      "time": 115,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7085657969"
    },
    {
      "job": 79093635651,
      "time": 85,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7085643940"
    }
  ],
  "_buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323",
  "_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": true,
  "_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": 513560,
    "type": "organization",
    "name": "RStudio"
  },
  "_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": true,
  "_nocasepkg": "pool",
  "_universes": [
    "rstudio",
    "hadley"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:02:19.000Z",
      "distro": "noble",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "9da2ec7381d5b9fd964fae78417e8f093eb2ae31478e9e8824a2d29cecbc75ee",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:02:27.000Z",
      "distro": "noble",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "d39e9cbe338e3c0863f92c33257fe0e4815f8062cd0af456d4a8c24b5ecb993f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:01:39.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "8dff1c1fcdb55b57c8ebe42992c65bd46bcf105bfb97babc855542f30496ce73",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:01:33.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "6d4ce1e644028a05ace2f45eb2f0519a13a9774fca7b700ff750e7f3f278ff94",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:01:48.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "d48302a8c735dea3ffa2fdc02faa1a767dfe6bfed9d0a8470f380395c96fafbf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:01:58.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "91b124b4b8c27957ff4f768e6ead2b974ac66b7b66ca68557d0819a60d234083",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.0.5.9000",
      "date": "2026-05-19T14:01:23.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "ce77b004873638420fdcf99e3c2eb9114e364e68d858d8ce6dfff329acf448f4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.5.9000",
      "date": "2026-06-02T14:23:24.000Z",
      "commit": "1fceff9f18073c35c4549c6a3f71694f0d3d1a77",
      "fileid": "623529e823bda6d1983ff60d6192c660bdbab2445344ac0f8f270cfc17ca2a2a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/26101978323"
    }
  ]
}