DBI
DBI copied to clipboard
r-dbi
A database interface (DBI) definition for communication between R and RDBMSs
Hi, Here a weird problem with the function, for some reason, is writing in the scheme... ``` dbWriteTable(con, Id(schema="other", table="tmp"), value=t) [1] TRUE ``` Now checking postgres: ``` \dt .......
I am trying to use DBI to connect to a postgres database. When I use dbConnect() it fails with no error message and outputs some symbols. Not sure what is...
See the reprex below. `dbQuoteIdentifier()` is called twice with the same table data. All that changes is the order in which the `Id()` arguments were given. Conceptually, this should be...
Not sure what can be done about this, but if an SQL expression with parameters expects a float and `Inf` (or `-Inf`) is passed, PostgreSQL errs and complains like so:...
I am constantly getting the error `Lost connection to MySQL server during query [2013]`, which seems to be related to the connection timeout. This happens when I create a `con`...
From @angelicambg: It would be nice to have in the tutorials: - Use of time zones - Could be interesting to see how to check types of variables to avoid...
How to get large data into and out of a database? It's difficult to standardize fast import (https://github.com/r-dbi/DBI/issues/62), but we can document how to do it with `dbExecute()`. The document...
The current https://cran.r-project.org/doc/manuals/r-devel/R-data.html chapter 4.3 *R interface packages* mentions `DBI` but the information is well out-of-date: > *All except RODBC are tied to one DBMS, but there has been a...
