{
  "_id": "6a310c843efcd9bda4357cdb",
  "Package": "RPostgres",
  "Title": "C++ Interface to PostgreSQL",
  "Version": "1.4.10",
  "Date": "2026-02-11",
  "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",
  "RoxygenNote": "7.3.3.9000",
  "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'",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-16 08:38:55 UTC",
    "User": "root"
  },
  "Author": "Hadley Wickham [aut], Jeroen Ooms [aut], Kirill Müller [aut,\ncre] (ORCID: <https://orcid.org/0000-0002-1416-3412>), RStudio\n[cph], R Consortium [fnd], Tomoaki Nishiyama [ctb] (Code for\nencoding vectors into strings derived from RPostgreSQL)",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "Config/pak/sysreqs": "libpq-dev",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-02-16 10:30:09 UTC",
  "RemoteUrl": "https://github.com/cran/RPostgres",
  "RemoteRef": "HEAD",
  "RemoteSha": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
  "MD5sum": "dab012eb913ba144b8a9d27b9b6d275b",
  "_user": "cran",
  "_type": "src",
  "_file": "RPostgres_1.4.10.tar.gz",
  "_fileid": "86adba3ec0408819a0a486e027fa245cbc1c8c47573bd2a30936aaa01e42576f",
  "_filesize": 1568300,
  "_sha256": "86adba3ec0408819a0a486e027fa245cbc1c8c47573bd2a30936aaa01e42576f",
  "_created": "2026-06-16T08:38:55.000Z",
  "_published": "2026-06-16T08:42:44.778Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 81615562392,
      "time": 155,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7661607934"
    },
    {
      "job": 81615562520,
      "time": 159,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7661612055"
    },
    {
      "job": 81615562342,
      "time": 153,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7661608190"
    },
    {
      "job": 81615562344,
      "time": 155,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7661607850"
    },
    {
      "job": 81614826500,
      "time": 238,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7661548765"
    },
    {
      "job": 81615562260,
      "time": 144,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/27605018311",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/RPostgres",
  "_commit": {
    "id": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
    "author": "Kirill Müller <kirill@cynkra.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.4.10\n",
    "time": 1771237809
  },
  "_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": "cran",
  "_selfowned": false,
  "_usedby": 41,
  "_updates": [
    {
      "week": "2026-06",
      "n": 1
    },
    {
      "week": "2026-08",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.4.9",
      "date": "2026-02-06"
    },
    {
      "name": "1.4.10",
      "date": "2026-02-16"
    }
  ],
  "_stars": 1,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 23,
      "uuid": 1741643
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 609,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 54959,
    "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": 3536,
  "_topics": [
    "postgresql",
    "cpp"
  ],
  "_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": false,
  "_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/cran/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": "2021-01-07 08:00:09",
      "modified": "2026-02-06 06:40:48",
      "commits": 7
    }
  ],
  "_score": 9.378456189749814,
  "_indexed": false,
  "_nocasepkg": "rpostgres",
  "_universes": [
    "cran"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RPostgres",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10",
      "date": "2026-06-16T08:41:32.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
      "fileid": "afb182780b00f3a728dc6fb4a8c02b15a2a0b4b7645842969e746fb939f3f573",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27605018311"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10",
      "date": "2026-06-16T08:41:39.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
      "fileid": "22955714accface9752f7265e9abad8e7105090d23ff0364d4d4bbc86ce796a0",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27605018311"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10",
      "date": "2026-06-16T08:41:32.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
      "fileid": "3323d9e696824bb2651e82e2483d43ccd959f9186f56dd42158d09f6f75928fc",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27605018311"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10",
      "date": "2026-06-16T08:41:28.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "32510b58b63abc22ed701c2e24edfddbb8a3e88f",
      "fileid": "fa2d8eeefbf027a3ed9ceb334c252ce1d24b94e37de029b134543420f3c0ed75",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/27605018311"
    }
  ]
}