MariaDB Connector/Node.js 2.1.0 Release Notes

The most recent Stable (GA) release of MariaDB Connector/Node.js is:MariaDB Connector/Node.js 3.4.2

DownloadRelease NotesChangelogConnector/Node.js Overview

Release date: 12 Jul 2019

MariaDB Connector/Node.js 2.1.0 is a Stable (GA) release.

For an overview of MariaDB Connector/Node.js see theAbout MariaDB Connector/Node.js page

Notable Changes

• [CONJS-19] implement Ed25519 plugin

• [CONJS-57] Multiple alternative authentication methods for the same user (MariaDB 10.4)

• [CONJS-61] Permit handling expired password

• [CONJS-85] Implement pool events according to mysql/mysql2 API

• [CONJS-87] Array parameter automatic conversion

• [CONJS-89] Performance improvement on decoding string

• [CONJS-88] Charset collation option separation

• [CONJS-74] Types definition must be string, not byte when using option typeCast

• [CONJS-75] Missing import dependencies for typeScript

• [CONJS-79] Read errors while processing LOCAL INFILE can cause process crash

• [CONJS-83] Add poolCluster 'remove' event

• [CONJS-84] option restoreNodeTimeout is not respected when removeNodeErrorCount is set

• [CONJS-73] Setting timezone to current IANA might provoke server automatic retrieval

New Options

Option	Description	Type	Default
Option	Description	Type	Default
collation	(used in replacement of charset) Permit to defined collation used for connection. This will defined the charset encoding used for exchanges with database and defines the order used when comparing strings. It's mainly used for micro-optimizations	string	UTF8MB4_UNICODE_CI
permitConnectionWhenExpired	Permit a user with expired password to connect. Only possible operation in this case will be to change password ('SET PASSWORD=PASSWORD('XXX')')	boolean	false

The option charset now corresponds to charset, still permitting collation for compatibility, but then a warning is thrown to console.

Pool events

Pools now emits events.

event	Description
event	Description
acquire	This event emits a connection is acquired from pool.
connection	This event is emitted when a new connection is added to the pool. Has a connection object parameter
enqueue	This event is emitted when a command cannot be satisfied immediately by the pool and is queued.
release	This event is emitted when a connection is released back into the pool. Has a connection object parameter

Example:

pool.on('connection', (conn) => console.log(`connection ${conn.threadId} has been created in pool`);
Pool

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on theDistributions which Include MariaDB page.