DBI

DBI copied to clipboard

Multi-statement support

3

I created an [issue](https://github.com/r-dbi/RPostgres/issues/152) (quite a while back!) specifically asking about this with RPostgres, where libpq has functionality to handle multi-statement SQL being sent to the DB server. The recommendation...

mmuurr

dbQuoteLiteral() for numerics has insufficient precision in some cases

2

``` r library(DBI) data [1] -4.336809e-19 sql_exp [1] "2.73927602739726037e-03" as.numeric(sql_exp) - data #> [1] 0 ``` Created on 2022-12-09 with [reprex v2.0.2](https://reprex.tidyverse.org) We could use `sprintf("%.17e")` as in the reprex...

krlmlr

FR: `dbWriteTable()` should compare input and output column names.

4

I just learned that (some) databases seem to (silently?) change invalid column names (see https://github.com/tidyverse/dbplyr/issues/1016). This causes issues with the new optimisation in `dbplyr::copy_to()` where column names do not match....

mgirlich

Clarification on `dbConnect()` documentation

1

I found arguments like `Authentication` through SO, but I'm wondering how to find these organically through documentation. Under the `dbConnect()` documentation it writes: `... authentication arguments needed by the DBMS...

asadow

Should `DBI::dbWriteTable` support overloading `value` argument to support a `SQL` query

6

This is one of my typical workflow: `con (say odbc) --> tbl --> some_dplyr_ops --> save (as a table)`. Note that data does NOT come into the R's memory. But...

talegari