search

opral / lix-sdk

1 stars 0 forks source link

evaluate side-effect triggering via kysely plugin instead of sql triggers #45

Open samuelstroschein opened 3 weeks ago

samuelstroschein commented 3 weeks ago

Context

Debugging the SQL triggers is hard because stack traces are missing/start without context.

The throw below is triggered by the change queue. Debugging the trigger requires a breakpoint at the correct "time" when the query breaks. If a stack trace of a side-effect includes the cause, debugging becomes simpler.

CleanShot 2024-08-20 at 16.34.57@2x.png

Idea

We might be able to use the Kysely plugin interface to trigger side effects like the change queue.

samuelstroschein commented 3 weeks ago

not important enough to delay the lix release imo