{
  "_id": "6ac793a9de46216d5edd270e",
  "Package": "connections",
  "Title": "Integrates with the 'RStudio' Connections Pane and 'pins'",
  "Version": "0.2.1",
  "Authors@R": "c(\nperson(\"Edgar\", \"Ruiz\", email = \"edgar@posit.co\", role = c(\"aut\", \"cre\")),\nperson(given = \"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "Enables 'DBI' compliant packages to integrate with the\n'RStudio' connections pane, and the 'pins' package. It\nautomates the display of schemata, tables, views, as well as\nthe preview of the table's top 1000 records.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.3",
  "URL": "https://github.com/rstudio/connections,\nhttps://rstudio.github.io/connections/",
  "BugReports": "https://github.com/rstudio/connections/issues",
  "Config/testthat/edition": "3",
  "Config/Needs/website": "tidyverse/tidytemplate",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libssl-dev",
  "Repository": "https://rstudio.r-universe.dev",
  "Date/Publication": "2025-09-10 18:23:20 UTC",
  "RemoteUrl": "https://github.com/rstudio/connections",
  "RemoteRef": "HEAD",
  "RemoteSha": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-08 12:55:57 UTC",
    "User": "root"
  },
  "Author": "Edgar Ruiz [aut, cre],\nPosit Software, PBC [cph, fnd]",
  "Maintainer": "Edgar Ruiz <edgar@posit.co>",
  "_user": "rstudio",
  "_type": "src",
  "_file": "connections_0.2.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/b97937b02594e0662a8a56c5d569f64bccc208049a41c2a07eb8007590f4ed19",
  "_filesize": 996870,
  "_sha256": "b97937b02594e0662a8a56c5d569f64bccc208049a41c2a07eb8007590f4ed19",
  "_expires": "2027-01-16T12:59:19.000Z",
  "_created": "2026-10-08T12:55:57.000Z",
  "_published": "2026-10-08T12:59:21.413Z",
  "_buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 113322051308,
      "time": 160,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11552051963"
    },
    {
      "job": 113322051160,
      "time": 122,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11552220567"
    },
    {
      "job": 113322051194,
      "time": 89,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11551921793"
    },
    {
      "job": 113322051333,
      "time": 118,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11551797057"
    },
    {
      "job": 113320700520,
      "time": 191,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11552205212"
    },
    {
      "job": 113322051369,
      "time": 94,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11552310349"
    },
    {
      "job": 113322051158,
      "time": 87,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11551569898"
    },
    {
      "job": 113322051098,
      "time": 77,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11552150551"
    },
    {
      "job": 113322051131,
      "time": 69,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11552595197"
    }
  ],
  "_upstream": "https://github.com/rstudio/connections",
  "_commit": {
    "id": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
    "author": "Edgar Ruiz <77294576+edgararuiz@users.noreply.github.com>",
    "committer": "Edgar Ruiz <77294576+edgararuiz@users.noreply.github.com>",
    "message": "Refreshes README\n",
    "time": 1757528600
  },
  "_maintainer": {
    "name": "Edgar Ruiz",
    "email": "edgar@posit.co",
    "login": "edgararuiz",
    "bluesky": "@theotheredgar.bsky.social",
    "linkedin": "in/edgararuiz",
    "description": "",
    "uuid": 77294576
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "pins",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "uuid",
      "role": "Imports"
    },
    {
      "package": "rscontract",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    }
  ],
  "_owner": "rstudio",
  "_selfowned": true,
  "_usedby": 5,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "connection-pane",
    "database-connection",
    "pins",
    "rstudio"
  ],
  "_stars": 59,
  "_contributors": [
    {
      "user": "edgararuiz-zz",
      "count": 63,
      "uuid": 7875923
    },
    {
      "user": "edgararuiz",
      "count": 61,
      "uuid": 77294576
    },
    {
      "user": "javierluraschi",
      "count": 2,
      "uuid": 3478847
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    }
  ],
  "_userbio": {
    "uuid": 513560,
    "type": "organization",
    "name": "RStudio",
    "followers": 3591
  },
  "_downloads": {
    "count": 737,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/connections"
  },
  "_devurl": "https://github.com/rstudio/connections",
  "_pkgdown": "https://rstudio.github.io/connections/",
  "_searchresults": 135,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/connections.html",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/rstudio/connections",
  "_realowner": "rstudio",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2019-10-28"
    },
    {
      "version": "0.1.1",
      "date": "2020-02-07"
    },
    {
      "version": "0.2.0",
      "date": "2023-12-18"
    },
    {
      "version": "0.2.1",
      "date": "2025-09-11"
    }
  ],
  "_exports": [
    "connection_close",
    "connection_code",
    "connection_open",
    "connection_pin_read",
    "connection_pin_write",
    "connection_update",
    "connection_view",
    "dbSendQuery",
    "dbWriteTable",
    "read_pin_conn",
    "write_pin_conn"
  ],
  "_help": [
    {
      "page": "connection_close",
      "title": "Close a connection",
      "topics": [
        "connection_close"
      ]
    },
    {
      "page": "connection_code",
      "title": "Displays the code that will be used to recreate the connection",
      "topics": [
        "connection_code"
      ]
    },
    {
      "page": "connection_open",
      "title": "Opens a connection",
      "topics": [
        "connection_open"
      ]
    },
    {
      "page": "connection_pin_read",
      "title": "Retrieves a database connection or query from a board",
      "topics": [
        "connection_pin_read"
      ]
    },
    {
      "page": "connection_pin_write",
      "title": "Writes a database connection or query to a board",
      "topics": [
        "connection_pin_write"
      ]
    },
    {
      "page": "connection_update",
      "title": "Refreshes a connection",
      "topics": [
        "connection_update"
      ]
    },
    {
      "page": "connection_view",
      "title": "Populates the RStudio Connection viewer",
      "topics": [
        "connection_view"
      ]
    }
  ],
  "_pkglogo": "https://github.com/rstudio/connections/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/rstudio/connections/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "blob",
    "cli",
    "cpp11",
    "curl",
    "DBI",
    "dbplyr",
    "digest",
    "dplyr",
    "fs",
    "generics",
    "glue",
    "httr",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "mime",
    "nanoparquet",
    "openssl",
    "pillar",
    "pins",
    "pkgconfig",
    "purrr",
    "R6",
    "rappdirs",
    "rlang",
    "rscontract",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "uuid",
    "vctrs",
    "whisker",
    "withr",
    "yaml"
  ],
  "_score": 7.253368298248513,
  "_indexed": true,
  "_nocasepkg": "connections",
  "_universes": [
    "rstudio",
    "edgararuiz"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.2.1",
      "date": "2026-10-08T12:58:42.000Z",
      "distro": "resolute",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/c0656791477b717988b85edf7fb3ec649064ac78408fab8368b2dcff1e586b4c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.2.1",
      "date": "2026-10-08T12:58:00.000Z",
      "distro": "resolute",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/83b236afd6acdff01f4302651a8f567a4554c9436b3574ecc509eb3281c5e930",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:36.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/4de511c4e2d0c84c93c6f9e03ae17aa238765d8080cd299c2eeab257272c6319",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:59.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/d2bdf2f19712e0c9be94d76de749ae06d0256aa56027f22b09b05c447a813c2c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:52.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/bfd0287dd13e8b60e264e34801208e1e149ebf4fa97f4aa3c9cfc7f4bc42cba7",
      "status": "success",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:18.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/e10e16a3a765eb66b327b2ec5a4eed6b1c076625c9dc40153b61c621f29b3600",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:09.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/785012202809b1dc85ba8711eee8983b6369edb12870ae3568fe332c6b30c6bc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.2.1",
      "date": "2026-10-08T12:57:04.000Z",
      "commit": "a265f99ea771ee5613908f1fdab225d9c81bdf63",
      "fileid": "https://r2.ropensci.org/4c6f5e4c3ee2617a3977640588a421ed8107137be6bab5de2dce2866e5de3089",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rstudio/actions/runs/37780039907"
    }
  ]
}