Re: Pear webby

On Tue, 2002-02-19 at 23:50, Tomas V.V.Cox wrote: > "Stig S. Bakken" wrote: > > > > On Mon, 2002-02-18 at 19:21, Richard Heyes wrote: > > > How far are we away from going live? I remember Martin mentioned the > > > re-release needed some attention, and Tomas recently fixed the package > > > browser (wrt not showing subcats). Shouldn't be that far away... (I'm > > > hoping > > > ;D). > > > > > > Also, I know Tomas is an advocate of clearing down the database and starting > > > afresh, but personally (and I'm probably not alone) I don't really want to > > > have to upload all my packages again. :( > > > > You won't have to, all the package files are on there, it's just a > > matter of importing them again. But I don't really think it's necessary > > to clear the database now. Tomas? > > Of course not now, when finally go for production. Now we can live with > our "pseudo-production" system :-) > > > I'm still waiting for Mark Woodward's pgsql version sorting function, as > > soon as I have it we're switching from mysql to postgres. > > > > I'm curious about what does this function will do. Sorting packages by > version? BTW, If you need some help with Postgres don't hesitate to > "call" me, I have some experience with it. I want to be able to find the "newest" stable release of a package like this: SELECT id,version FROM releases WHERE package = 42 AND state = 'stable' ORDER BY version_sort(version) LIMIT 1 We could use release dates, but then we're screwed if someone makes a release branch. - Stig