From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Yuri Khan Newsgroups: gmane.emacs.devel Subject: Re: Against sqlite3!!! Date: Wed, 8 Dec 2021 17:00:11 +0700 Message-ID: References: <41E1B5BD-879C-430C-8BA3-3A5354AF2928@mit.edu> <87tufkwga9.fsf@gnu.org> <28E143D2-5C8F-4CDC-B6CE-15F672A00AB1@mit.edu> <87wnkg5fvo.fsf@gnu.org> Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="38125"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Qiantan Hong , Zhu Zihao , Stefan Monnier , Emacs developers To: Tassilo Horn Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Wed Dec 08 11:01:35 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 1mutlU-0009YG-9r for ged-emacs-devel@m.gmane-mx.org; Wed, 08 Dec 2021 11:01:32 +0100 Original-Received: from localhost ([::1]:38836 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mutlT-0005Xd-2U for ged-emacs-devel@m.gmane-mx.org; Wed, 08 Dec 2021 05:01:31 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:54196) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mutkS-00048C-N4 for emacs-devel@gnu.org; Wed, 08 Dec 2021 05:00:32 -0500 Original-Received: from [2607:f8b0:4864:20::92d] (port=47035 helo=mail-ua1-x92d.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mutkQ-0005AL-NT; Wed, 08 Dec 2021 05:00:28 -0500 Original-Received: by mail-ua1-x92d.google.com with SMTP id 30so3625415uag.13; Wed, 08 Dec 2021 02:00:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=MbJ3qvUZ5H0BAExGoflOnqqXjSxhv/OsM5QoUUbgR1k=; b=bGmceQE+cZmDiTejZtFJHQX7xRZviohfdvLy924XSLzF3kB9u3Ehzya+JaVzyAmNBs OcosjfiLN7y2yMKPMyQ/NRsG/m9Qyz/hNV8ZZ2A5cMpj8pdU6+CHcPlB6KCMp7o+WINq uAPoZh9SfKElynxKUq9FhfIdAfdbcwqL8eVwsy5uSjzYFRCH1ABW2tzXN5h6K4JPexk7 AkaFCgkL3DhrCNZIbBwSyr2VCgRP4tX4BH1iPErKFvoknUP0AYwFatWb0vz6X5pqNA6P 84xStgGrq0tVNtx+7Tzdt58hfvNb2G45EsIplo5MtHwBBazUv5/WdOdZ8sU7YicRcU9s Z97A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=MbJ3qvUZ5H0BAExGoflOnqqXjSxhv/OsM5QoUUbgR1k=; b=D6fRlJCWoUSgSk1Gs+FSUOY+JgH+VUrDWfHtTZBkcZuhDB9wQte9bynVfW10anN9c4 L8bvjY4rhOMIccLUAGj9+vuW/Y9O/HhTnQqCExRmw7G6jD1depJaFCVPyZFu5PmUGyEn 5XVGw9yTjB81JGOc0/ueMBqZzsA9dz2BoR3p/oLOxN0sy439zYkaaLComy/zuC0lUGHn CYiu2OyftL+2LZweIVCE2HSUNE1P8AEcoN/wQdIkythFgP+hjJOHT42y6BKFZJl+CWZk +bV7i32fZOMH2DbpWjxraVJROTOF5FIDSeiluLmDWBphjW7XaBU6KZZJqA82JWGUC9pw E+2A== X-Gm-Message-State: AOAM530HFwcUOtNPSukcvnmZjjLzfim92LotxPybY0fQFSCA9a7zBT26 SuVl4UNipEKlXucJX13q3G07IR3ITA1jcVcO4WSMWcwS X-Google-Smtp-Source: ABdhPJzILfTfz0f9oIVopSUW88xkgHSNZJQ6WqUHk+zZq/B/fCyFuq+/SZQyeLszMh7pl2XEIQ31k/OiGL4BtbcoYLM= X-Received: by 2002:a67:31d1:: with SMTP id x200mr49546918vsx.76.1638957624749; Wed, 08 Dec 2021 02:00:24 -0800 (PST) In-Reply-To: <87wnkg5fvo.fsf@gnu.org> X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::92d (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::92d; envelope-from=yurivkhan@gmail.com; helo=mail-ua1-x92d.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:281333 Archived-At: On Wed, 8 Dec 2021 at 03:19, Tassilo Horn wrote: > > There=E2=80=99re various workarounds, lock file being one, but I like t= he idea > > of keeping only one =E2=80=9Ccontroller=E2=80=9D instance with exclusiv= e access to the > > file more. > > Interesting, but how would emacs instances interact with that controller > instance? And would that controller instance simply be the first emacs > instance of a user? What if the controller blocks because Gnus is > running and currently downloading mails with huge attachments? This line of thought, if followed naturally, leads to a dedicated database server process. With multiple concurrent clients, isolation levels, transaction control, etc. And there are better database servers than a special Emacs configuration owning an SQLite database file.