From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: John Yates Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 6 Dec 2021 08:48:54 -0500 Message-ID: References: <87tufmjyai.fsf@gnus.org> <875ys2lyt0.fsf@yahoo.com> <87wnkhlxb9.fsf@yahoo.com> <2FD7D920-D92C-480B-B2AC-91A17F0397C4@mit.edu> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="00000000000039d04305d27a854d" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="22069"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Po Lu , "larsi@gnus.org" , Stefan Monnier , Arthur Miller , "emacs-devel@gnu.org" To: Qiantan Hong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 15:14: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 1muElH-0005RZ-7n for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 15:14:35 +0100 Original-Received: from localhost ([::1]:53892 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muElG-0006yd-7M for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 09:14:34 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:40104) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muEMh-0007f7-7F for emacs-devel@gnu.org; Mon, 06 Dec 2021 08:49:11 -0500 Original-Received: from mail-ed1-f45.google.com ([209.85.208.45]:33526) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1muEMf-00074i-24 for emacs-devel@gnu.org; Mon, 06 Dec 2021 08:49:10 -0500 Original-Received: by mail-ed1-f45.google.com with SMTP id t5so43156664edd.0 for ; Mon, 06 Dec 2021 05:49:07 -0800 (PST) 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; bh=c5cUMm9oOKnUaYRcCb0qvzXcpne4CRz7IOawY9nOngs=; b=v9LgmImOU56INFUYXJ8zGYGqmYEHl2E54ysSMYLbxP3sA5NJ4QN6qzrEqOWGuHy7W0 +MPLf/4HQSnoUicpGdGP1Pm2gEjekgRndZhzShVyG7h7BIoWvfuB8ZPIJLZxk4cyT7a8 0jXa/uv9uMieXMwnEF3K9uEY3xYKgHC1RUA1GAoySFY0bEx5r3vCTp7U/eFiglgsDoGr MobgAP/2DuIA9Wx89spVhw+5JMh5uobcOpbderF58rsRTAX2JAYFe9H3DiX3DVtZNCMz gB3dQIPHKuuzYnkJivxQlKEfEGfj85oPzcHxxQAKImcgCXKHEG3mJFR+yZFkxGRfdUJ9 SMWQ== X-Gm-Message-State: AOAM531etMnUCysr/MWx1/FqKQ4Gcaamn/rMU2ddlZE82R1JsLsi6Vp/ 5+M4HjjZpmJulWwu4I+wTKXShSL1M6DV4GPvzvQ= X-Google-Smtp-Source: ABdhPJxYXCestdUTLBpniQMVIq/8GywC+Xrrsb/ZaIsO3URKRvbROvbp76YcJsGA5ZrUqa2Fh1ZSvhRVpljIb8kr5f8= X-Received: by 2002:a05:6402:280b:: with SMTP id h11mr55608917ede.341.1638798546553; Mon, 06 Dec 2021 05:49:06 -0800 (PST) In-Reply-To: <2FD7D920-D92C-480B-B2AC-91A17F0397C4@mit.edu> Received-SPF: pass client-ip=209.85.208.45; envelope-from=john.yates.sheets@gmail.com; helo=mail-ed1-f45.google.com X-Spam_score_int: -13 X-Spam_score: -1.4 X-Spam_bar: - X-Spam_report: (-1.4 / 5.0 requ) BAYES_00=-1.9, FREEMAIL_FORGED_FROMDOMAIN=0.25, FREEMAIL_FROM=0.001, HEADER_FROM_DIFFERENT_DOMAINS=0.249, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, 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:281115 Archived-At: --00000000000039d04305d27a854d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Dec 6, 2021 at 8:03 AM Qiantan Hong wrote: > In fact I think if we can do this we don=E2=80=99t even need (g)dbm, > just storing the log in plain s-exp will be performant enough. > > The detail gets messier. If we have a hash table whose value > is not mutable, we only need to append a log entry every > persistent-puthash. > Potentially relevant, a paper I wrote 8 years ago at a now defunct startup: "Updating large dynamic objects ". /john --00000000000039d04305d27a854d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Dec 6, 2021 at 8:03 AM Qiantan Hong <qhong@mit.edu> wrote:
<= div class=3D"gmail_quote">
In fact I think if we can do this we don=E2=80=99t even need (g)dbm,
just storing the log in plain s-exp will be performant enough.

The detail gets messier. If we have a hash table whose value
is not mutable, we only need to append a log entry every
persistent-puthash.

Potentially relevant,= a paper I wrote 8 years ago at a
now defunct startup: "Updating large dynamic objects".

/john
--00000000000039d04305d27a854d--