All pages
Powered by GitBook
1 of 26

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Connector/Node.js 2.x Release Notes

This category contains release notes for releases in the MariaDB Connector/Node.js 2.x series

Connector/Node.js 2.5.3 Release Notes

The most recent release of is:

Download | Release Notes | Changelog |

Release date: 24 Feb 2021

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

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

Notable Changes

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

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

  • [] Wrong definition for typescript PoolConnection.release

  • [] test 10.6 server latest build

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

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

Connector/Node.js 2.5.6 Release Notes

The most recent release of is:

Download | Release Notes | Changelog |

Release date: 17 Feb 2022

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

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

Notable Changes

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

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

  • correct character_set_client unexpect error parsing OK_Packet

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

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

Connector/Node.js 2.4.0 Release Notes

The most recent release of is:

Download | Release Notes | Changelog |

Release date: 26 May 2020

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

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

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

  • CONJS-86 - Support extension type format

  • - Error when using multipleStatements with metaAsArray

  • - Support 10.5 pluggable type

  • - checkDuplicate option is indicated in error when having dupplicate

  • - performance improvement

  • - typescript SqlError interface

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

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

Connector/Node.js 2.0.1 Release Notes

| | |

Release date: 15 Nov 2018

MariaDB Connector/Node.js 2.0.1 is a release.

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

Connector/Node.js 2.4.1 Release Notes

| | |

Release date: 2 Jul 2020

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

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

Connector/Node.js 2.1.2 Release Notes

| | |

Release date: 17 Oct 2019

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

Implemented enhancements:

  • [] Escape functions API

Connector/Node.js 2.4.2 Release Notes

| | |

Release date: 23 Jul 2020

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

  • - Number parsing loss of precision

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

Connector/Node.js 2.3.1 Release Notes

| | |

Release date: 20 Mar 2020

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

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

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

Connector/Node.js 2.1.4 Release Notes

| | |

Release date: 2 Dec 2019

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

  • use pool reset only for corrected COM_RESET_CONNECTION

Connector/Node.js 2.1.5 Release Notes

| | |

Release date: 8 Jan 2020

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

  • Batch improvement

Connector/Node.js 2.5.4 Release Notes

| | |

Release date: 14 Jun 2021

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

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

Connector/Node.js 2.0.0 Release Notes

| | |

Release date: 25 Sep 2018

MariaDB Connector/Node.js 2.0.0 is an release.

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

Connector/Node.js 2.5.2 Release Notes

| | |

Release date: 4 Dec 2020

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

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

Connector/Node.js 2.0.3 Release Notes

| | |

Release date: 31 Jan 2019

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

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

Connector/Node.js 2.5.1 Release Notes

| | |

Release date: 26 Oct 2020

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

  • - Support of the new node.js version v15

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

Connector/Node.js 2.0.4 Release Notes

| | |

Release date: 10 May 2019

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

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

