Package: RPostgres 1.4.7.9012

Kirill Müller

RPostgres: C++ Interface to PostgreSQL

Fully DBI-compliant C++-backed interface to PostgreSQL <https://www.postgresql.org/>, an open-source relational database.

Authors:Hadley Wickham [aut], Jeroen Ooms [aut], Kirill Müller [aut, cre], RStudio [cph], R Consortium [fnd], Tomoaki Nishiyama [ctb]

RPostgres_1.4.7.9012.tar.gz
RPostgres_1.4.7.9012.zip(r-4.5)RPostgres_1.4.7.9012.zip(r-4.4)RPostgres_1.4.7.9012.zip(r-4.3)
RPostgres_1.4.7.9012.tgz(r-4.4-x86_64)RPostgres_1.4.7.9012.tgz(r-4.4-arm64)RPostgres_1.4.7.9012.tgz(r-4.3-x86_64)RPostgres_1.4.7.9012.tgz(r-4.3-arm64)
RPostgres_1.4.7.9012.tar.gz(r-4.5-noble)RPostgres_1.4.7.9012.tar.gz(r-4.4-noble)
RPostgres.pdf |RPostgres.html✨
RPostgres/json (API)
NEWS

# Install 'RPostgres' in R:

install.packages('RPostgres', repos = c('https://ar-puuk.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/r-dbi/rpostgres/issues

Uses libs:

postgresql– PostgreSQL C client library
c++– GNU Standard C++ Library v3

On CRAN:

database postgres postgresql

14.60 score 334 stars 27 packages 1.4k scripts 32k downloads 1 mentions 48 exports 17 dependencies

Last updated 2 days agofrom:b62bc601a2. Checks:OK: 9. Indexed: no.

Target	Result	Date
Doc / Vignettes	OK	Oct 28 2024
R-4.5-win-x86_64	OK	Oct 28 2024
R-4.5-linux-x86_64	OK	Oct 28 2024
R-4.4-win-x86_64	OK	Oct 28 2024
R-4.4-mac-x86_64	OK	Oct 28 2024
R-4.4-mac-aarch64	OK	Oct 28 2024
R-4.3-win-x86_64	OK	Oct 28 2024
R-4.3-mac-x86_64	OK	Oct 28 2024
R-4.3-mac-aarch64	OK	Oct 28 2024

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 postgresHasDefault postgresIsTransacting postgresWaitForNotify Redshift show sqlData

Dependencies:bit bit64 blob cli cpp11 DBI generics glue hms lifecycle lubridate pkgconfig plogr rlang timechange vctrs withr

Implementing a Work Queue using RPostgres

Jamie Lentin

Rendered fromwork-queue.Rmdusingknitr::rmarkdownon Oct 28 2024.

Last update: 2023-10-27
Started: 2020-10-18

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
RPostgres: C++ Interface to PostgreSQL	RPostgres-package RPostgres
Postgres driver	dbConnect,PqDriver-method dbConnect_PqDriver dbDisconnect,PqConnection-method dbDisconnect_PqConnection Postgres
Execute a SQL statement on a database connection	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
Convenience functions for reading/writing DBMS tables	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
Transaction management.	dbBegin,PqConnection-method dbBegin_PqConnection dbCommit,PqConnection-method dbCommit_PqConnection dbRollback,PqConnection-method dbRollback_PqConnection postgres-transactions
Check if default database is available.	postgresDefault postgresHasDefault
Return whether a transaction is ongoing	postgresIsTransacting
Wait for and return any notifications that return within timeout	postgresWaitForNotify
Quote postgres strings, identifiers, and literals	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
Redshift driver/connection	dbConnect,RedshiftDriver-method dbConnect_RedshiftDriver Redshift RedshiftConnection-class RedshiftDriver-class