The Ultimate Guide to High Availability with MariaDB

MariaDB Connector/Node.js 3.4.0 Release Notes

You are viewing an old version of this article. View the current version here.

Note: This page describes features in an unreleased version of MariaDB Connector/Node.js.

Unreleased means there are no official packages or binaries available for download which contain the features. The source code is available on GitHub.

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

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

Notable changes

  • CONJS-295 A new option jsonStrings has been added which can be used to return a JSON field as type string instead of type JSON

When working with JSON fields in MariaDB and MySQL, it's important to note that the handling differs between the two database systems.

  • autoJsonMap Option: The autoJsonMap option provides flexibility in MariaDB. You can choose to have the connector return either JSON objects or string representations of the JSON data.
  • jsonStrings Option: The jsonStrings option introduces a similar choice for MySQL JSON fields. It allows you to specify whether the connector should return JSON objects or string values.

In essence, the JSON fields will be returned either as a JSON or String will depend on 2 different options depending on the database you’re working with.

  • CONJS-296 Add option enableKeepAlive / keepAliveInitialDelay alias for keepAliveDelay for mysql2 compatibility

The keepAliveDelay option in MariaDB connectors controls the frequency of keep-alive packets sent to maintain a persistent connection.

  • Disabled: When set to 0, keep-alive functionality is disabled.
  • Enabled: For any non-zero value, keep-alive packets are sent at the specified interval.

MySQL 2 Compatibility:
To ensure compatibility with the MySQL 2 connector, the enableKeepAlive and keepAliveInitialDelay options have been added.

  • enableKeepAlive: If disabled, keepAliveDelay is automatically set to 0, effectively disabling keep-alive.
  • enableKeepAlive: If enabled, keepAliveDelay is set to the value specified in keepAliveInitialDelay.

In summary, the keepAliveDelay option determines the keep-alive frequency, while the enableKeepAlive and keepAliveInitialDelay options provide compatibility with MySQL 2 connectors by allowing you to control whether keep-alive is enabled and set the initial delay.

Issues Fixed

CONJS-303 DMLs are not returning an output while streaming

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.