On Wed, 26 Aug 2009 14:49:53 you wrote: > Aaron Bentley wrote: > > Celso Providelo wrote: > >> On Tue, Aug 18, 2009 at 3:17 PM, Aaron Bentley<aa...@canonical.com> wrote: > >>> I know that Jobs provide their own queue system, so I don't know > >>> whether BuildQueue duplicates that. > >> > >> It possibly duplicates the queue infrastructure itself, and > >> additionally ordering/re-prioritizing which doesn't seem to be > >> possibly with the current Job table. > > > > So it seems like we've already got the duplication, but what you're > > proposing could be a step towards unification. That sounds positive to > > me. > > Yes, indeed. > > > Job doesn't provide an ordering mechanism, but BranchJob provides > > arbitrary metadata via the JSON field, so you can plug one in if you > > want. > > I'd just say that here the JSON field is a bit of a red herring; I very > much expect that we'll want to do the ordering in database queries, and > that means having the data in a place that the database can easily see > it. But that's OK, I think, we have schema patches for a reason :)
One of the conditions of the JSON field was that we would *never* use it in a query to restrict or order the jobs. If we have to split something out, lets do that instead. Tim _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : launchpad-dev@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp