search

vgarvardt / gue

Golang queue on top of PostgreSQL
MIT License
278 stars 23 forks source link

Initial MySQL support #294

Closed vgarvardt closed 3 months ago

vgarvardt commented 3 months ago

3rd try to make it work

vgarvardt commented 3 months ago

after the third try I can say it is impossible to migrate to mysql keeping the functionality and the main reason is the way how mysql handles locks - postgres locks only one row when using WHERE <index-condition> LIMIT 1 while mysql locks the whole index that matches the condition, so in this case - the whole queue, so it is impossible to lock several records and SKIP LOCKED behaves very differently