Please use this new 2.0.5 version.

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

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

  • 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

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Updates

    Download
    Release Notes
    Changelog
    Connector/Node.js Overview
    Beta
    Blog post about the release
    CONJS-52

    Changelog

    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

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Download
    Release Notes
    Changelog
    Stable
    CONJS-138

    Changelog

    [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

    • [] Improve documentation for best practice concerning credential

    • [] Remove coverage comment on GitHub pull request

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

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-101
    This page is: Copyright © 2025 MariaDB. All rights reserved.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Changelog

    Download
    Release Notes
    Changelog
    Stable
    CONJS-142
    changelog
    This page is: Copyright © 2025 MariaDB. All rights reserved.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Changelog

    Download
    Release Notes
    Changelog
    Stable
    changelog
    CONJS-111 missing pool event definition
  • dependencies update

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-112

    Changelog

    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

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-115

    Changelog

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

  • update iconv-lite dependency to 0.6.3

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-163

    Changelog

    : 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Features

    Download
    Release Notes
    Changelog
    Alpha
    CONJS-42
    CONJS-44
    [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

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-151

    Changelog

    [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

  • 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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Connector/Node.js Overview
    Stable
    CONJS-56

    Changelog

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

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Changelog

    Download
    Release Notes
    Changelog
    Stable
    CONJS-149
    changelog

    Changelog

    CONJS-158
    CONJS-160
    CONJS-159
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3

    Changelog

    CONJS-183
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3

    Changelog

    CONJS-128
    CONJS-129
    CONJS-131
    CONJS-132
    CONJS-136
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Changelog

    Download
    Release Notes
    Changelog
    Connector/Node.js Overview
    Stable
    2.0.5
    changelog

    Connector/Node.js 2.1.3 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 19 Nov 2019

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

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

    Notable Changes

    • CONJS-109 Missing mysql only collation definition

    • typescript escape/escapeId definition

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

    • properly escape boolean parameter false

    • Typecast provided date function erroneous parsing

    • Pam authentication must permit to provide multiple passwords

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

    • better cluster error when pool is full

    • adding test coverage

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

    Connector/Node.js 2.3.0 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 20 Mar 2020

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

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

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

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

    • - permit setting session query timeout per option

    • - Force connection.escapeId to emit backtick #101

    • - exporting SqlError class to permit instanceOf checks #100

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

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

    misc:

    • appveyor testing server version upgrade

    • better debug logging trace format

    • correct ssl test

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

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

    Connector/Node.js 2.0.2 Release Notes

    The most recent release of is:

    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.

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

    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

    • test coverage improvement

    • minor performance improvement

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

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

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

    Connector/Node.js 2.1.1 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 06 Sept 2019

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

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

    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.

    Connector/Node.js 2.5.5 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 20 Oct 2021

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

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

    Notable Changes

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

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

    • [] Missing leakDetectionTimeout option in Typescript description

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

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

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

  • Changelog

    changelog
    3.5.3
    Download Connector/Node.js 3.5.3
    const mariadb = require('mariadb');
    
      mariadb.createConnection({host: 'mydb.com', user: 'myUser', password: ['myPwd', 'myAuthToken']})
        .then(conn => {
           ...
        })
        .catch(err => {
          ...
        });

    Misc

    CONJS-108
    CONJS-107
    CONJS-106
    CONJS-105
    CONJS-104
    3.5.3
    Download Connector/Node.js 3.5.3

    Changelog

    CONJS-127
    CONJS-126
    CONJS-124
    CONJS-123
    CONJS-122
    CONJS-121
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3

    Changelog

    CONJS-173
    CONJS-175
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3
    CONJS-99
    CONJS-97
    3.5.3
    Download Connector/Node.js 3.5.3

    Connector/Node.js 2.1.0 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 12 Jul 2019

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

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

    Notable Changes

    • [CONJS-19] Implement Ed25519 plugin

    • [] Multiple alternative authentication methods for the same user ()

    • [] Permit handling expired password

    • [] Implement pool events according to mysql/mysql2 API

    • [] Array parameter automatic conversion

    • [] Performance improvement on decoding string

    • [] Charset collation option separation

    • [] Types definition must be string, not byte, when using the option typeCast

    • [] Missing import dependencies for typeScript

    • [] Read errors while processing LOCAL INFILE can cause a process crash

    • [] Add poolCluster 'remove' event

    • [] Option restoreNodeTimeout is not respected when removeNodeErrorCount is set

    • [] Setting the timezone to the current IANA might provoke the server's automatic retrieval

    New Options

    Option
    Description
    Type
    Default

    The option charset now corresponds to charset, still permitting collation for compatibility, but then a warning is thrown to the console.

    Pools now emit events.

    event
    Description

    Example:

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

    Connector/Node.js 2.2.0 Release Notes

    The most recent release of is:

    Download | Release Notes | Changelog |

    Release date: 4 Feb 2019

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

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

    New option force Server version detection

    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.

    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:

    • 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.

    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

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

    • 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

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

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

    Connector/Node.js 2.5.0 Release Notes

    | | |

    Release date: 19 Oct 2020

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

    • - permit setting socket keep alive (option keepAliveDelay)

    Connector/Node.js 2.0.5 Release Notes

    | | |

    Release date: 13 May 2019

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

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

    boolean

    false

    release

    This event is emitted when a connection is released back into the pool. Has a connection object parameter

    collation

    (used in replacement of charset) Permit to define the collation used for connection. This will define the charset encoding used for exchanges with the database and define the order used when comparing strings. It's mainly used for micro-optimizations

    string

    UTF8MB4_UNICODE_CI

    permitConnectionWhenExpired

    acquire

    This event indicates that a connection has been acquired from pool.

    connection

    This event is emitted when a new connection is added to the pool. Has a connection object parameter

    enqueue

    This event is emitted when a command cannot be satisfied immediately by the pool and is queued.

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

    Pool events

    CONJS-57
    MariaDB 10.4
    CONJS-61
    CONJS-85
    CONJS-87
    CONJS-89
    CONJS-88
    CONJS-74
    CONJS-75
    CONJS-79
    CONJS-83
    CONJS-84
    CONJS-73
    3.5.3
    Download Connector/Node.js 3.5.3

    Permit a user with an expired password to connect. Only possible operation in this case will be to change the password ('SET PASSWORD=PASSWORD('XXX')')

    dependencies update
    //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'
              // }
      });

    Query timeout implementation CONJS-20

    Fast-authentication improvement CONJS-110

    Pool leak detection CONJS-117

    misc:

    Changelog

    CONJS-120
    CONJS-118
    changelog
    3.5.3
    Download Connector/Node.js 3.5.3
    CONJS-119

    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

    option
    description
    type
    default

    arrayParenthesis

    Indicate if array are included in parenthesis. This option permit compatibility with version < 2.5

    boolean

    false

    rsaPublicKey

    CONJS-143 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.

    • 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

    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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-148
    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']]);

    Bugs Fixed

    Changelog

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

  • New Options

    Option
    Description
    Type
    Default

    idleTimeout

    Indicate idle time after which a pool connection is released. Value must be lower than . In seconds (0 means never release)

    integer

    1800

    minimumIdle

    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 .

    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.

    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.

    The most recent release of is: 3.5.3

    Download Connector/Node.js 3.5.3

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

    Notable Changes

    Download
    Release Notes
    Changelog
    Stable
    CONJS-69

    Pool improvement

    Changelog

    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

    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

    Permit to set a minimum number of connection in pool. Recommendation is to use fixed pool, so not setting this value.

    integer

    set to connectionLimit value

    BigInt
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    safe
    Connector/Node.js Overview
    MariaDB Connector/Node.js
    About MariaDB Connector/Node.js
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    spinner
    @@wait_timeout
    @@wait_timeout
    BIGINT
    @@wait_timeout