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 <[email protected]> wrote: > ------- Original Message ------- > On Thursday, June 9th, 2022 at 7:36 PM, Rich Shepard < > [email protected]> 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. >
