From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id gP/5IQrge2N4hwAAbAwnHQ (envelope-from ) for ; Mon, 21 Nov 2022 21:31:06 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id KJHyIQrge2PdBAAA9RJhRA (envelope-from ) for ; Mon, 21 Nov 2022 21:31:06 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 657253E1BE for ; Mon, 21 Nov 2022 21:31:06 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oxDR3-0005x4-8p; Mon, 21 Nov 2022 15:30:33 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oxDR0-0005te-VA for guix-devel@gnu.org; Mon, 21 Nov 2022 15:30:30 -0500 Received: from mail-40134.protonmail.ch ([185.70.40.134]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oxDQy-0005KY-F5 for guix-devel@gnu.org; Mon, 21 Nov 2022 15:30:30 -0500 Date: Mon, 21 Nov 2022 20:30:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail3; t=1669062624; x=1669321824; bh=PwTNEkhkvK3wfW8Ul7oXqH73PcJnKh4ePDVXP+0Nq5Q=; h=Date:To:From:Cc:Subject:Message-ID:In-Reply-To:References: Feedback-ID:From:To:Cc:Date:Subject:Reply-To:Feedback-ID: Message-ID:BIMI-Selector; b=Rfz9vn4/Ihl0brCpeJ4EQUIriW1ZFSLBmOIev8XkhD+tLCbET1gcoWaxp/vLR/kO8 8ocp9oeaxmXC7xWYOrTZEW5Chh2samowZCX3imhQSxy8IUcGWg0X9cgwWR4wIlIPq9 qAUy38l5GU5vM2eIf5YSIutR5QYV4EGOJjjOCNtRzyibLKMVywFe7OwdH7WrVfBfhm ObkdJBdnfGYSxcNZgtvjf4cXR/s32B4eH4dF9QYjrnURICha4Hhsx9qw95oT3Mx0re 2gGJ5E09DLgny7Qvr3l1qj6FeAqyR9IFO41y1IXPDUvEYMfMstSSpbhIuASnr+d/Ii gRI+phlLjQHWQ== To: Christopher Baines From: John Kehayias Cc: Luis Felipe , guix-devel@gnu.org Subject: Re: [Guix Website] A Search Page for Packages Message-ID: <871qpwjbjb.fsf@protonmail.com> In-Reply-To: <87zgcmapen.fsf@cbaines.net> References: <9vqBOZWiGUiZSkoCuukNGQ3yi98pp4JEJ42TdjCMl3hvFb0HpTZDWD8XCxWkXIwaixIoEAvGrfL-ZUsdw9jgNjOMYrFL0E973-9Cgnv4W_0=@protonmail.com> <87iljtgr72.fsf@cbaines.net> <87zgcqetsk.fsf@cbaines.net> <8735afcip5.fsf@cbaines.net> <874juvj5ck.fsf@protonmail.com> <87zgcmapen.fsf@cbaines.net> Feedback-ID: 7805494:user:proton MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=185.70.40.134; envelope-from=john.kehayias@protonmail.com; helo=mail-40134.protonmail.ch X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: guix-devel-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1669062666; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=PwTNEkhkvK3wfW8Ul7oXqH73PcJnKh4ePDVXP+0Nq5Q=; b=b3sNmeev7Y9XUpUQFA4kkMFB8c3m6SjbDs3E5kXcql7XIH+k65ehMr9hFeZHv48VnspJsZ rG29fjTp3a/JNeJLyiQ13lilY0hGi1Eq8hYWcVLJnkOrtO/gQfOceLe3xpz5RswI+Iw3Lw K0sGyM9RZPYK3L+RQFc6J1cnsdolKvvzEcNvyLpldK0axnyZUtxYzaNPE1/HzbVwFROmAE GG/hkzpci7efOOFAEnyXHvxa1mbYx1hRZQL0wojPoj/T8aESSf4OIQskqiD+m/5n5WH1dn utDwMs1PbcAtvEsH4a45c0UQPCGoJAanOcbFR1OBQrEPRZPK6d9PuMqnbipFGA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1669062666; a=rsa-sha256; cv=none; b=qFpZxpXP3eevbk+whf03yh+xbBepJDQ1f+EhQ9ySaibzpByHeflZYbMSfBL33qTXUvySbZ 0MLfeGUij4NafESLmZ2Vdwk74uWrqbBn/NPfmxs9ra1v9qFiEe/kKuafDG7+C5+BFW8/Fk 8HUspsfK8UQpXRlIGarAKrBFYLaoaR8IaI+aJN9m+GosryDzStf6IzssmKP7mDXwdmTiCX /IYuTVzyM4K8C2pOWDCXlBAt+64T/OK3rWjRlpbpS6Wv6q3/7t0fovGFIRvyhozLa9BWTD tsSnuTYMO+9LXatglSxaV/BbbjbRP4Gr67N0QIV705kqPfSbPio9rkwPNxl9cg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=protonmail.com header.s=protonmail3 header.b="Rfz9vn4/"; dmarc=pass (policy=quarantine) header.from=protonmail.com; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -8.01 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=protonmail.com header.s=protonmail3 header.b="Rfz9vn4/"; dmarc=pass (policy=quarantine) header.from=protonmail.com; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 657253E1BE X-Spam-Score: -8.01 X-Migadu-Scanner: scn0.migadu.com X-TUID: exsMA/Jix0Vm Hi Chris On Sat, Nov 19, 2022 at 04:13 PM, Christopher Baines wrote: > The search functionality is being provided by the Guix Data Service, > which in turn is searching through records in a PostgreSQL database. > > The relevant code is here [1], and it's the plainto_tsquery bit that > starts the transformation from a string to what PostgreSQL is using for > the search. > > 1: > > I see. My knowledge of PostgreSQL is limited to emergency measures for when= something happens with the home server :) > So yeah, I don't think the way it's implemented currently supports * as > a wildcard, although maybe that could be supported by changing the way > the query works. A low priority, but it would be nice on the list of things for future versi= ons to improve the search. I think basic substring/partial matches would go= a long way. Probably very easy for the PostgreSQL-ers. Or maybe make it ma= tch as best it can the result lists from "guix search" as a nice parallel. Anyway, thanks again for this, great to see it live! John