MariaDB Connector/Node.js 3.3.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: 21 Mar 2024

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

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

Notable changes

CONJS-264 Zero-Configuration SSL

In order to have SSL connections, there was 3 solutions:

• Have server certificates generated with trusted node.js Certificate Authorities (CA), configuration was then like ssl: true.

• Configure connector with server certificate like:ssl: { ca: [ fs.readFileSync('server-cert.pem') ] }

• disable certificate ssl verification (not secured!) like:ssl: { rejectUnauthorized: true }

Since MariaDB 11.4.1 (MDEV-31855), enabling SSL is super easy, with simple configuration like:ssl: true, even if server has not configure ssl certificates. The connector doesn't need to know server certificate anymore, if password is not empty. This is part of mission impossible zero configuration, client validating ssl certificates using client password.

CONJS-284 pipeline PREPARE and EXECUTE

Previous use of connection.execute was executing PREPARE command first, read PREPARE response, then execute EXECUTE command and finally read EXECUTE response.

New implementation, when using using MariaDB server 10.2+ and with pipelining option enable (default value) will execute PREPARE, execute EXECUTE, then only read PREPARE response and read EXECUTE response. This permit to avoid much of the network latency.

Benchmarking results using local database: (distant database would have even better result)

bench

This improvement is for first execution of a specific query, since PREPARE is cached by default, second execution would only execute EXECUTE command

Other changes

• CONJS-279 Improve query encoding and decoding performance

Issues Fixed

• CONJS-281 cannot connect to 11.3+ server with character-set-collations = utf8mb4=uca1400_ai_ci

• CONJS-277 using connection.importFile when connection is not connected to database result in error

• CONJS-278 Possible buffer overwrite when sending query bigger than 16M

• CONJS-282 error when using mysql_clear_test password authentication plugin

• CONJS-283 wrong decoding of binary unsigned MEDIUMINT

• CONJS-285 DECIMAL field wrong decoding with deprecated option 'supportBigNumbers' set