From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: "Jose E. Marchesi" Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 18:10:56 +0100 Message-ID: <87h7blzmjj.fsf@gnu.org> References: <87tufmjyai.fsf@gnus.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="3672"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Cc: Lars Ingebrigtsen , rms@gnu.org, emacs-devel@gnu.org To: "Alfred M. Szmidt" Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 18:11:44 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 1muHWi-0000mM-9a for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 18:11:44 +0100 Original-Received: from localhost ([::1]:42744 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muHWh-00083y-6e for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 12:11:43 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:40714) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muHWB-0007GZ-1p for emacs-devel@gnu.org; Mon, 06 Dec 2021 12:11:11 -0500 Original-Received: from [2001:470:142:3::e] (port=60650 helo=fencepost.gnu.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muHWA-0001Z5-NU; Mon, 06 Dec 2021 12:11:10 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-Version:In-Reply-To:Date:References:Subject:To: From; bh=oRWSU9YIjvplbnhHP2zww0gdhN1DFBcoOIlTFEa+sl0=; b=UROnFDPaoA6lgeKe5xa8 ygpGyc50uw3oS8K11siQ37uCsuXRfs4rySooiqzDoEySGYXhS2t3rw2ArnQ0E5FUeV2uOGoYFiZzx aCOvRvwWxFfBw9bmN9cjGBPW0hpSgXLplQP+M0dpmKTFU6MpJlV7AogFxZS89X7XcIcO4xgRHjRxC ucWWXbkEm+P3UfU+t966i8Ki7ik/dDzSxG30DT64+CC4yj6gvcauRepisZiQylV/D6O+1sTdofeKj k9FQ6c9aRKudbBSindia4pKuQEWja+kc8zy2Jy+o/wDVXvSPRpsIY4dPZ8fDf9ngd0mOuxWXJBplY fAhjaEU+lMx6Rg==; Original-Received: from [141.143.193.68] (port=35770 helo=termi.gnu.org) by fencepost.gnu.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muHW0-0000G7-57; Mon, 06 Dec 2021 12:11:04 -0500 In-Reply-To: (Alfred M. Szmidt's message of "Mon, 06 Dec 2021 03:03:51 -0500") 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:281135 Archived-At: > Before this discussion takes off, one should first take into acount if > it fits adding sqlite to Emacs with the overall guidelines of GNU > Emacs, the GNU project, and the GNU coding standards. > > The sqlite non-license (it says public domain) status might be > problematic, since to get a proper license would require the FSF to > buy one explicitly. Richard or someone would have to check how that > would work out. > > > The main benefit of dbm is that it is standard on all Unix systems, > GNU included while sqlite isn't. There is also GNU GDBM which has > extra features over standard DBM, like data consitency and what nots > and is installed as widley as sqlite on GNU/Linux systems. > > GNU recutils is not as standard, but it is a GNU project and could be > extended in maners that are useful for GNU emacs. The nicest thing > about the recutils format is that it is plain text, and it is fast. > The developers maybe can fill in how well it does on bigger datasets; > adding Jose to CC. What is the purpose of integrating a database sytem in Emacs? To store what kind of data? What amount of data? Do you need to maintain data integrity? Do you need foreign keys? Do you need multi-field keys? The reason I'm asking is because: gdbm is a key-value tuples database. sqlite is a relational database system. GNU recutils is a sort of an hybrid between key-value and relational. And so: gdbm may or may not be what you need in Emacs. sqlite is not a replacement for gdbm. recutils is not a replacement for sqlite. It seems to me that any discussion in which it is raised the alternative of using so disparaged systems such as gdbm, sqlite and recutils for some particular purpose, is in serious need of some clarification on why a database sytem is needed to begin with and the nature of the data to be stored there.