From: "Ara.T.Howard" Date: 2004-07-04T10:57:44+09:00 Subject: Re: SQLite/Ruby update pending On Sun, 4 Jul 2004, Jamis Buck wrote: > Ara.T.Howard wrote: > >> sounds good. hopefully you know that it goes without saying that you >> can take >> arrayfields.rb and distrbute it with sqlite if you ever want too... > > Thanks, Ara. I appreciate that. However, I always worry when doing that, > since if I package it with one version of arrayfields, and somewhere > down the road I forget to update arrayfields when you come out with a > new version, it could wind up that a user will have multiple > (potentially incompatible) versions of arrayfields installed...which > gets ugly. > >> a dedicated error for SQLITE_BUSY! it would be great to be able to >> >> begin >> db.execute sql >> rescue SQLite::Busy >> retry unles too_many_retries or timeout >> end > > Done! The exception is SQLite::BusyException. :) I'd been meaning to do > that anyway--thanks for reminding me! > > Other exceptions are also defined, such as SQLite::LockedException, > SQLite::SQLException, and so forth. (Basically, each valid return code > defined by the sqlite API is now encapsulated in an exception class.) > > Anything else? :) just keep up the good work! i ran about 200,000 jobs through an nfs mounted priority queue i implemented using your sqlite module in about 200 lines of code in the last week without error. 30 clients accessing the queue with no central server - i'm blow away by the possiblities opened up by developing apps using ruby on top of sqlite - it's an awesome combo so i think your package is poised to see some heavy use. cheers. -a -- =============================================================================== | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE :: 303.497.6469 | A flower falls, even though we love it; | and a weed grows, even though we do not love it. | --Dogen ===============================================================================