Connector/Node.js 3.3.0 Release Notes

Download | Release Notes | Changelog |

Release date: 21 Mar 2024

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

Notable changes

Zero-Configuration SSL

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

• Have server certificates generated with , 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 (), 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 , client validating ssl certificates using client password.

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 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)

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

• Improve query encoding and decoding performance

Issues Fixed

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

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

• Possible buffer overwrite when sending query bigger than 16M

• error when using mysql_clear_test password authentication plugin