From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: cesar mena Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 13:54:58 -0800 Message-ID: <871r2p8klp.fsf@gnu.org> References: <87tufmjyai.fsf@gnus.org> <877dcil2sj.fsf@ericabrahamsen.net> <87czm98qi1.fsf@gnu.org> <87o85tcwm0.fsf@ericabrahamsen.net> <874k7ljwkr.fsf@gnus.org> <87fsr5cuzq.fsf@ericabrahamsen.net> <878rwx8mdn.fsf@gnu.org> <87bl1tct4c.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="31274"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.90 (gnu/linux) Cc: emacs-devel@gnu.org To: Eric Abrahamsen Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 22:56:16 2021 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muLy3-0007wd-M8 for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 22:56:15 +0100 Original-Received: from localhost ([::1]:33428 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muLy0-00035P-AK for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 16:56:12 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:56836) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muLwt-0002Ox-Hq for emacs-devel@gnu.org; Mon, 06 Dec 2021 16:55:03 -0500 Original-Received: from [2607:f8b0:4864:20::429] (port=39431 helo=mail-pf1-x429.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1muLwr-0008F8-RG for emacs-devel@gnu.org; Mon, 06 Dec 2021 16:55:03 -0500 Original-Received: by mail-pf1-x429.google.com with SMTP id i12so11424215pfd.6 for ; Mon, 06 Dec 2021 13:55:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=Jn1NuKWkUck6+DGTMOYDm6rTek6QtqofMDfw/pmombo=; b=OosOppOxAfQ+0Mu3bEB2fEtvWnnEnPL1VEnbqXJ70c8kO+XyZ05xrX6GbdyWVTkLyq +ZUVGDTHk0v6996tnqiHCN3ParWOt9fGLCjR4PecyiHDF4reTRxlDAk3oq7bouz1B90E Gz/KZKjZtTpMa0vnBale15fRjbwfq6zkuJPbE/gpfSnK2uciTwCxxKOz3bYI60By2NUC LbnQG0OOikebITHqszct1jn8AQbySlMl3JQT/9HkINpLhDPrMx2GKoBOI5utUuGwp4KQ 9VGHvu7Ol8zfhZWBM7QAbnJQJENYO+AD7aHoG43k+/JIsJEqrUIbkgA4Mjb6y0GK4qiC lTkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=Jn1NuKWkUck6+DGTMOYDm6rTek6QtqofMDfw/pmombo=; b=bty3G+4BCl7J5a2L9gVFzftun+DWvshUI5cZb9TB1h5sW0WRKSpDZnR08oI2yDtqx+ hjKO2eRVAsnEakh789GyvYfKvJWaVV65Kjqnk3XiGsATh2mKtAqwFcLWyT2HDbLsimC7 coIIPxQjVx29ulqAvBrys3kp3P7aW5ylbcSUbC9fumhKWVfQMeVRP1+aBAzdtSwySue6 mN16x/f31kJdHgHO+L+bxt0BRMscQiEuh4EbaDiDhWYYattEkzYuxefzFosloeAQO2tB fOxuoA7g1FsKF04iNM/fQbcjoEopDexWyksCAQxPNnzKfWqqCeg8sq96S60nesjU0Ijs HK3A== X-Gm-Message-State: AOAM531FVpaco0bK8NN6Few5ogDfKN5SnfkPelkxqljPiyS+Z8XiIYbG 8LUi6jUZPYbguKXrcUXDDp47/64Ky1Q= X-Google-Smtp-Source: ABdhPJwhegyP7433+BUD2rD8AMdhhtuV2My7LubZKu1rLeqOjZrED21JfonWg+IIuEvrDLE6T1muMg== X-Received: by 2002:a63:5954:: with SMTP id j20mr20575652pgm.365.1638827700160; Mon, 06 Dec 2021 13:55:00 -0800 (PST) Original-Received: from [127.0.1.1] ([216.9.31.180]) by smtp.gmail.com with ESMTPSA id cv1sm296909pjb.48.2021.12.06.13.54.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Dec 2021 13:54:59 -0800 (PST) In-Reply-To: <87bl1tct4c.fsf@ericabrahamsen.net> (Eric Abrahamsen's message of "Mon, 06 Dec 2021 13:37:23 -0800") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::429 (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::429; envelope-from=cesar.mena@gmail.com; helo=mail-pf1-x429.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 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, PDS_HP_HELO_NORDNS=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:281183 Archived-At: Eric Abrahamsen writes: > cesar mena writes: > >> Eric Abrahamsen writes: >> >>> Lars Ingebrigtsen writes: >>> >>>> Eric Abrahamsen writes: >>>> >>>>> Well, Lars is the Gnus maintainer, not me, so all I can do is propose! >>>>> But yes I am, though only for group marks. Right now .newsrc.eld >>>>> combines concerns: it saves variables such as `gnus-server-alist' and >>>>> all the topic stuff that would be better saved as customization options >>>>> (or saved in a separate file, using the customization machinery). It >>>>> also saves group parameters, right next to the marks. >> >> Yes, it's a bit of a big hammer. >> >>>> It's a bit much, but I don't think those bits can be usefully separated >>>> out. But things like `gnus-save-duplicate-list' (which goes to a >>>> separate, ad-hoc file) would fit well as a simple persistent variable. >>> >>> If `gnus-newsrc-alist' were saved as-is, but *without* the mark data, >>> that mark data could be pulled out of a separate storage backend at >>> startup time, with a simple group-name->mark-data mapping. The >>> .newsrc.eld file could otherwise remain the same. >> >> One can edit flags through G p in the topic buffer; that interface would >> need to be preserved. Who knows what other secrets lurk in there. > > My proposal would only affect the save and load routines (zip and unzip > data), in-session behavior wouldn't change. Yes, but there are so many little details that would prop up (I think). Like what happens if you couldn't load the marks for one of my 2k (I exaggerate ... slightly) groups? Would you turn off expiry to prevent the deletion of dormant articles? etc ... >>> But Qiantan's message reminded me that this proposal is actually a Gnus >>> issue, not a sqlite issue, and shouldn't clog up this thread. I'll keep >>> this for later! >> >> Yes, but in the end separating flags from .newsrc.eld is not for the >> faint of heart, and I am not sure I see the benefits. >> >> Like you said, for later. > > I have any number of pie-in-the-sky ideas for Gnus. If I get around to > implementing half of them, I'll consider it a success :) You're doing the lord's work. I appreciate it :) Cheers!