README
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 theutf8mb4
encoding with theutf8mb4_unicode_ci
collation (details). - Other fields are stored in a
json
column aslongblob
(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.