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.help Subject: Re: Designing people and organization management for Emacs Date: Fri, 4 Dec 2020 16:38:40 +0300 Message-ID: References: <87zh2tdhdl.fsf@ucl.ac.uk> 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="33190"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mutt/2.0 (3d08634) (2020-11-07) Cc: help-gnu-emacs@gnu.org To: Eric S Fraga Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Dec 04 14:40:32 2020 Return-path: Envelope-to: geh-help-gnu-emacs@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 1klBK4-0008YR-Nn for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 14:40:32 +0100 Original-Received: from localhost ([::1]:46378 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1klBK3-0008Hi-Pi for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 08:40:31 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:41494) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1klBJI-0008GC-M1 for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 08:39:44 -0500 Original-Received: from static.rcdrun.com ([95.85.24.50]:33259) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1klBJF-0005Be-1r for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 08:39:43 -0500 Original-Received: from localhost ([::ffff:197.157.0.57]) (AUTH: PLAIN admin, TLS: TLS1.2,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by static.rcdrun.com with ESMTPSA id 00000000002C0006.000000005FCA3C1A.000050C4; Fri, 04 Dec 2020 13:39:38 +0000 Content-Disposition: inline In-Reply-To: <87zh2tdhdl.fsf@ucl.ac.uk> Received-SPF: pass client-ip=95.85.24.50; envelope-from=bugs@gnu.support; helo=static.rcdrun.com X-Spam_score_int: 14 X-Spam_score: 1.4 X-Spam_bar: + X-Spam_report: (1.4 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_SBL_CSS=3.335, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.io gmane.emacs.help:125974 Archived-At: * Eric S Fraga [2020-12-04 12:57]: > Some people use org-contacts (can be found in the org contrib package) > for this. I use bbdb. Yes. I was using text files and spreadsheets, bbdb. Before many years I switched to database backed management of any data that is structured. And no, org-contacts or BBDB cannot replace the power of SQL databases. 204111 contacts are in my database each available at few key presses related. Contacts are related to "products", BBDB without much development cannot provide easy relation to products. Related to "calls" where none of available Emacs software can initiate calls or handle a call center with track record when each customer have been called and why. This is trivial with SQL. Relation to "cashaccounts" to track financial transaction of each person. Or relation to "comments" to track who commented on which other piece of information in a database based Emacs. Or "contactskills" that one can make list of related to recruitment and hiring of staff. Or "emails", where each email can be related to contact ID and vice versa. Which "identity" belongs to which contact? People use private and business identities and integration of such is not easy. Sometimes by error email is sent from private identity to business. "locations" are related to people, there are places we record by using GPS and waypoints that have to be remembered, "mailings" are sent to people and have to be remembered which person received which email as not to repeat it. Then "notes", "opportunities", "relations" to other people, "reminders", "invoices", "sms" and so on. Many things may be rapidly developed in Emacs with database backing. Database backed people and information management is extremely useful. I wish Emacs would have at least GDBM built in. Module will come to GNU ELPA soon for PostgreSQL. Developers of it need help on how to include it. When data is in the database it can be easily backed up, shared, replicated in real time, multi user collaboration is built-in. Groups of people may enter contacts, organizations, notes, tasks, manage projects together, and work on separate distant computers while collaborating on same database information. Much programming becomes redundant or easy peasy as database has so many features very easy to implement. Jean