Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 17 Feb 2022

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

Notable Changes

• [CONJS-181] Local infile file validation doesn't take in account escaped value

• [CONJS-183] change default connection timeout value 1 second to permit pools to send correct error

• correct character_set_client unexpect error parsing OK_Packet

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 20 Oct 2021

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

Notable Changes

• [CONJS-170] Pool.query(undefined) never release connection

• [CONJS-173] not permitting providing null as a value without an array

• [CONJS-175] Missing leakDetectionTimeout option in Typescript description

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 14 Jun 2021

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

Notable Changes

• [CONJS-163] Authentication plugin failing doesn't always return error

• [CONJS-164] Add API that list options default value

• [CONJS-161] escaping correction

• update iconv-lite dependency to 0.6.3

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 24 Feb 2021

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

Notable Changes

• [CONJS-157] Batch error when setting maxAllowedPacket less than an insert parameter value

• [CONJS-158] use BigInt constructor in place of literal to ensure maximum compatibility

• [CONJS-160] Wrong definition for typescript PoolConnection.release

• [CONJS-159] test 10.6 server latest build

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 4 Dec 2020

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

Notable Changes

• [CONJS-151] bulk batch error (parameter truncation) #137

• [CONJS-152] correction when enabling the permitLocalInfile option and some initial commands

• [CONJS-154] Timezone support correction and clarification

• [CONJS-155] correction to support for node.js 10.13 to 10.19

• [CONJS-156] Ensure setting capability PLUGIN_AUTH only if server has it

• documentation improvement

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 26 Oct 2020

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

Notable Changes

• CONJS-149 - Support of the new node.js version v15

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 19 Oct 2020

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

Notable Changes

• CONJS-148 - permit setting socket keep alive (option keepAliveDelay)

• CONJS-143 - Array parameter escaping differ from mysql/mysql2

• CONJS-133 - Support ES2020 BigInt object (option supportBigInt)

• CONJS-77 - Support MySQL caching_sha256_password authentication

• CONJS-76 - Support MySQL sha256_password authentication

New Options

CONJS-143 is a breaking change. Queries that have a IN parameter with array parameters format change. previous format did not accept parenthesis :

conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN ?', [1, ['b', 'c']]);

now, format is

conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN (?)', [1, ['b', 'c']]);

same than mysql/mysql2 drivers. previous behaviour can be reverted setting option arrayParenthesis to true.

Bugs Fixed

• CONJS-145 - batch rewrite error when packet reach maxAllowedPacket

• CONJS-146 - Using callback API, batch, avoid return error if connection not established

• CONJS-144 - TypeScript type ssl wrong definitions

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 23 Jul 2020

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

• CONJS-142 - Number parsing loss of precision

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 2 Jul 2020

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

• CONJS-138 - pool.getConnection() might not timeout even with acquireTimeout set

• CONJS-139 - createConnection(string)` does not support URL-encoded credentials

• CONJS-140 - Support passing null values in array when doing queries. thanks to @koendeschacht

• CONJS-141 - set default value of option restoreNodeTimeout to 1000 to avoid using blacklisted pool in cluster

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 26 May 2020

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

This version removes compatibility with Node.js 6, needing 10+ version!

• CONJS-86 - Support extension type format

• CONJS-128 - Error when using multipleStatements with metaAsArray

• CONJS-129 - Support 10.5 pluggable type

• CONJS-131 - checkDuplicate option is indicated in error when having dupplicate

• CONJS-132 - performance improvement

• CONJS-136 - typescript SqlError interface

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 20 Mar 2020

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

Corrective release of 2.3.0, changing new connection option timeout to queryTimeout to avoid any confusion.

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 20 Mar 2020

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

2.3.0 has been deprecated to 2.3.1: changing new connection option timeout to queryTimeout to avoid any confusion.

• CONJS-127 - Resultset with same identifier skip data. Now an error will be thrown.

• CONJS-126 - permit setting session query timeout per option

• CONJS-124 - Force connection.escapeId to emit backtick #101

• CONJS-123 - exporting SqlError class to permit instanceOf checks #100

• CONJS-122 - fix undefined localTz with timezone: 'Z' issue #92

• CONJS-121 - Connection.escapeId must always quote value to permit reserved words

misc:

• appveyor testing server version upgrade

• better debug logging trace format

• correct ssl test

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 4 Feb 2019

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

New option force Server version detection CONJS-119

Azure is using a proxy that will return a MySQL handshake not reflecting real server.

A new option forceVersionCheck is added to permit issuing a new SELECT @@Version command on connection creation,

to retrieve the correct server version. Connector will then act according to that server version.

Query timeout implementation CONJS-20

This option is only permitted for MariaDB server >= 10.1.2, and permits to set a timeout to query operation.

Driver internally use SET STATEMENT max_statement_time=<timeout> FOR <command> permitting to cancel operation when timeout is reached,

Implementation of max_statement_time is engine dependent, so there might be some differences: For example, with Galera engine, a commits will ensure replication to other nodes to be done, possibly then exceeded timeout, to ensure proper server state.

example:

//query that takes more than 20s
connection
  .query({sql: 'information_schema.tables, information_schema.tables as t2', timeout: 100 })
  .then(...)
  .catch(err => {
          // SQLError: (conn=2987, no: 1969, SQLState: 70100) Query execution was interrupted (max_statement_time exceeded)
          // sql: select * from information_schema.columns as c1, information_schema.tables, information_schema.tables as t2 - parameters:[]
          // at Object.module.exports.createError (C:\projets\mariadb-connector-nodejs.git\lib\misc\errors.js:55:10)
          // at PacketNodeEncoded.readError (C:\projets\mariadb-connector-nodejs.git\lib\io\packet.js:510:19)
          // at Query.readResponsePacket (C:\projets\mariadb-connector-nodejs.git\lib\cmd\resultset.js:46:28)
          // at PacketInputStream.receivePacketBasic (C:\projets\mariadb-connector-nodejs.git\lib\io\packet-input-stream.js:104:9)
          // at PacketInputStream.onData (C:\projets\mariadb-connector-nodejs.git\lib\io\packet-input-stream.js:160:20)
          // at Socket.emit (events.js:210:5)
          // at addChunk (_stream_readable.js:309:12)
          // at readableAddChunk (_stream_readable.js:290:11)
          // at Socket.Readable.push (_stream_readable.js:224:10)
          // at TCP.onStreamRead (internal/stream_base_commons.js:182:23) {
          //     fatal: true,
          //         errno: 1969,
          //         sqlState: '70100',
          //         code: 'ER_STATEMENT_TIMEOUT'
          // }
  });

Fast-authentication improvement CONJS-110

• add mysql_native_password to fast-authentication path

• plugin 'mysql_native_password' is used by default if default server plugin is unknown

• unexpected packet type during handshake result will throw a good error.

Pool leak detection CONJS-117

A new option leakDetection permits to indicate a timeout to log connection borrowed from pool.

When a connection is borrowed from pool and this timeout is reached, a message will be logged to console indicating a possible connection leak.

Another message will tell if the possible logged leak has been released.

A value of 0 (default) meaning Leak detection is disable

Additionally, some error messages have improved:

• Connection timeout now indicate that this correspond to socket failing to establish

• differentiate timeout error when closing pool to standard connection retrieving timeout

misc:

• CONJS-120 Permit values in SQL object to permits compatibility with mysql/mysql2

• CONJS-118 missing import for Error when asking for connection when pool is closed. Thanks to @WayneMDB

• correcting typescript import of @types/node to version >8 thanks to @SimonSchick

• dependencies update

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 8 Jan 2019

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

Notable Changes

• CONJS-115 Batch improvement

  • supporting array of parameters if only one parameter per query, not only array of array

  • supporting empty array for query without parameters

• correction on licence tag: LGPL-2.1-or-later (was tag LGPL-2.1+ that is deprecated)

• dependencies update

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 2 Dec 2019

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

Notable Changes

• CONJS-112 use pool reset only for corrected COM_RESET_CONNECTION

• CONJS-111 missing pool event definition

• dependencies update

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 19 Nov 2019

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

Notable Changes

• CONJS-109 Missing mysql only collation definition

• CONJS-108 typescript escape/escapeId definition

• CONJS-107 Change user callback function not called when no option is set and changing collation only if collation option is correct

• CONJS-106 properly escape boolean parameter false

• CONJS-105 Typecast provided date function erroneous parsing

• CONJS-104 Pam authentication must permit to provide multiple passwords

PAM authentication with multiple steps can be achieved using password as array:

const mariadb = require('mariadb');

  mariadb.createConnection({host: 'mydb.com', user: 'myUser', password: ['myPwd', 'myAuthToken']})
    .then(conn => {
       ...
    })
    .catch(err => {
      ...
    });

Misc

• better cluster error when pool is full

• adding test coverage

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 17 Oct 2019

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

Notable Changes

Implemented enhancements:

• [CONJS-101] Escape functions API

• [CONJS-100] Improve performance using reusable Object type for column definition result

• [CONJS-102] Expose library version to API

Use milestone to specify in which version bug was fixed #22 Fixed bugs:

• [CONJS-96] TypeScript definition typecast correction

• [CONJS-95] Pool idle maintainer error

• [CONJS-98] Missing collation option in typescript definition

• [CONJS-99] Improve documentation for best practice concerning credential

• [CONJS-97] Remove coverage comment on GitHub pull request

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 06 Sept 2019

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

Notable Changes

• node.js v12 CI testing

• cluster ordered selector bug fix on failover (thanks to @kkx)

• bump dependencies

• documentation update with node.js v12 minimum TLSv1.2 default support

• connection.reset() error message improvement (and documentation)

• small performance improvement when debug not enable

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 12 Jul 2019

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

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

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.

Example:

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

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 13 May 2019

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

Notable Changes

• [CONJS-69] permit set numeric parameter bigger than javascript 2^53-1 limitation

• [CONJS-68] error when reading datetime data and timezone option is set

• [CONJS-58] parse Query when receiving LOAD LOCAL INFILE, to prevent man in the middle attack

• [CONJS-62] support named timezones and daylight savings time

• [CONJS-63] add type definitions for typescript

• [CONJS-64] handle Error packet during resultset to permit query timeout with SET STATEMENT max_statement_time= FOR

• [CONJS-66] SET datatype handling (returning array)

• [CONJS-67] Changing user does not takes in account connector internal state (transaction status)

Pool improvement

New Options

This permits to set a minimum pool size, meaning that after a period of inactivity, the pool will decrease the inner number of connection to a minimum number of connections (defined with minimumIdle). By default, connections not used after idleTimeout (default to 30 minutes) will be discarded, avoiding reaching server @@wait_timeout.

Pool handle connection creation automatically, with now some delayed after failing to establish a connection, to avoid using CPU unnecessary. Authentication error in pool have now a better handling.

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 10 May 2019

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

This version is a has been corrected with 2.0.5 version, since TypeScript definition wasn't published on npm.

Please use this new 2.0.5 version.

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 31 Jan 2019

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

Notable Changes

• [CONJS-56] TypeError: Cannot read property 'totalConnections' of undefined

• [CONJS-59] pool now throw ER_ACCESS_DENIED_ERROR in place of a basic timeout error

• [CONJS-60] handling pipe error when streaming, avoiding hang in case of pipe error.

• [CONJS-55] Connector throw an error when using incompatible options

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 13 Dec 2018

MariaDB Connector/Node.js 2.0.2 is a Release Candidate (RC) release.

Notable Updates

New options:

correction

• using option connectAttributes value _server_host is correctly filled on Performance Schema.

• batch improvement

  • error is now thrown when no values

  • BULK better handling when socket fail during command

  • Object with toSqlString function parameter support

  • null value correction when using BULK

  • timezone correction when not using "local" default values

  • now support very long parameter (> 16M)

  • rewrite correctly parse double slash

  • timezone option parsing correction (correctly handle negative values)

• test coverage improvement

• minor performance improvement

• pool end() now correctly wait for all connections ending

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 15 Nov 2018

MariaDB Connector/Node.js 2.0.1 is a Beta release.

Notable Updates

• Blog post about the release

• CONJS-52 (Bug) Commit not executed when in transaction and autocommit is enabled

• CONJS-50 (Bug) race condition when using authentication plugins

• CONJS-21 add bulk insert method

• CONJS-38 Add connection reset

• CONJS-41 Handle multiple server pools with failover capabilities

• CONJS-49 test connector with maxscale

• CONJS-51 Permit use of connection string to provide options

• CONJS-48 Add option to permit query command when establishing a connection

Changelog

For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

Download | Release Notes | Changelog | Connector/Node.js Overview

Release date: 25 Sep 2018

MariaDB Connector/Node.js 2.0.0 is an Alpha release.

Features

• CONJS-42 : check other connections in pool when an unexpected connection error occur

• CONJS-44 : Create option to permit setting Object to one prepareStatement parameter

• CONJS-43 : Callback API is missing

• CONJS-39 : support geometric GeoJSON structure format

• CONJS-24 : new option "sessionVariables" to permit setting session variable at connection

• connection.end() immediate resolution on socket QUIT packet send.

• improve documentation and set Promise API documentation to a dedicated page.

• change pool implementation to permit node 6 compatibility (removal of async await)

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}