@kittlekit/crud-drizzle-mysql

Drizzle + MySQL CRUD execution helpers for the Kittlekit CRUD package family.

What This Package Is

Use this package when your persistence layer is based on:

• Drizzle ORM
• MySQL / mysql2

This package handles:

• list query resolution
• list/detail reads
• create/update/delete mutations

and keeps cache/audit/event/diff behavior injected from the host app.

Install

npm install @kittlekit/crud-drizzle-mysql @kittlekit/crud-core drizzle-orm uuidv7

Main Exports

Query layer

• resolveCrudListQuery
• CrudListQuery

Read layer

• listCrudRecords
• getCrudRecordById
• getCachedCrudDetail

Mutation layer

• createCrudMutation
• updateCrudMutation
• deleteCrudMutation

Adapter Model

Mutation helpers accept injected adapters for:

• event bus
• audit logging
• diff calculation
• cache key building

Read helpers accept injected adapters for:

• cache read behavior
• cache key/tag building

Relationship to Other Packages

crud-core -> crud-drizzle-mysql

Out of Scope

• Fastify/Express route registration
• auth/session guards
• app-owned cache or audit services

Publish

npm run build --workspace @kittlekit/crud-drizzle-mysql
npm publish --workspace @kittlekit/crud-drizzle-mysql --access public

Examples

• smoke setup: sandbox/crud-smoke
• server wrapper references:
  • server/src/core/crudFactory.query.ts
  • server/src/core/crudFactory.reads.ts
  • server/src/core/crudFactory.mutations.ts

Release Notes

0.1.0

• first public extraction of Drizzle MySQL query/read/mutation helpers