Download | Release Notes | Changelog |
Release date: 19 Oct 2020
MariaDB Connector/Node.js 2.5.0 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
- permit setting socket keep alive (option keepAliveDelay)
- Array parameter escaping differ from mysql/mysql2
- Support ES2020 BigInt object (option supportBigInt)
New Options
is a breaking change. Queries that have a IN parameter with array parameters format change. previous format did not accept parenthesis :
now, format is
same than mysql/mysql2 drivers.
previous behaviour can be reverted setting option arrayParenthesis to true.
- batch rewrite error when packet reach maxAllowedPacket
- Using callback API, batch, avoid return error if connection not established
- TypeScript type ssl wrong definitions
For a complete list of changes made in this release, with links to detailed information on each push, see the .
CONJS-76 - Support MySQL sha256_password authentication
allowPublicKeyRetrieval
Indicate that if rsaPublicKey or cachingRsaPublicKey public key are not provided, if client can ask server to send public key.
boolean
false
supportBigInt
Whether resultset should return javascript ES2020 for data type. This ensures having expected value even for value > 2^53 (see range).
boolean
false
keepAliveDelay
permit to enable socket keep alive, setting delay. 0 means not enabled. Keep in mind that this don't reset server (use pool option idleTimeout for that). in ms
int
arrayParenthesis
Indicate if array are included in parenthesis. This option permit compatibility with version < 2.5
boolean
false
rsaPublicKey
Indicate path/content to MySQL server RSA public key. use requires Node.js v11.6+
string
cachingRsaPublicKey
Indicate path/content to MySQL server caching RSA public key. use requires Node.js v11.6+
string
conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN ?', [1, ['b', 'c']]);conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN (?)', [1, ['b', 'c']]);This page is: Copyright © 2025 MariaDB. All rights reserved.