dbBind()also works for
"Date"values that are stored as integers (#187).
dbConnect(), supported values are
"character". Large integers are returned as values of that type (r-dbi/DBItest#133).
dbGetException()is no longer reexported from DBI.
Infare converted to
NULLwhen writing to the database (#77).
"integer64"are now supported for
dbQuoteIdentifier()are preserved in the output (r-lib/DBI#173).
timegm()with private implementation (#78).
timegmsymbol if the macro
overwrite = TRUE.
SHOW PLUGINS) return data (#70, @nbenn).
dbWriteTable()if a table by the same name exists. If a temporary table of the same name exists, the error will be raised by the database itself, because this condition cannot be checked beforehand.
Initial release, compliant to the DBI specification.
dbSendStatement(), the function
mariadbExecQuery()has been removed (#28).
bit64package. Unfortunately, this also means that numeric literals (as in
SELECT 1) are returned as 64-bit integers (#12).
row.names = FALSE.
ssl.cipher(#131, #148, @adamchainz).
RMariaDB fully supports DATE and DATETIME columns. On output, DATE columns will be converted to vectors of
Dates and DATETIME will be converted to
POSIXct. To faciliate correct computation of time zone, RMariaDB always sets the session timezone to UTC.
RMariaDB has been rewritten (essentially from scratch) in C++ with Rcpp. This has considerably reduced the amount of code, and allow us to take advantage of the more sophisticated memory management tools available in Rcpp. This rewrite should yield some minor performance improvements, but most importantly protect against memory leaks and crashes. It also provides a better base for future development.
Support for prepared queries: create prepared query with
dbSendQuery() and bind values with
dbGetQuery() also support inline parameterised queries, like
dbGetQuery(mariadbDefault(), "SELECT * FROM mtcars WHERE cyl = :cyl", params = list(cyl = 4)). This has no performance benefits but protects you from SQL injection attacks.
dbGetInfo() has been removed. Please use the individual metadata functions.
isIdCurrent() has been deprecated. Use
dbNextResults() have been removed. These were always flagged as experimental, and now the experiment is over.
dbEscapeStrings() has been deprecated. Please use
dbObjectId compatibility shim removed
Add SSL support on Windows.
Always set connection character set to utf-8
Backport build system improvements from stable branch
Reenable Travis-CI, switch to R Travis, collect coverage