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 similar to the other reSolve adapters API, which means you can change a Read Model Adapter in the configuration file without changing the code.
Available Parameters
-
...connectionSettings
- see Connection Settings for more information. -
preferEventBusLedger
- store ledger in event bus instead read-model database itself.
Adapter interface is provided by resolve-readmodel-base package.
Usage
import createAdapter from 'resolve-readmodel-mysql'
const adapter = createAdapter({
...connectionSettings
})
Notes:
- Index fields can store only numbers with
BIGINT
type or strings inutf8mb4
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 MySQL server options
- Double-check the encoding of connection names, requests, and responses: the encoding-related bugs are hard to catch.