[PLUG] Package Name Lengths in different distros

[Tomas Kuchta]

Suse can also have long names.

I'd keep the name column text or equivalent. You can always use index or
compute name's sha1/256 hash column if you need to speed up searches/joins
over millions of rows.

Tomas

On Thu, Jun 9, 2022, 22:47 Ben Koenig <techkoenig at protonmail.com> wrote:

> ------- Original Message -------
> On Thursday, June 9th, 2022 at 7:36 PM, Rich Shepard <
> rshepard at appl-ecosys.com> wrote:
>
>
> > On Fri, 10 Jun 2022, Ben Koenig wrote:
> >
> > > How high should I set the limit?
> >
> >
> > Ben,
> >
> > I don't use mariadb but it's likely to have a data type such as 'text' or
> > 'varchar', both of which have no defined limit. Using such a data type on
> > your package name removes the issue of the name's length. This data type
> is
> > useful for a column that stores a comment or description the length of
> which
> > varies greatly from row to row.
> >
> > HTH,
> >
> > Rich
>
>
> I may end up looking into that though I'm largely confined to the
> character fields defined by django. Instead of a CharField I would use a
> TextField. That could end up requiring more custom code on my end which
> would need to be maintained.
>