From nobody Thu Dec 07 17:44:32 2023 X-Original-To: freebsd-hackers@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4SmM9N1X0nz53LZd for ; Thu, 7 Dec 2023 17:44:56 +0000 (UTC) (envelope-from dan@langille.org) Received: from out1-smtp.messagingengine.com (out1-smtp.messagingengine.com [66.111.4.25]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4SmM9M6xS9z4bGm for ; Thu, 7 Dec 2023 17:44:55 +0000 (UTC) (envelope-from dan@langille.org) Authentication-Results: mx1.freebsd.org; none Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailout.nyi.internal (Postfix) with ESMTP id D5E6A5C0112; Thu, 7 Dec 2023 12:44:54 -0500 (EST) Received: from imap42 ([10.202.2.92]) by compute7.internal (MEProxy); Thu, 07 Dec 2023 12:44:54 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=langille.org; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm1; t=1701971094; x=1702057494; bh=Vd CwcgedSoE+ePLtlA44dPfe88HHcVHBCVUaRoyf4AQ=; b=Ty+h755No09k3Lxq50 QpuCtiRGRSFj7CvdHenRxS/GZug8aSBvozNMtZpWiLI8sYgfqmY5MpoqJAJ+0UV5 GWTNZnvV4l/D0IK1lehzOlTx+LkVfMIGOhhslANUuimC95efIlUB2+ZG8aj1+poH fiW7oUmMEPNSWo5bhNGyqRZ6AWH0nAGBpxGbiE1Sbo8fto6RUTrfwXmONAEJ8HSn HYLexDWZ5F8D+3N31rD1rZp4UjsbBPMIQofmkm5leFafsEKoU+cWpMPcChj6NM6l iE/7UnLurQ6m0c4Y7P7trxRjreUMhrdfHtTW2m8HeE8TOCbHZr3KWmPQBWhhBbHn fuNw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1701971094; x=1702057494; bh=VdCwcgedSoE+e PLtlA44dPfe88HHcVHBCVUaRoyf4AQ=; b=lJRp+txTDUZC+ifyusSoqrUZc8a4X ZF9kR1lg8146KKvxKnqxgq2W8KH7KqILn14raVXMNZz+FStf4nr1od49u2etB/3m qyE1l06DLOUrpHrgeAXw9kyQeVM1TuTk729bMXeJWHAmDvi3JW5v/yCZRv4dDhJy CxzPF+K0FbLcnVzFDqqHFa7SFp4euHhWnKyXaVS+ogsRkAqQCR5/QAszNn5UH9gh 8U5crhL2TD5Q64dAFu9OeubdPF6L6F1tLrYr4DJTPXhpXvHkPwF+YgbmpT/pvmOS UQe/CG29qyvhVvDifSdOL2pl/A8KpFifFCumwPGgoRJ9dUndod6nGsETA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudekfedggeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesthdtredtreertdenucfhrhhomhepfdffrghn ucfnrghnghhilhhlvgdfuceouggrnheslhgrnhhgihhllhgvrdhorhhgqeenucggtffrrg htthgvrhhnpeekteejleduffeguddutdffjeekgfffjeefjeefteeuudeuudeljeeivdfg vedvfeenucffohhmrghinhepuggrnhgprghtpghlrghnghhilhhlvgdrohhrghdpfhhrvg gvsghsugdrohhrghdpghhithhhuhgsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptden ucfrrghrrghmpehmrghilhhfrhhomhepuggrnheslhgrnhhgihhllhgvrdhorhhg X-ME-Proxy: Feedback-ID: ifbf9424e:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 923AABC007E; Thu, 7 Dec 2023 12:44:54 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-1178-geeaf0069a7-fm-20231114.001-geeaf0069 List-Id: Technical discussions relating to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-hackers List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-hackers@freebsd.org MIME-Version: 1.0 Message-Id: In-Reply-To: <6BD2CBAF-7ADC-4ADC-B8F0-1280FECEC155@yahoo.com> References: <6BD2CBAF-7ADC-4ADC-B8F0-1280FECEC155.ref@yahoo.com> <6BD2CBAF-7ADC-4ADC-B8F0-1280FECEC155@yahoo.com> Date: Thu, 07 Dec 2023 12:44:32 -0500 From: "Dan Langille" To: "Mark Millard" , "FreeBSD Hackers" Subject: Re: list of valid ABI combinations Content-Type: text/plain X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:19151, ipnet:66.111.4.0/24, country:US] X-Spamd-Bar: ---- X-Rspamd-Queue-Id: 4SmM9M6xS9z4bGm On Thu, Dec 7, 2023, at 10:03 AM, Mark Millard wrote: > Dan Langille wrote on > Date: Thu, 07 Dec 2023 13:22:28 UTC : > >> . . . >> My goal is to automatically maintain this table, from which FreshPorts fetches package information: >> >> freshports.dev=# select * from abi order by name; >> id | name | active >> ----+----------------------+-------- >> 9 | FreeBSD:12:aarch64 | t >> 1 | FreeBSD:12:amd64 | t >> 15 | FreeBSD:12:armv6 | t >> 16 | FreeBSD:12:armv7 | t >> 8 | FreeBSD:12:i386 | t >> 18 | FreeBSD:12:mips64 | t >> 19 | FreeBSD:12:powerpc64 | t >> 2 | FreeBSD:13:aarch64 | t >> 11 | FreeBSD:13:amd64 | t >> 20 | FreeBSD:13:armv6 | t >> 21 | FreeBSD:13:armv7 | t >> 10 | FreeBSD:13:i386 | t >> 23 | FreeBSD:13:mips64 | t >> 24 | FreeBSD:13:powerpc64 | t >> 34 | FreeBSD:13:riscv64 | t >> 26 | FreeBSD:14:aarch64 | t >> 27 | FreeBSD:14:amd64 | t >> 28 | FreeBSD:14:armv6 | t >> 29 | FreeBSD:14:armv7 | t >> 30 | FreeBSD:14:i386 | t >> 32 | FreeBSD:14:mips64 | t >> 33 | FreeBSD:14:powerpc64 | t >> 35 | FreeBSD:14:riscv64 | t >> 54 | FreeBSD:15:aarch64 | t >> 47 | FreeBSD:15:amd64 | t >> 48 | FreeBSD:15:armv6 | t >> 49 | FreeBSD:15:armv7 | t >> 50 | FreeBSD:15:i386 | t >> 51 | FreeBSD:15:mips64 | t >> 52 | FreeBSD:15:powerpc64 | t >> 53 | FreeBSD:15:riscv64 | t >> (31 rows) >> . . . > > The name list in the middle (/bin/sh context): > > # fetch https://pkg.freebsd.org/index.html > index.html 3606 B 103 MBps 00s > > # grep FreeBSD: index.html | sed -e 's@.*\(FreeBSD:[^ <]*\).*@\1@' | sort > FreeBSD:12:aarch64 > FreeBSD:12:amd64 > FreeBSD:12:armv6 > FreeBSD:12:armv7 > FreeBSD:12:i386 > FreeBSD:13:aarch64 > FreeBSD:13:amd64 > FreeBSD:13:armv6 > FreeBSD:13:armv7 > FreeBSD:13:i386 > FreeBSD:13:powerpc > FreeBSD:13:powerpc64 > FreeBSD:13:powerpc64le > FreeBSD:14:aarch64 > FreeBSD:14:amd64 > FreeBSD:14:armv6 > FreeBSD:14:armv7 > FreeBSD:14:i386 > FreeBSD:14:powerpc > FreeBSD:14:powerpc64 > FreeBSD:14:powerpc64le > FreeBSD:15:aarch64 > FreeBSD:15:amd64 > FreeBSD:15:armv6 > FreeBSD:15:armv7 > FreeBSD:15:i386 > FreeBSD:15:powerpc > FreeBSD:15:powerpc64 > FreeBSD:15:powerpc64le > > There might be issues at times with https://pkg.freebsd.org/index.html not > being in sync. As far as I can tell, that page is manually maintained. > > Hopefully this can help. I think it's fantastic. I've added it to https://github.com/FreshPorts/freshports/issues/505 > I've no clue about the id column as the list changes, for example > when the FreeBSD:12:* disappear sometime after the end of the year. No worries about database issues. Those I can resolve. It's what you did that I can't often find an easy solution. Thank you. -- Dan Langille dan@langille.org