Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread Randy Bush
back about '80, a compiler geek at su-ai asked on the arpanet lang list whether an 8 or 12 char limit for variable names was appropriate. david moon, cmu, sent an email to report a bug in the su-ai mailer which was regurgitating mail from the '50s and '60s, but with current dates. randy

Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread Tomas Kuchta
On Fri, Jun 10, 2022, 16:44 Keith Lofstrom wrote: > When you encounter one of > the twits who creates ridiculously long package names, > corner them and blabber about your vacation in Thailand, > mentioning the official Thai (20 second to pronounce) > capital city name frequently. Watch the

Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread Keith Lofstrom
> I may up it to 100/150 but if anyone is aware of a package name for any linux > distro that exceeds 100 characters that would be helpful to know. I only use > a few different distros myself and wasn't expecting to hit this issue. Hash tables for the long exceptions, as suggested by others.

Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread Galen Seitz
On 6/9/22 18:16, Ben Koenig wrote: Hi all, I have a really random question/rant about package metadata across different distros. Quick backstory.. For reasons best explained by https://xkcd.com/2610/, I'm writing a series of scripts that ingest package data into a set of SQL tables in mariadb.

Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread Rich Shepard
On Fri, 10 Jun 2022, Tomas Kuchta wrote: 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. Or, index that column. Rich

Re: [PLUG] Package Name Lengths in different distros

2022-06-10 Thread 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 wrote: > --- Original Message --- > On

Re: [PLUG] Package Name Lengths in different distros

2022-06-09 Thread Rich Shepard
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