@resolve-js/readmodel-mysql

An adapter the resolve-query uses to store the read model state in MySQL

Usage no npm install needed!

<script type="module">
  import resolveJsReadmodelMysql from 'https://cdn.skypack.dev/@resolve-js/readmodel-mysql';
</script>

README

resolve-readmodel-mysql

npm version

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

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.

Analytics