{
  "_id": "6a3af2f55cdecea1d67f884d",
  "Package": "RPostgres",
  "Title": "C++ Interface to PostgreSQL",
  "Version": "1.4.10.9010",
  "Date": "2026-06-21",
  "Authors@R": "c(\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(\"Jeroen\", \"Ooms\", role = \"aut\"),\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"RStudio\", role = \"cph\"),\nperson(\"R Consortium\", role = \"fnd\"),\nperson(\"Tomoaki\", \"Nishiyama\", role = \"ctb\",\ncomment = \"Code for encoding vectors into strings derived from RPostgreSQL\")\n)",
  "Description": "Fully DBI-compliant C++-backed interface to PostgreSQL\n<https://www.postgresql.org/>, an open-source relational\ndatabase.",
  "License": "MIT + file LICENSE",
  "URL": "https://rpostgres.r-dbi.org, https://github.com/r-dbi/RPostgres",
  "BugReports": "https://github.com/r-dbi/RPostgres/issues",
  "Config/Needs/website": "r-dbi/dbitemplate",
  "VignetteBuilder": "knitr",
  "Config/Needs/build": "decor",
  "Config/autostyle/scope": "line_breaks",
  "Config/autostyle/strict": "false",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "LazyLoad": "true",
  "Roxygen": "list(markdown = TRUE)",
  "SystemRequirements": "libpq >= 9.0: libpq-dev (deb) or postgresql-devel\n(rpm)",
  "Collate": "'PqDriver.R' 'PqConnection.R' 'PqResult.R' 'RPostgres-pkg.R'\n'Redshift.R' 'cpp11.R' 'dbAppendTable_PqConnection.R'\n'dbBegin_PqConnection.R' 'dbBind_PqResult.R'\n'dbClearResult_PqResult.R' 'dbColumnInfo_PqResult.R'\n'dbCommit_PqConnection.R' 'dbConnect_PqDriver.R'\n'dbConnect_RedshiftDriver.R' 'dbDataType_PqConnection.R'\n'dbDataType_PqDriver.R' 'dbDisconnect_PqConnection.R'\n'dbExistsTable_PqConnection_Id.R'\n'dbExistsTable_PqConnection_character.R' 'dbFetch_PqResult.R'\n'dbGetInfo_PqConnection.R' 'dbGetInfo_PqDriver.R'\n'dbGetRowCount_PqResult.R' 'dbGetRowsAffected_PqResult.R'\n'dbGetStatement_PqResult.R' 'dbHasCompleted_PqResult.R'\n'dbIsValid_PqConnection.R' 'dbIsValid_PqDriver.R'\n'dbIsValid_PqResult.R' 'dbListFields_PqConnection_Id.R'\n'dbListFields_PqConnection_character.R'\n'dbListObjects_PqConnection_ANY.R'\n'dbListTables_PqConnection.R'\n'dbQuoteIdentifier_PqConnection_Id.R'\n'dbQuoteIdentifier_PqConnection_SQL.R'\n'dbQuoteIdentifier_PqConnection_character.R'\n'dbQuoteLiteral_PqConnection.R'\n'dbQuoteString_PqConnection_SQL.R'\n'dbQuoteString_PqConnection_character.R'\n'dbReadTable_PqConnection_character.R'\n'dbRemoveTable_PqConnection_character.R'\n'dbRollback_PqConnection.R' 'dbSendQuery_PqConnection.R'\n'dbUnloadDriver_PqDriver.R'\n'dbUnquoteIdentifier_PqConnection_SQL.R'\n'dbWriteTable_PqConnection_character_data.frame.R' 'default.R'\n'export.R' 'quote.R' 'show_PqConnection.R'\n'sqlData_PqConnection.R' 'tables.R' 'transactions.R' 'utils.R'",
  "Config/roxygen2/version": "8.0.0.9000",
  "Config/pak/sysreqs": "libpq-dev",
  "Repository": "https://cynkra.r-universe.dev",
  "Date/Publication": "2026-06-21 05:28:42 UTC",
  "RemoteUrl": "https://github.com/r-dbi/RPostgres",
  "RemoteRef": "HEAD",
  "RemoteSha": "849cbf727f857d484bb2efad8840740cacb33310",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-23 20:46:45 UTC",
    "User": "root"
  },
  "Author": "Hadley Wickham [aut],\nJeroen Ooms [aut],\nKirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>),\nRStudio [cph],\nR Consortium [fnd],\nTomoaki Nishiyama [ctb] (Code for encoding vectors into strings derived\nfrom RPostgreSQL)",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "MD5sum": "ca24d8602531bb020d0f7e3ce232e0ed",
  "_user": "cynkra",
  "_type": "src",
  "_file": "RPostgres_1.4.10.9010.tar.gz",
  "_fileid": "181e8352310e628eca4685d90380bef5076a9acbf9673b438d79d101f43bf251",
  "_filesize": 1572157,
  "_sha256": "181e8352310e628eca4685d90380bef5076a9acbf9673b438d79d101f43bf251",
  "_created": "2026-06-23T20:46:45.000Z",
  "_published": "2026-06-23T20:56:21.454Z",
  "_distro": "resolute",
  "_jobs": [
    {
      "job": 83058299165,
      "time": 176,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7833086642"
    },
    {
      "job": 83058299166,
      "time": 170,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7833083636"
    },
    {
      "job": 83058299131,
      "time": 166,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833082731"
    },
    {
      "job": 83058299146,
      "time": 164,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833080839"
    },
    {
      "job": 83058299161,
      "time": 119,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7833064152"
    },
    {
      "job": 83058299128,
      "time": 192,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7833091519"
    },
    {
      "job": 83058299228,
      "time": 160,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833072546"
    },
    {
      "job": 83058299169,
      "time": 331,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833146252"
    },
    {
      "job": 83057520643,
      "time": 239,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833018818"
    },
    {
      "job": 83058299048,
      "time": 132,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 83058299127,
      "time": 461,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7833193980"
    },
    {
      "job": 83058299136,
      "time": 497,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7833206040"
    },
    {
      "job": 83058299145,
      "time": 517,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7833213792"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/r-dbi/RPostgres",
  "_commit": {
    "id": "849cbf727f857d484bb2efad8840740cacb33310",
    "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "fledge: Bump version to 1.4.10.9010 (#584)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1782019722
  },
  "_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",
      "role": "LinkingTo"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "blob",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "hms",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "version": ">= 1.7.3",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rlang",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "r-dbi",
  "_selfowned": false,
  "_usedby": 41,
  "_updates": [
    {
      "week": "2025-31",
      "n": 2
    },
    {
      "week": "2025-32",
      "n": 2
    },
    {
      "week": "2025-36",
      "n": 4
    },
    {
      "week": "2025-37",
      "n": 4
    },
    {
      "week": "2025-39",
      "n": 3
    },
    {
      "week": "2025-45",
      "n": 3
    },
    {
      "week": "2025-46",
      "n": 4
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-05",
      "n": 3
    },
    {
      "week": "2026-06",
      "n": 6
    },
    {
      "week": "2026-07",
      "n": 4
    },
    {
      "week": "2026-08",
      "n": 1
    },
    {
      "week": "2026-10",
      "n": 2
    },
    {
      "week": "2026-11",
      "n": 5
    },
    {
      "week": "2026-12",
      "n": 2
    },
    {
      "week": "2026-19",
      "n": 9
    },
    {
      "week": "2026-20",
      "n": 8
    },
    {
      "week": "2026-21",
      "n": 3
    },
    {
      "week": "2026-25",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.4.7.9903",
      "date": "2025-08-01"
    },
    {
      "name": "v1.4.7.9904",
      "date": "2025-08-05"
    },
    {
      "name": "v1.4.7.9905",
      "date": "2025-09-05"
    },
    {
      "name": "v1.4.7.9906",
      "date": "2025-09-06"
    },
    {
      "name": "v1.4.8.9000",
      "date": "2025-09-14"
    },
    {
      "name": "v1.4.8.9001",
      "date": "2025-09-23"
    },
    {
      "name": "v1.4.8.9002",
      "date": "2025-11-08"
    },
    {
      "name": "v1.4.8.9003",
      "date": "2025-11-11"
    },
    {
      "name": "v1.4.8.9004",
      "date": "2025-11-12"
    },
    {
      "name": "v1.4.8.9005",
      "date": "2025-11-17"
    },
    {
      "name": "v1.4.8.9006",
      "date": "2026-01-14"
    },
    {
      "name": "v1.4.8.9007",
      "date": "2026-02-02"
    },
    {
      "name": "v1.4.8.9008",
      "date": "2026-02-05"
    },
    {
      "name": "v1.4.9",
      "date": "2026-02-05"
    },
    {
      "name": "v1.4.9.9000",
      "date": "2026-02-06"
    },
    {
      "name": "v1.4.9.9001",
      "date": "2026-02-11"
    },
    {
      "name": "v1.4.10",
      "date": "2026-02-15"
    },
    {
      "name": "v1.4.10.9000",
      "date": "2026-02-16"
    },
    {
      "name": "v1.4.10.9001",
      "date": "2026-03-08"
    },
    {
      "name": "v1.4.10.9002",
      "date": "2026-03-13"
    },
    {
      "name": "v1.4.10.9003",
      "date": "2026-03-14"
    },
    {
      "name": "v1.4.10.9004",
      "date": "2026-03-22"
    },
    {
      "name": "v1.4.10.9005",
      "date": "2026-05-05"
    },
    {
      "name": "v1.4.10.9006",
      "date": "2026-05-06"
    },
    {
      "name": "v1.4.10.9007",
      "date": "2026-05-13"
    },
    {
      "name": "v1.4.10.9008",
      "date": "2026-05-16"
    },
    {
      "name": "v1.4.10.9009",
      "date": "2026-05-24"
    },
    {
      "name": "v1.4.10.9010",
      "date": "2026-06-21"
    }
  ],
  "_topics": [
    "database",
    "postgres",
    "postgresql",
    "cpp"
  ],
  "_stars": 339,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1344,
      "uuid": 1741643
    },
    {
      "user": "hadley",
      "count": 113,
      "uuid": 4196
    },
    {
      "user": "jeroen",
      "count": 54,
      "uuid": 216319
    },
    {
      "user": "antonov548",
      "count": 51,
      "uuid": 22891541
    },
    {
      "user": "dpprdan",
      "count": 25,
      "uuid": 1423562
    },
    {
      "user": "thrasibule",
      "count": 23,
      "uuid": 494248
    },
    {
      "user": "zozlak",
      "count": 16,
      "uuid": 6503177
    },
    {
      "user": "jackstat",
      "count": 14,
      "uuid": 2999465
    },
    {
      "user": "lentinj",
      "count": 10,
      "uuid": 586911
    },
    {
      "user": "tschiefer",
      "count": 9,
      "uuid": 11596155
    },
    {
      "user": "indrajeetpatil",
      "count": 8,
      "uuid": 11330453
    },
    {
      "user": "jschoenbachler",
      "count": 7,
      "uuid": 15148457
    },
    {
      "user": "etiennebr",
      "count": 7,
      "uuid": 393576
    },
    {
      "user": "pachadotdev",
      "count": 7,
      "uuid": 10091065
    },
    {
      "user": "jakob-r",
      "count": 5,
      "uuid": 1888623
    },
    {
      "user": "galachad",
      "count": 4,
      "uuid": 4296390
    },
    {
      "user": "mmuurr",
      "count": 3,
      "uuid": 5702538
    },
    {
      "user": "maelle",
      "count": 3,
      "uuid": 8360597
    },
    {
      "user": "jaredk-porch",
      "count": 3,
      "uuid": 12500708
    },
    {
      "user": "web-flow",
      "count": 3,
      "uuid": 19864447
    },
    {
      "user": "ateucher",
      "count": 2,
      "uuid": 2816635
    },
    {
      "user": "baderstine",
      "count": 2,
      "uuid": 2738299
    },
    {
      "user": "copilot",
      "count": 2,
      "uuid": 198982749
    },
    {
      "user": "jimhester",
      "count": 2,
      "uuid": 205275
    },
    {
      "user": "robertzk",
      "count": 2,
      "uuid": 1638492
    },
    {
      "user": "gatscha-trafficon",
      "count": 2,
      "uuid": 255119642
    },
    {
      "user": "troels",
      "count": 2,
      "uuid": 3203
    },
    {
      "user": "harvey131",
      "count": 2,
      "uuid": 26120526
    },
    {
      "user": "karawoo",
      "count": 2,
      "uuid": 4452678
    },
    {
      "user": "oz-r",
      "count": 1,
      "uuid": 17580114
    },
    {
      "user": "toppyy",
      "count": 1,
      "uuid": 43851547
    },
    {
      "user": "hrbrmstr",
      "count": 1,
      "uuid": 509878
    },
    {
      "user": "rstammer",
      "count": 1,
      "uuid": 3685123
    },
    {
      "user": "pedrobtz",
      "count": 1,
      "uuid": 2864346
    },
    {
      "user": "junduck",
      "count": 1,
      "uuid": 2279688
    },
    {
      "user": "daattali",
      "count": 1,
      "uuid": 952340
    },
    {
      "user": "claytonjy",
      "count": 1,
      "uuid": 5169330
    },
    {
      "user": "altons",
      "count": 1,
      "uuid": 244547
    }
  ],
  "_userbio": {
    "uuid": 38209788,
    "type": "organization",
    "name": "cynkra",
    "followers": 123,
    "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": 55222,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPostgres"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/r-dbi/rpostgres",
  "_pkgdown": "https://rpostgres.r-dbi.org",
  "_searchresults": 3616,
  "_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/RPostgres.html",
    "LICENSE",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/r-dbi/rpostgres",
  "_realowner": "r-dbi",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0-3",
      "date": "2017-12-06"
    },
    {
      "version": "1.0-4",
      "date": "2017-12-20"
    },
    {
      "version": "1.1.0",
      "date": "2018-04-06"
    },
    {
      "version": "1.1.1",
      "date": "2018-05-06"
    },
    {
      "version": "1.1.2",
      "date": "2019-12-03"
    },
    {
      "version": "1.1.3",
      "date": "2019-12-07"
    },
    {
      "version": "1.2.0",
      "date": "2019-12-18"
    },
    {
      "version": "1.2.1",
      "date": "2020-09-28"
    },
    {
      "version": "1.3.0",
      "date": "2021-01-07"
    },
    {
      "version": "1.3.1",
      "date": "2021-01-19"
    },
    {
      "version": "1.3.2",
      "date": "2021-04-12"
    },
    {
      "version": "1.3.3",
      "date": "2021-07-05"
    },
    {
      "version": "1.4.0",
      "date": "2021-09-26"
    },
    {
      "version": "1.4.1",
      "date": "2021-09-27"
    },
    {
      "version": "1.4.2",
      "date": "2021-12-05"
    },
    {
      "version": "1.4.3",
      "date": "2021-12-20"
    },
    {
      "version": "1.4.4",
      "date": "2022-05-02"
    },
    {
      "version": "1.4.5",
      "date": "2023-01-20"
    },
    {
      "version": "1.4.6",
      "date": "2023-10-22"
    },
    {
      "version": "1.4.7",
      "date": "2024-05-27"
    },
    {
      "version": "1.4.8",
      "date": "2025-02-25"
    },
    {
      "version": "1.4.9",
      "date": "2026-02-06"
    },
    {
      "version": "1.4.10",
      "date": "2026-02-16"
    }
  ],
  "_exports": [
    "dbAppendTable",
    "dbBegin",
    "dbBind",
    "dbCanConnect",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbCreateTable",
    "dbDataType",
    "dbDisconnect",
    "dbDriver",
    "dbExecute",
    "dbExistsTable",
    "dbFetch",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListFields",
    "dbListObjects",
    "dbListResults",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbReadTable",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendStatement",
    "dbUnloadDriver",
    "dbUnquoteIdentifier",
    "dbWithTransaction",
    "dbWriteTable",
    "Id",
    "Postgres",
    "postgresDefault",
    "postgresExportLargeObject",
    "postgresHasDefault",
    "postgresImportLargeObject",
    "postgresIsTransacting",
    "postgresWaitForNotify",
    "Redshift",
    "show",
    "sqlData"
  ],
  "_help": [
    {
      "page": "RPostgres-package",
      "title": "RPostgres: C++ Interface to PostgreSQL",
      "topics": [
        "RPostgres-package",
        "RPostgres"
      ]
    },
    {
      "page": "Postgres",
      "title": "Postgres driver",
      "topics": [
        "dbConnect,PqDriver-method",
        "dbConnect_PqDriver",
        "dbDisconnect,PqConnection-method",
        "dbDisconnect_PqConnection",
        "Postgres"
      ]
    },
    {
      "page": "postgres-query",
      "title": "Execute a SQL statement on a database connection",
      "topics": [
        "dbBind,PqResult-method",
        "dbBind_PqResult",
        "dbClearResult,PqResult-method",
        "dbClearResult_PqResult",
        "dbFetch,PqResult-method",
        "dbFetch_PqResult",
        "dbHasCompleted,PqResult-method",
        "dbHasCompleted_PqResult",
        "dbSendQuery,PqConnection-method",
        "dbSendQuery_PqConnection",
        "postgres-query"
      ]
    },
    {
      "page": "postgres-tables",
      "title": "Convenience functions for reading/writing DBMS tables",
      "topics": [
        "dbAppendTable,PqConnection-method",
        "dbAppendTable_PqConnection",
        "dbExistsTable,PqConnection,character-method",
        "dbExistsTable,PqConnection,Id-method",
        "dbExistsTable_PqConnection_character",
        "dbExistsTable_PqConnection_Id",
        "dbListFields,PqConnection,character-method",
        "dbListFields,PqConnection,Id-method",
        "dbListFields_PqConnection_character",
        "dbListFields_PqConnection_Id",
        "dbListObjects,PqConnection-method",
        "dbListObjects_PqConnection_ANY",
        "dbListTables,PqConnection-method",
        "dbListTables_PqConnection",
        "dbReadTable,PqConnection,character-method",
        "dbReadTable_PqConnection_character",
        "dbRemoveTable,PqConnection,character-method",
        "dbRemoveTable_PqConnection_character",
        "dbWriteTable,PqConnection,character,data.frame-method",
        "dbWriteTable_PqConnection_character_data.frame",
        "postgres-tables",
        "sqlData,PqConnection-method",
        "sqlData_PqConnection"
      ]
    },
    {
      "page": "postgres-transactions",
      "title": "Transaction management.",
      "topics": [
        "dbBegin,PqConnection-method",
        "dbBegin_PqConnection",
        "dbCommit,PqConnection-method",
        "dbCommit_PqConnection",
        "dbRollback,PqConnection-method",
        "dbRollback_PqConnection",
        "postgres-transactions"
      ]
    },
    {
      "page": "postgresExportLargeObject",
      "title": "Exports a large object to file",
      "topics": [
        "postgresExportLargeObject"
      ]
    },
    {
      "page": "postgresHasDefault",
      "title": "Check if default database is available.",
      "topics": [
        "postgresDefault",
        "postgresHasDefault"
      ]
    },
    {
      "page": "postgresImportLargeObject",
      "title": "Imports a large object from file",
      "topics": [
        "postgresImportLargeObject"
      ]
    },
    {
      "page": "postgresIsTransacting",
      "title": "Return whether a transaction is ongoing",
      "topics": [
        "postgresIsTransacting"
      ]
    },
    {
      "page": "postgresWaitForNotify",
      "title": "Wait for and return any notifications that return within timeout",
      "topics": [
        "postgresWaitForNotify"
      ]
    },
    {
      "page": "quote",
      "title": "Quote postgres strings, identifiers, and literals",
      "topics": [
        "dbQuoteIdentifier,PqConnection,character-method",
        "dbQuoteIdentifier,PqConnection,Id-method",
        "dbQuoteIdentifier,PqConnection,SQL-method",
        "dbQuoteIdentifier_PqConnection_character",
        "dbQuoteIdentifier_PqConnection_Id",
        "dbQuoteIdentifier_PqConnection_SQL",
        "dbQuoteLiteral,PqConnection-method",
        "dbQuoteLiteral_PqConnection",
        "dbQuoteString,PqConnection,character-method",
        "dbQuoteString,PqConnection,SQL-method",
        "dbQuoteString_PqConnection_character",
        "dbQuoteString_PqConnection_SQL",
        "dbUnquoteIdentifier,PqConnection,SQL-method",
        "dbUnquoteIdentifier_PqConnection_SQL",
        "quote"
      ]
    },
    {
      "page": "Redshift",
      "title": "Redshift driver/connection",
      "topics": [
        "dbConnect,RedshiftDriver-method",
        "dbConnect_RedshiftDriver",
        "Redshift",
        "RedshiftConnection-class",
        "RedshiftDriver-class"
      ]
    }
  ],
  "_readme": "https://github.com/r-dbi/RPostgres/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "lubridate",
    "pkgconfig",
    "rlang",
    "timechange",
    "vctrs",
    "withr"
  ],
  "_sysdeps": [
    {
      "shlib": "libpq",
      "package": "libpq5",
      "headers": "libpq-dev",
      "source": "postgresql",
      "version": "18.4-0ubuntu0.26.04.1",
      "name": "postgresql",
      "homepage": "http://www.postgresql.org/",
      "description": "PostgreSQL C client library"
    },
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "16-20260322-1ubuntu1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_vignettes": [
    {
      "source": "work-queue.Rmd",
      "filename": "work-queue.html",
      "title": "Implementing a Work Queue using RPostgres",
      "author": "Jamie Lentin",
      "engine": "knitr::rmarkdown",
      "headings": [
        "LISTEN / NOTIFY",
        "SKIP LOCKED",
        "Implementing our worker"
      ],
      "created": "2020-10-18 06:16:59",
      "modified": "2026-02-15 18:52:51",
      "commits": 9
    }
  ],
  "_score": 15.488647087139382,
  "_indexed": false,
  "_nocasepkg": "rpostgres",
  "_universes": [
    "cynkra"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RPostgres",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:51.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "b4975a7e6f16e9cbe73afead5a319f8b4284d6d4c306a3940016157eb9b0d499",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:33.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "61b45f49ddf0f23558b3c8feafcda6fa1fcbf80bf3635ccda0133044a1f86481",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:40.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "51adb574f18da226520960abb994d1d978943253aea984dcda969e311eda241a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:28.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "7b9d4ba99d2c065346b1d7ee3909034b941236dac4d50133a72acb3efab3d906",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:48:48.000Z",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "93f6964d743abd561c6c077eaa22fbbb21d18e00264b3b8fdc47b05946570144",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:31.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "c523ab5d224c954b194ab772f8bcfa15dcee3af3f46c7dd95833d15a37fa9c61",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:49:04.000Z",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "09228803c1dcb3c67bab0357c5a6e233fd808918ef8a7a717308b923c998708c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:51:06.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "0abee6846aba6a322093efac17aa5c9cbd47ef5926ce46807d1a861b0550ddad",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:48:37.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "6275afdb288597bff5f50c7248e1ddceb0c35577c6a6f993e0fe783b92edeedb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:48:43.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "43381670a33b2268b316745ba605c91c1dda300a9b84079b9efea0165d422563",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-23T20:48:38.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "8eda8586ec81082542452df21f7c86037849bd6c555f3f1ed07014f6ad00f738",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/28055742646"
    }
  ]
}