@resolve-js/readmodel-mysql

resolve-readmodel-mysql

A Read Model Adapter for MySQL 5.7+ and compatible (like AWS Aurora) databases. The adapter provides a query API for projection and resolvers. This API is standard among reSolve read model adapters, so you can change a Read Model Adapter in the configuration file without changing the code.

Available Parameters

• ...connectionSettings - see Connection Settings for more information.

The adapter interface is defined in the @resolve-js/readmodel-base package.

Usage

import createAdapter from '@resolve-js/readmodel-mysql'

const adapter = createAdapter({
  ...connectionSettings,
})

Notes:

• Index fields can store only numbers of the BIGINT type or strings in the utf8mb4 encoding with the utf8mb4_unicode_ci collation (details).
• Other fields are stored in a json column as longblob (details)
• The maximum packet size is limited. You can configure it in the MySQL server options
• Double-check the encoding of connection names, requests, and responses: the encoding-related bugs are hard to catch.