Effect CommunityEC
Effect Community3mo ago
6 replies
Brendonovich

Incompatibility of `SqlMessageStorage` with Vitess Databases Due to Foreign Key Constraints

I've just become aware that SqlMessageStorage is currently incompatible with Vitess databases (Planetscale), as it uses a recursive foreign key constract (messages.requestId -> messages.id with ON DELETE CASCADE).
Would it be possible to have a version that either removes the fk constraint or uses an action other than ON DELETE CASCADE? Would be happy to assist with working on this if we can think of a solution.
Was this page helpful?