Change8

data-table-mysql@0.5.0

Breaking Changes
📦 remixView on GitHub →
5 breaking4 features🐛 1 fixes🔧 6 symbols

Summary

Introduced `createMysqlDatabase()` with enhanced features like connection-scoped locking and database wiping. Breaking changes include the removal of `MysqlDatabaseAdapter` and renaming of options types.

⚠️ Breaking Changes

  • Removed `MysqlDatabaseAdapter` and `createMysqlDatabaseAdapter()` from the public entry point. Use `MysqlDatabase` and `createMysqlDatabase()` instead.
  • Renamed `MysqlDatabaseAdapterOptions` to `MysqlDatabaseOptions`.
  • The `wipe()` function now throws an error if no database name can be resolved from the connection config, instead of guessing.
  • Failed migration runs and failed transaction startups now destroy the reserved connection instead of returning a dirty session to the pool.
  • Nested lock acquisition now throws an error instead of deadlocking.

Migration Steps

  1. Replace `createMysqlDatabaseAdapter()` with `createMysqlDatabase()`.
  2. Replace `MysqlDatabaseAdapter` with `MysqlDatabase`.
  3. Update usages of `MysqlDatabaseAdapterOptions` to `MysqlDatabaseOptions`.

✨ New Features

  • Added `createMysqlDatabase()` with config-backed construction.
  • Added connection-scoped migration locking.
  • Added database wiping for `remix db`.
  • Added `close()` for releasing an internally created pool.

🐛 Bug Fixes

  • Use bound parameters for compiled `limit` and `offset` clauses.

Affected Symbols