Database observer?

I’m creating an ebay-style auction application. I need a way to expire
the lots once their end time has passed.

The only way I can see to do it is through a cron job - every minute or
two, run a rails script which queries the database and finds any lots
that have expired buy haven’t been ‘marked’ as closed. Of course, the
instant a lot expires, it’s no longer available for bidding.

This seems really clunky and hackish, but I can’t see any way to
‘Observe’ the database.

Anyone have any ideas?

Thanks

Jason

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs