search

bkeepers / qu

a Ruby library for queuing and processing background jobs.
MIT License
505 stars 50 forks source link

Add experimental Sequel backend #62

Closed norbert closed 10 years ago

norbert commented 11 years ago

This is a draft implementation of a Sequel database backend.

As discussed in #8, this uses a fairly "close to the metal" library that supports a wide range of database adapters. Locking is done using SELECT FOR UPDATE which is not always optimal. (See delayed_job_active_record for alternatives.)

Even though all tests pass this could still use some work.

munshkr commented 11 years ago

Hi Norbert, I was trying out your Sequel backend with SQLite3, and because DISTINCT ON is not supported on SQLite, I replaced it with a GROUP BY, which seems to work alright. Tell me what you think about it. Thanks!

jnunemaker commented 10 years ago

@norbert thanks for working on this. I would rather not maintain this in the core repo, but you can easily move this to your own repo qu-sequel and just require the shared spec file that we have in lib.

norbert commented 10 years ago

@jnunemaker okay, works for me. The code is now in https://github.com/norbert/quixotic and can still be required as qu-sequel.

@munshkr your change looked good and has been applied to the new repository.