From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id SNxVHCKuRGNjFgAAbAwnHQ (envelope-from ) for ; Tue, 11 Oct 2022 01:43:30 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id 8IRfHCKuRGPdcwEA9RJhRA (envelope-from ) for ; Tue, 11 Oct 2022 01:43:30 +0200 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 0431BD2EE for ; Tue, 11 Oct 2022 01:43:30 +0200 (CEST) Received: from localhost ([::1]:55476 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oi2Qj-0006xZ-53 for larch@yhetil.org; Mon, 10 Oct 2022 19:43:29 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:33456) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oi2Mz-0003ZN-VY for emacs-orgmode@gnu.org; Mon, 10 Oct 2022 19:39:38 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:44111) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oi2Mx-0007f4-Vf for emacs-orgmode@gnu.org; Mon, 10 Oct 2022 19:39:37 -0400 Received: from localhost ([::ffff:154.227.225.142]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000BBD16.000000006344AD37.000065EE; Mon, 10 Oct 2022 16:39:35 -0700 Date: Tue, 11 Oct 2022 02:32:42 +0300 From: Jean Louis To: rswgnu@gmail.com Cc: Quiliro =?utf-8?B?T3Jkw7PDsWV6?= , emacs-orgmode Subject: Re: SQLite for contacts and relations to Org - Re: contact management in emacs Message-ID: Mail-Followup-To: rswgnu@gmail.com, Quiliro =?utf-8?B?T3Jkw7PDsWV6?= , emacs-orgmode References: <87lfb9bwff.fsf@m4x.org> <090c6ca8-62e1-edcd-d348-688281c4840d@univ-rouen.fr> <2f7144aa5baf5c9285d0e107df0445a0@riseup.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) 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, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1665445410; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=Hx0jWFOLa/LTxcjYGN7a3pyGFxY9aKGLLeXLzrdxMRs=; b=TSA8a2eed9fBHCkcwb8qAbxaHgHXui72lhbauNs55xj3iPgmYXZz2IiBSSIyYCJFdenBny nZ6x8BAgZr8ZiJmNTi7sHiPfokwb21cn0oyv5RSlr0+v9hqqoqsKFf42UOdPWfrOFYkjt8 30ywwle5f0ZQTt0A66fXDc2ckvvPVPe00J2GlIr/P+VNiUbsYgY8fv9j5o+6DJdDHzxM/G n8UbIMM6AUqMv2U59e2X4ohEJmjplNzqJ1siTqshGi/3t/il67cINlenGlg1kE6ol09Eo3 PkPbCxA8zLySQrvNHXuEUY9EfwUzqz457uxSzFQ00TCZRLscg+ZvHw1ONCy59A== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1665445410; a=rsa-sha256; cv=none; b=qgq18F3Tss9N2XCk2KHLbticSy3/1882bzLcmvajqdiLDUuNKf5NK+ni+l/qmh+gr80pzo AAKkWJTRNaP/n0I7Ou715BoonkIr9f6YOYlP6FxpAnw78D5wk3BQenUKXVzXhNCXRN2v0u NCyYaH6RpXsnkeIoj6HBwe6leDCeu1lh0nWG/IJocW/LHMHHO77M0SXnFhHRsB9NXjE74X v5tRD+09awINBIAt2uHpyUggcnpoOm/Fal4bqHKckkhnQrChq5zvNOx0HiqtM7Ij4TNuHp Whgtp6nmgeo7ImOXaXU3tpZHEciKUQmEm4YTBOiGzySR9fi/PlT9JAZH8TSu7w== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -2.19 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 0431BD2EE X-Spam-Score: -2.19 X-Migadu-Scanner: scn1.migadu.com X-TUID: 0WecZjpZ47CZ * Robert Weiner [2022-10-11 01:31]: > 1. Although I understand you do a great many things with your > database-backed Hyperscope system and I work with RDBMSes every day, I > don't really see great value in what you have shown in the context of > contact management when compared to the already existing HyRolo or > org-contacts. We can easily add, delete, import and export contacts, we > just follow very simple conventions in creating our contacts. We can > easily email contact files and have people apply text processing tools to > them, so it would help if you just showed examples of something that Emacs > really lacks before suggesting wrapping everything into a database system, > as I know you are a very smart guy. For org-contacts, I have nothing to say, as that is as limited as it can be. When anyway structured information such as people names, properties, their communication lines, addresses are in the separate database like SQLite, that fact liberates information from single software like HyRolo, and allows users to access, process information freely with any programming languages and plethora of variety of tools for inspection, analysis, exports, and sharing of such information. For HyRolo, that is text. One cannot build upon it. I am constantly sending SMS from Emacs and importing SMS from mobile phones to contacts. When I send SMS I want to see which SMS was sent and received by which contact at what time, by which phone number. It is something not imaginable with text files. Similar is with information sent to people, how am I supposed to know what information I have sent, what not. There is no automated tracking in text files like HyRolo. It is one example among way too many. Adding properties to people, objects, it is much easier by using selection that one can click onto, or use arrows, or just C-p for previous one. Rather that, then writing with hand each time, error prone, some skills of people in order to find people by skills. Skill like "C programmer" I would need to add too many times and then use find by regexp. All good and find, but not scalable. Of course that I have use text files long ago to store contacts, but that was 28 years ago. I have now 240106 entries of people and their groups. Unspoken of marketing campaign, imagine when I paid $73 and got in 23 hours 1200+ leads for recruitment in specific sector. How would I enter them in HyRolo? Automate some web server program to add them in similar fashion like Org heading. It could work. But then how could I send to those people in ordered fashion series of 3-10 training emails that automates the process of recruitment and selection? Would HyRolo help me track who received what at what time? There is no foundation for such features in text files. > 2. Years ago as part of my stab at an Emacs-based IDE, InfoDock (find it on > Sourceforge), Is it this one? https://sourceforge.net/projects/infodock/ I cannot see how to start anything with it. Do you have screenshots? > I also wrote an in-memory, file-based but fully relational database. > The main point of which was to demonstrate direct manipulation > querying of relational tables via simple mouse clicks/key presses on > screen. For simple queries, I found this very powerful and dirt > simple for people to do. If that were of interest, someone could > take the existing code under infodock/id-lisp/rdb and interface it > to SQLite pretty easily I would expect and then you would have an > interesting Emacs interface without having to master SQL for basic > table analysis. Is it this one? lib/infodock-4.0.8/i486-pc-sysv5/ lib/infodock-4.0.8/i486-pc-sysv5/make-path lib/infodock-4.0.8/i486-pc-sysv5/wakeup lib/infodock-4.0.8/i486-pc-sysv5/profile lib/infodock-4.0.8/i486-pc-sysv5/make-docfile lib/infodock-4.0.8/i486-pc-sysv5/digest-doc lib/infodock-4.0.8/i486-pc-sysv5/sorted-doc lib/infodock-4.0.8/i486-pc-sysv5/movemail lib/infodock-4.0.8/i486-pc-sysv5/cvtmail lib/infodock-4.0.8/i486-pc-sysv5/fakemail lib/infodock-4.0.8/i486-pc-sysv5/yow lib/infodock-4.0.8/i486-pc-sysv5/hexl lib/infodock-4.0.8/i486-pc-sysv5/gnuserv lib/infodock-4.0.8/i486-pc-sysv5/mmencode lib/infodock-4.0.8/i486-pc-sysv5/rcs2log lib/infodock-4.0.8/i486-pc-sysv5/vcdiff lib/infodock-4.0.8/i486-pc-sysv5/gzip-el.sh lib/infodock-4.0.8/i486-pc-sysv5/add-big-package.sh lib/infodock-4.0.8/i486-pc-sysv5/config.values lib/infodock-4.0.8/i486-pc-sysv5/DOC bin/i386-intel-sco7/ bin/i386-intel-sco7/etags bin/i386-intel-sco7/ctags bin/i386-intel-sco7/b2m bin/i386-intel-sco7/gnuclient bin/i386-intel-sco7/ootags bin/i386-intel-sco7/rcs-checkin bin/i386-intel-sco7/pstogif bin/i386-intel-sco7/gnudoit bin/i386-intel-sco7/gnuattach bin/i386-intel-sco7/infodock-4.0.8 bin/i386-intel-sco7/infodock --> infodock-4.0.8 -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/