From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Stefan Monnier Newsgroups: gmane.emacs.devel Subject: Re: persistent data feature Date: Fri, 10 Dec 2021 15:02:32 -0500 Message-ID: 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> <87r1aphuei.fsf@gnus.org> <837dcex6ub.fsf@gnu.org> <87bl1p10js.fsf@gnus.org> <87a6h8y5j6.fsf@gnus.org> <87fsr0gssu.fsf@rfc20.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="5981"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: Lars Ingebrigtsen , Richard Stallman , eric@ericabrahamsen.net, cesar.mena@gmail.com, eliz@gnu.org, Pip Cet , emacs-devel@gnu.org To: Matt Armstrong Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Fri Dec 10 21:03:53 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 1mvm7V-0001ML-4P for ged-emacs-devel@m.gmane-mx.org; Fri, 10 Dec 2021 21:03:53 +0100 Original-Received: from localhost ([::1]:35226 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvm7U-00056F-2V for ged-emacs-devel@m.gmane-mx.org; Fri, 10 Dec 2021 15:03:52 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:54506) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvm6b-0004M4-VU for emacs-devel@gnu.org; Fri, 10 Dec 2021 15:02:57 -0500 Original-Received: from mailscanner.iro.umontreal.ca ([132.204.25.50]:18063) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvm6Y-0005o5-Gh; Fri, 10 Dec 2021 15:02:57 -0500 Original-Received: from pmg2.iro.umontreal.ca (localhost.localdomain [127.0.0.1]) by pmg2.iro.umontreal.ca (Proxmox) with ESMTP id 47FE5801F2; Fri, 10 Dec 2021 15:02:40 -0500 (EST) Original-Received: from mail01.iro.umontreal.ca (unknown [172.31.2.1]) by pmg2.iro.umontreal.ca (Proxmox) with ESMTP id BDF2980365; Fri, 10 Dec 2021 15:02:38 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=iro.umontreal.ca; s=mail; t=1639166558; bh=qaBIdDWoZah5TLOlx3a4rf3pUHzRA/NpfBP8ydn6nxc=; h=From:To:Cc:Subject:References:Date:In-Reply-To:From; b=BCqmfZIJN00ZPqOYwbwzz0FLVAZUvO/gBjWrdiV6/KpYF3CeMtZS6Fm4ozrqTQ5Ns N7GolygJbCoFU+WSHxLQObauzRgLioXst2ditF2tGEMfpRifnPNCre4hf5E+9c3ABt DZ37YoYT3ps26ASpKbOXCfhhT1IIZHEmEPCkpKxWbF3cDN2wGIp8KeRyOdDhXENsMJ bJtfg1WjG/lXWYADgpHZCNnat/b3Jl/6dcNIPR5DAqWi79lERChWzeVCUlvNp9dOar lKqdfkxn+ECN2Z/k5cOGV38Rt4mHBeD8BBVYkvAJNEK5MY3CWLC165j59Y2/iA6En2 IxcHXsBXdg9aA== Original-Received: from ceviche (modemcable085.122-83-70.mc.videotron.ca [70.83.122.85]) by mail01.iro.umontreal.ca (Postfix) with ESMTPSA id 49E3212091C; Fri, 10 Dec 2021 15:02:38 -0500 (EST) In-Reply-To: <87fsr0gssu.fsf@rfc20.org> (Matt Armstrong's message of "Fri, 10 Dec 2021 11:32:01 -0800") Received-SPF: pass client-ip=132.204.25.50; envelope-from=monnier@iro.umontreal.ca; helo=mailscanner.iro.umontreal.ca X-Spam_score_int: -42 X-Spam_score: -4.3 X-Spam_bar: ---- X-Spam_report: (-4.3 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_MED=-2.3, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham 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:281620 Archived-At: > Another example is Org Roam (https://www.orgroam.com/), which uses > sqlite to manage its index of Org metadata. Could you give details? I don't know what is Org-roam (and the above web-page describes it in terms that don't speak to me very much). What does it store in the database? Why did it choose to use sqlite rather than plain text (e.g. simple personal preference on the part of the author, or was a text file tried at first but proved too inefficient, if so which part)? What kind of database size is common? Stefan