Skip to contents

Changelog

Source: NEWS.md

Version 0.11.2

CRAN release: 2026-03-02

  • MacOS: update to libmariadbclient 3.4.8

Version 0.11.0

CRAN release: 2025-02-08

  • Windows: use libmariadbclient from Rtools if found

Version 0.10.28

CRAN release: 2024-08-22

  • Fix anchor link note for CRAN

Version 0.10.27

CRAN release: 2023-12-04

  • Fix some printf warnings for CRAN

Version 0.10.26

CRAN release: 2023-09-26

  • Windows: update libs with arm support
  • Drop CXX11 in Makevars.win

Version 0.10.25

CRAN release: 2022-12-06

  • Replace sprintf with snprintf for CRAN

Version 0.10.24

CRAN release: 2022-10-18

  • Fix strict-prototypes warnings

Version 0.10.23

CRAN release: 2021-12-14

  • Windows: update to mariadb-connector-c 3.2.5. This new version still uses OpenSSL for R <= 4.1 but R 4.2 (ucrt) it switches to the new native Windows schannel TLS.

Version 0.10.22

CRAN release: 2021-06-22

  • Windows: add support for UCRT builds

Version 0.10.21

CRAN release: 2020-12-15

  • Windows: update to libmariadbclient 3.1.11

Version 0.10.20

CRAN release: 2020-03-14

  • Fixed improper escaping with dbQuoteString and dbQuoteLiteral, which can lead to SQL injection (Found by Nikolay Simakov and patched by Andrew Kane, CVE-2020-10380).

Version 0.10.19

CRAN release: 2020-02-03

  • Fix new warning for CRAN
  • Small tweaks for configure script

Version 0.10.18

CRAN release: 2019-12-14

  • MacOS: CRAN binaries have been updated to mariadb-connector-c to 3.1.6

Version 0.10.17

CRAN release: 2019-03-04

  • Fix rcheck problems requested by CRAN

Version 0.10.16

CRAN release: 2019-01-04

  • Windows: Update mariadb-connector-c to v2.3.7 + OpenSSL 1.1.1
  • MacOS: Update mariadb-connector-c to 3.0.8
  • Fix for MySQL 8 (issue #223)

Version 0.10.15

CRAN release: 2018-05-13

  • Windows: Update mariadbclient to v 2.3.5

Version 0.10.14

CRAN release: 2018-02-26

  • Windows: Update mariadbclient to v 2.3.4
  • Fix headers and linker flags for mariadb-connector-c 3.0 compatibility
  • Remove some redundant include headers

Version 0.10.13

CRAN release: 2017-08-14

  • Add cleanup script (requested by CRAN)
  • Fix PROTECT() bugs from rchk

Version 0.10.12

CRAN release: 2017-07-06

  • Windows: update libmariadbclient to v2.3.3 (fixes a timeout bug)

Version 0.10.11

CRAN release: 2017-03-29

  • Fix for OSX Mavericks

Version 0.10.10

CRAN release: 2017-03-21

  • Window: update libmariadbclient to v2.3.2

  • OSX: extract autobrew script

Version 0.10.9

CRAN release: 2016-05-08

  • OSX binary packages for OSX now use mariadb-connector-c instead of mysql-connector-c

  • CMD check fix for DBI 0.4

Version 0.10.8

CRAN release: 2016-01-29

  • Replace #include S.h with R.h as required by BDR

Version 0.10.6

CRAN release: 2015-09-05

  • Fix configure script for OSX

Version 0.10.5

CRAN release: 2015-08-25

  • Refactor configure script

  • Fix for setInternet2 in R-devel on Windows

Version 0.10.4

CRAN release: 2015-07-28

  • Fix dbWriteTable bug with MySQL-based Infobright database

  • Use mariadb_config if available

  • Properly import used utils functions

Version 0.10.3

CRAN release: 2015-04-21

  • Fix the RPostgreSQL conflict

  • Remove the workaround for the bug in TSMySQL

  • Update URL to MariaDB client in DESCRIPTION

Version 0.10.2

CRAN release: 2015-02-24

  • Backport fixes from Rcpp branch.

  • Configure script now uses mysql_config if available.

  • MariaDB windows libraries have been updated to 2.1.0

  • Add SSL support to MariaDB windows libraries.

Version 0.10.1

CRAN release: 2015-01-15

  • Fix configure script for OSX 10.6 Snow Leopard

  • Issue in dbWriteTable() with temporary files on Windows fixed.

Version 0.10

CRAN release: 2015-01-05

  • New maintainer: Jeroen Ooms

  • Internal changes to support static linking on Windows; this means that windows a binary is now available on CRAN.

  • The following internal functions are no longer exported: please use the corresponding DBI generic instead:

    mysqlInitDriver, mysqlCloseDriver, mysqlDescribeDriver, mysqlDriverInfo, mysqlNewConnection, mysqlCloneConnection, mysqlDescribeConnection, mysqlConnectionInfo, mysqlCloseConnection, mysqlExecStatement, mysqlQuickSQL, mysqlDBApply, mysqlFetch, mysqlResultInfo, mysqlDescribeResult, mysqlDescribeFields, mysqlCloseResult, mysqlImportFile, mysqlReadTable, mysqlWriteTable, mysqlEscapeStrings, mysqlDataType, safe.write.

  • RMySQL gains transaction support with dbBegin(), dbCommit(), and dbRollback(), but note that MySQL does not allow data definition language statements to be rolled back.

  • The MySQLObject base class has been removed - there is no real shared behaviour for MySQLDriver, MySQLConnection and MySQLResult so this simplifies the code

  • Implemented methods for dbIsValid(); please use these instead of isIdCurrent().

  • Implement dbFetch() method; please use this in preference to fetch(). dbFetch() now returns a 0-row data frame (instead of an 0-col data frame) if there are no results.

  • Methods no longer automatically close open result sets. This was implemented inconsistently in a handful of places.

  • dbBuildTableDefinition() has been renamed to mysqlBuildTableDefinition().

  • dbWriteTable() has been rewritten:

    • It quotes field names using dbQuoteIdentifier(), rather than use a flawed black-list based approach with name munging.

    • It now throws errors on failure, rather than returning FALSE.

    • It will automatically add row names only if they are character, not integer.

    • When loading a file from disk, dbWriteTable() will no longer attempt to guess the correct values for row.names and header - instead supply them explicitly if the defaults are incorrect.

    • When given a zero-row data frame it will just creates the table definition.

  • Assorted fixes accumulated since last release 3 years ago.

  • MySQL() no longer has force.reload argument - it’s not obvious that this ever worked.