Upgrade from MariaDB Connector/Node.js 3.0 to 3.3

Overview

MariaDB Connector/Node.js 3.0 is fully compatible with MariaDB Connector/Node.js 3.3. As a new fully compatible major version, MariaDB Connector/Node.js 3.3 supersedes MariaDB Connector/Node.js 3.0, and users should upgrade to 3.3.

Time Zone Conversions

  • Starting with MariaDB Connector/Node.js 3.1, instead of performing time zone conversions locally, MariaDB Connector/Node.js can set the session value of the time_zone system variable. This allows the remote server to handle time zone conversions. In previous releases, time zone conversions are performed locally.

Load tzdata into MariaDB Enterprise Server

To load tzdata into MariaDB Server, use the mariadb-tzinfo-to-sql utility:

$ mariadb-tzinfo-to-sql /usr/share/zoneinfo | mariadb -u root mysql

timezone Parameter Changes

  • Starting with MariaDB Connector/Node.js 3.1, all time zone conversions are performed on the remote server. The timezone parameter is used to configure the behavior. The arguments have not changed, but the meaning of each argument has changed slightly:

    timezone
    (Parameter Argument)

    Description

    local

    • This is the default mode.

    • The session value of the time_zone system variable is not set, so no time zone conversion is performed.

    • This mode is only recommended when the client and server use the same time zone.

    auto

    • If the server's time zone is different from the client's time zone, the session value of the time_zone system variable is set to the client's time zone.

    • This mode is recommended when the server and client use different time zones, but the client's time zone is known to be properly configured.

    • If the client's time zone is set to an IANA time zone name and the remote server is MariaDB Server, the time zone database must be loaded on the remote server. MariaDB Server only supports IANA time zone names in the time_zone system variable when the data from the IANA time zone database (also known as tzdata or zoneinfo) has been loaded using the mariadb-tzinfo-to-sql utility.

    IANA time zone name
    (such as America/New_York)

    • The session value of the time_zone system variable is set to the provided IANA time zone name without checking the server's time zone.

    • If the remote server is MariaDB Server, the time zone database must be loaded on the remote server. MariaDB Server only supports IANA time zone names in the time_zone system variable when the data from the IANA time zone database (also known as tzdata or zoneinfo) has been loaded using the mariadb-tzinfo-to-sql utility.

    UTC offset
    (such as -04:00)

    • The session value of the time_zone system variable is set to the provided UTC offset without checking the server's time zone.

TypeScript

  • Starting with MariaDB Connector/Node.js 3.1, with TypeScript, the batch(), execute(), and query() methods have been internally defined to have type assertions, so that applications can assign the return values without defining type assertion at the application level.

    • In previous releases, assigning the return values of the batch(), execute(), and query() methods required type assertions, which means the METHOD_CALL() AS TYPE_NAME or <TYPE_NAME> METHOD_CALL() syntax was required.

    • Starting with MariaDB Connector/Node.js 3.1, the type assertions are defined internally using generic types.

Options

New Parameters

NONE

Default Changes

Option

Old default value

New default value

metaEnumerable

true

false

Deprecated Options

NONE