Release Notes for MariaDB Connector/Node.js 3.3.0

Zero-Configuration SSL

In order to have SSL connections, there were 3 solutions: (CONJS-264)

• 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 does not have configured SSL certificates. The connector doesn't need to know the server certificate any more if the password is not empty. This is part of Mission Impossible: Zero-Configuration SSL, client validating SSL certificates using client password.

pipeline PREPARE and EXECUTE

Previous use of connection.execute was: execute the PREPARE command first, read the PREPARE response, execute the EXECUTE command, and finally read the EXECUTE response. (CONJS-284)

The new implementation, when using using MariaDB server 10.2+ and with the pipelining option enabled (the default value) will: execute PREPARE, execute EXECUTE, then read the PREPARE response, and read the EXECUTE response. This permits avoiding much of the network latency.

Benchmarking results using a local database: (a remote database would have even better results)

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