NEWS (original) (raw)

Initial release, compliant to the DBI specification.

• 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 withdbSendQuery() and bind values with dbBind().dbSendQuery() and dbGetQuery() also support inline parameterised queries, likedbGetQuery(mariadbDefault(), "SELECT * FROM mtcars WHERE cyl = :cyl", params = list(cyl = 4)). This has no performance benefits but protects you from SQL injection attacks.
• dbListFields() has been removed. Please usedbColumnInfo() instead.
• dbGetInfo() has been removed. Please use the individual metadata functions.
• Information formerly contain in summary() methods has now been integrated into show() methods.
• make.db.names() has been deprecated. UsedbQuoteIdentifier() instead.
• isIdCurrent() has been deprecated. UsedbIsValid() instead.
• dbApply(), dbMoreResults() anddbNextResults() have been removed. These were always flagged as experimental, and now the experiment is over.
• dbEscapeStrings() has been deprecated. Please usedbQuoteStrings() instead.
• dbObjectId compatibility shim removed
• Add SSL support on Windows.
• Fix repetition of strings in subsequent rows (@peternowee, #125).
• Always set connection character set to utf-8
• Backport build system improvements from stable branch
• Reenable Travis-CI, switch to R Travis, collect coverage