From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id wEQTAVuER1/cHgAA0tVLHw (envelope-from ) for ; Thu, 27 Aug 2020 10:00:59 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id 2PuJOFqER19ZBwAA1q6Kng (envelope-from ) for ; Thu, 27 Aug 2020 10:00:58 +0000 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 8254C9404CF for ; Thu, 27 Aug 2020 10:00:58 +0000 (UTC) Received: from localhost ([::1]:46022 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kBEiH-0003U9-D6 for larch@yhetil.org; Thu, 27 Aug 2020 06:00:57 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:36308) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kBEi8-0003Tx-KU for guix-devel@gnu.org; Thu, 27 Aug 2020 06:00:48 -0400 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]:39229) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kBEi6-00089G-Id for guix-devel@gnu.org; Thu, 27 Aug 2020 06:00:48 -0400 Received: by mail-wr1-x435.google.com with SMTP id a5so4761501wrm.6 for ; Thu, 27 Aug 2020 03:00:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:in-reply-to:references:date:message-id:mime-version :content-transfer-encoding; bh=MmuP51ZzA9YJPR2VUyiTSS2vP9FCPJtz7LxwagtlNV4=; b=ITIYGLz9hehWlQd5CsDt2d4Tr2U+glgDxHKfJTeNH0pbEXgIPt7FXghb9a1NnGea2b 1uizua0yy+rBJQxc04UR5/bj5s9vmKTnQKGxZmnyh0uSDigviebQTcyCxNcu6mrTSAXy jIxenJJzZjZxgRxMsySvIb3N+u+zWADqUWCfb4YF9zYnmBSbTuUqMqdSMXsf2F7Ewr24 jEZxobEml7i2PamfqWd3ghpCx4RBxAAeWVr9qtm0JCwHsfdW+OTvM3U5QEz6V1m/xAOg Gtzg0wf2/yfeKti7mE+H4oAQs0J9nCS0/5PzkoouN3D5+t9qOUNztU+OPC6VywsGtwzX 4Lpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:in-reply-to:references:date :message-id:mime-version:content-transfer-encoding; bh=MmuP51ZzA9YJPR2VUyiTSS2vP9FCPJtz7LxwagtlNV4=; b=iSKkJuhVVJ6IgoU4rp4lpqEwhSGkVmrBnpBRtH+JbLQ1SUR9CXAlSABNfnhRJ/+JT3 qq728LiAwTgTrub/9RUMAieFtgSPyZ3Us5xBwzhlFpPZ8CAgiRxCWG1B7AIac5F+DOyv 65/G6YmaoCIP7kEgfmFumgWskjrUUyqsze3ACLc90f4QFuBDgZ8tesiXdYJs3x/DnBjy wLnlu20FU/AsqGV0YavkJnpKDnNFAnrPamrJuliAan9Z+nFRfe/rf7fANz2przcQa8uD 3HIQYMY275nnEiYENZCGmc5WeaXAH8mSv52pu/XeT5+Hl5nWznDISehX+XFB1c/ILeqw XhWg== X-Gm-Message-State: AOAM531sAp6OHHeUuqkMZhGcD7axcM6BF4cllRkB7ftNBuyknSvaxfmh YFapJeaIV1OVcaLneC0O0azgDFSVjIQ= X-Google-Smtp-Source: ABdhPJzB4RZ4KHGuvEcmGumYvwR6KbFs5BF0PnWPFEBVEl68q5bXPJ+TjcAU3TBvKxkrer3xNhNkNA== X-Received: by 2002:a5d:654b:: with SMTP id z11mr17766788wrv.174.1598522443514; Thu, 27 Aug 2020 03:00:43 -0700 (PDT) Received: from lili (57.246.195.77.rev.sfr.net. [77.195.246.57]) by smtp.gmail.com with ESMTPSA id m10sm4089574wmi.9.2020.08.27.03.00.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Aug 2020 03:00:43 -0700 (PDT) From: zimoun To: Pierre Neidhardt , guix-devel@gnu.org Subject: Re: File search progress: database review and question on triggers In-Reply-To: <87sgcuh8rb.fsf@ambrevar.xyz> References: <87sgcuh8rb.fsf@ambrevar.xyz> Date: Thu, 27 Aug 2020 12:00:36 +0200 Message-ID: <86imd4e7cr.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=2a00:1450:4864:20::435; envelope-from=zimon.toutoune@gmail.com; helo=mail-wr1-x435.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. 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, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=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.23 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" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=ITIYGLz9; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Spam-Score: -1.71 X-TUID: eqXVqnvdZ3cL Hi Pierre, Cool to relive the topic. :-) (disclaim: I have not yet process all the thread and emails) On Mon, 10 Aug 2020 at 16:32, Pierre Neidhardt wrote: > 1. An SQLite database with the following schema: If you are going to an local SQL database, my two questions are: a) Which part would update it? =E2=80=9Cguix pull=E2=80=9D? Other? Even usi= ng substitutes, the channels and co could lead to an extra cost and so what is acceptable and what is not? b) Could you also include other fields such that =E2=80=9Csynopsis=E2=80=9D and =E2=80=9Cdescription=E2=80=9D? Because it could speed up =E2=80=9Cguix sea= rch=E2=80=9D without adding (or modifying) the current cache (~/config/guix/current/lib/package.cache); discussed at length in #39258 . Cheers, simon