{
  "_id": "6a12a267acfb0bcc41d11cf8",
  "Package": "RPostgres",
  "Title": "C++ Interface to PostgreSQL",
  "Version": "1.4.10.9009",
  "Date": "2026-05-24",
  "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-05-24 04:51:07 UTC",
  "RemoteUrl": "https://github.com/r-dbi/RPostgres",
  "RemoteRef": "HEAD",
  "RemoteSha": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-05-24 06:46:14 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": "9e22de1140c60ce6cfeb88967fb30c0f",
  "_user": "cynkra",
  "_type": "src",
  "_file": "RPostgres_1.4.10.9009.tar.gz",
  "_fileid": "af43e02f04981bc5e1a59dc5b0d09821c8ceb84079ac63a10a0034de52364844",
  "_filesize": 1568167,
  "_sha256": "af43e02f04981bc5e1a59dc5b0d09821c8ceb84079ac63a10a0034de52364844",
  "_created": "2026-05-24T06:46:14.000Z",
  "_published": "2026-05-24T07:01:59.079Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77578241995,
      "time": 151,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183001265"
    },
    {
      "job": 77578241994,
      "time": 171,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183003404"
    },
    {
      "job": 77578241992,
      "time": 158,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183001798"
    },
    {
      "job": 77578242001,
      "time": 208,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183006827"
    },
    {
      "job": 77578241974,
      "time": 128,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183047386"
    },
    {
      "job": 77578241975,
      "time": 277,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183039381"
    },
    {
      "job": 77578241980,
      "time": 117,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183076208"
    },
    {
      "job": 77578241986,
      "time": 220,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183050745"
    },
    {
      "job": 77578037387,
      "time": 242,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7182985843"
    },
    {
      "job": 77578241951,
      "time": 152,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 77578241972,
      "time": 447,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183032113"
    },
    {
      "job": 77578241968,
      "time": 452,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183032457"
    },
    {
      "job": 77578241976,
      "time": 457,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183032929"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/r-dbi/RPostgres",
  "_commit": {
    "id": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
    "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.9009 (#578)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1779598267
  },
  "_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": 40,
  "_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
    }
  ],
  "_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"
    }
  ],
  "_topics": [
    "database",
    "postgres",
    "postgresql",
    "cpp"
  ],
  "_stars": 337,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1343,
      "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",
    "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": 53642,
    "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": 3920,
  "_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",
    "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": "16.14-0ubuntu0.24.04.1",
      "name": "postgresql",
      "homepage": "http://www.postgresql.org/",
      "description": "PostgreSQL C client library"
    },
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "14.2.0-4ubuntu2~24.04.1",
      "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.475527505106653,
  "_indexed": false,
  "_nocasepkg": "rpostgres",
  "_universes": [
    "cynkra"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RPostgres",
  "_previous": "1.4.10.9008",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:48:47.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "e9b962305d2833fd8ccf8610c4d6aba462d737b1ffdcd8862923ee8d942b7b40",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:48:59.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "a73d00c833d81af876d14ed05ab3aab073c56206fc320ee2c0169716fb09f575",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:48:50.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "bc71174395a1e5f77ddc2141f4adcdf3171fdf6e84e03f9dd4854866e24ac626",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:49:36.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "104379653fcd33025199d889f4658891ea16bc48f7c8f7a32dea2c640c59cf14",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:56:17.000Z",
      "arch": "aarch64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "c5698e255b75afd3201bf59a1e1dbe975ab5181d6cf656c98ea30ffb5387e12d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:53:56.000Z",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "88597dcafe86b753bec6b9275e25a2bc6abefd858a90428fae076e944662f9fe",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9009",
      "date": "2026-05-24T07:01:04.000Z",
      "arch": "aarch64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "386e86ce8a1f7a3c4f30c991dc9a23a5fb91d02149e4a23b1c67edbd5de41d0a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:56:04.000Z",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "93b52fe461a3dc6dcf19ec3db0d3b8ccb55fac436634d9b2f274d8f5d779ad83",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:47:55.000Z",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "7fd3759a312657e37ffbfeb34f892436855eafdfebe59d03381e1a8dabe4b091",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:47:57.000Z",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "6c8c8b08187b3e8e916a08a9b62aed4064a75e265d9793f9c8faaf46137f1c14",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.4.10.9009",
      "date": "2026-05-24T06:47:57.000Z",
      "arch": "x86_64",
      "commit": "567d0fe7fb13b1e8b12ed80f56261a38eeee4d3b",
      "fileid": "47187cd2edc3b38016c586c92329c1f938cfdf3135b6c9338449b441de021afa",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cynkra/actions/runs/26354272120"
    }
  ]
}