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://r-dbi.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

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

Uses libs:
  • postgresql– PostgreSQL C client library
  • c++– GNU Standard C++ Library v3

On CRAN:

databasepostgrespostgresql

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

Last updated 11 days agofrom:b62bc601a2. Checks:OK: 9. Indexed: yes.

TargetResultDate
Doc / VignettesOKOct 28 2024
R-4.5-win-x86_64OKOct 28 2024
R-4.5-linux-x86_64OKOct 28 2024
R-4.4-win-x86_64OKOct 28 2024
R-4.4-mac-x86_64OKOct 28 2024
R-4.4-mac-aarch64OKOct 28 2024
R-4.3-win-x86_64OKOct 28 2024
R-4.3-mac-x86_64OKOct 28 2024
R-4.3-mac-aarch64OKOct 28 2024

Exports:dbAppendTabledbBegindbBinddbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbRemoveTabledbRollbackdbSendQuerydbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTableIdPostgrespostgresDefaultpostgresHasDefaultpostgresIsTransactingpostgresWaitForNotifyRedshiftshowsqlData

Dependencies:bitbit64blobclicpp11DBIgenericsgluehmslifecyclelubridatepkgconfigplogrrlangtimechangevctrswithr

Implementing a Work Queue using RPostgres

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

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

Readme and manuals

Help Manual

Help pageTopics
RPostgres: C++ Interface to PostgreSQLRPostgres-package RPostgres
Postgres driverdbConnect,PqDriver-method dbConnect_PqDriver dbDisconnect,PqConnection-method dbDisconnect_PqConnection Postgres
Execute a SQL statement on a database connectiondbBind,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 tablesdbAppendTable,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 ongoingpostgresIsTransacting
Wait for and return any notifications that return within timeoutpostgresWaitForNotify
Quote postgres strings, identifiers, and literalsdbQuoteIdentifier,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/connectiondbConnect,RedshiftDriver-method dbConnect_RedshiftDriver Redshift RedshiftConnection-class RedshiftDriver-class