From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 14 Feb 2022 15:21:26 +0300 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> <87zgpdhw4d.fsf@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="40573"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.2.0 (2022-02-12) Cc: Po Lu , eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org To: Richard Stallman Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Feb 14 13:41:56 2022 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 1nJafz-000AIE-TA for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 13:41:55 +0100 Original-Received: from localhost ([::1]:50926 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nJafy-0004yY-13 for ged-emacs-devel@m.gmane-mx.org; Mon, 14 Feb 2022 07:41:54 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:45924) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaPU-0008Dl-PA for emacs-devel@gnu.org; Mon, 14 Feb 2022 07:24:55 -0500 Original-Received: from stw1.rcdrun.com ([217.170.207.13]:45025) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nJaPK-0002H3-PF; Mon, 14 Feb 2022 07:24:44 -0500 Original-Received: from localhost ([::ffff:41.75.189.127]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 0000000000055D61.00000000620A4A07.00006F26; Mon, 14 Feb 2022 05:24:38 -0700 Mail-Followup-To: Richard Stallman , Po Lu , eric@ericabrahamsen.net, cesar.mena@gmail.com, emacs-devel@gnu.org Content-Disposition: inline In-Reply-To: Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, FILL_THIS_FORM=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 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:286256 Archived-At: * Richard Stallman [2021-12-08 07:36]: > Whatever we do, we need to have a simple and convenient user interface > for the user to browse all these records and edit them. If this works > conveniently enough, maybe it could replace the Customize buffer. That is feasible to make. It could replace all of the customize. But one does need SQL database for that, not just key/value database such as GDBM. But I vouch to have GDBM and other DBM-like databases equally accessible straight from Emacs and Emacs Lisp. I am editing entries in the PostgreSQL database by using Emacs module to access PostgreSQL, by using tabulated-list-mode, and here is the text of one such entry. ID 319284 Date created "2020-04-03 14:47:16.320089+03" Date modified "2021-07-03 00:48:07.059307+03" Prefix "Dr." First name "Richard" Middle names "Matthew" Last name "Stallman" Suffix nil Account "GNU.org" Company nil Member of nil Lead source "Web site" Title nil Department nil Birthdate nil Reports to nil Do not call nil Invalid e-mail (1) nil Invalid e-mail (2) nil Invalid e-mail (3) nil Office phone nil Mobile phone nil Home phone nil Other phone nil Fax nil E-mail (1) "rms@example.org" E-mail (2) nil E-mail (3) nil Website nil Other website nil Other contact nil Contact type 1 nil Other contact 2 nil Contact type 2 nil Other contact 3 nil Contact type 3 nil Primary address nil Primary city nil Primary postal code nil Primary state nil Primary country "UNITED STATES" Other address nil Other city nil Other postal code nil Other state nil Other country nil Description nil Modified by username "wod" Created by username "wod" Introduced by "Jean Louis" Obsolete emails nil Obsolete phone numbers nil Other names nil Tokens "'gnu.org':5 'matthew':2 'richard':1 'rms@example.org':4 'stallman':3 'state':7 'unit':6" Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/