Re: [UDD] Suggested table: release_order
On 02/02/10 at 14:54 +0100, Andreas Tille wrote:
> Hi,
>
> recently the type 'release' was dropped because it creates much hasle to
> add a new release (needs recreation of tables containing this type etc).
> Because I would like to be able to sort entries per release I would like
> to suggest a lookup table
>
> CREATE TABLE releases (
> releasename text,
> sort int, /* use values 10, 20, 30, 40, ... */
> PRIMARY KEY (releasename)
> );
>
> This enables joining and sorting. We even might consider using a
> constraint of the release columns in the tables containing release
> columns enforcing values listed in the release table (but perhaps
> this is to much (calculating) power for less use.
If we are going this way, it would make more sense to provide the
release date as the value to sort on. And use a specific date in the
future for releases which haven't happened yet.
> In case you agree in principle with this approach, how do we want to
> handle releases of Ubuntu which reside in UDD as well and SkoleLinux
> which I plan to add sooner or later.
Well, release dates would apply as well.
--
| Lucas Nussbaum
| lucas@lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr GPG: 1024D/023B3F4F |
Reply to: