From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jean Louis Subject: Re: exported contacts problem Date: Fri, 2 Aug 2019 23:34:21 +0200 Message-ID: <20190802213421.GZ17561@protected.rcdrun.com> References: <20190802160236.GR17561@protected.rcdrun.com> <87mugrb7fi.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:48088) by lists.gnu.org with esmtp (Exim 4.86_2) (envelope-from ) id 1htfBz-0005fZ-PG for emacs-orgmode@gnu.org; Fri, 02 Aug 2019 17:34:28 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1htfBx-0005u4-Vt for emacs-orgmode@gnu.org; Fri, 02 Aug 2019 17:34:27 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:51021) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1htfBx-0005sV-OJ for emacs-orgmode@gnu.org; Fri, 02 Aug 2019 17:34:25 -0400 Content-Disposition: inline In-Reply-To: <87mugrb7fi.fsf@ericabrahamsen.net> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Eric Abrahamsen Cc: emacs-orgmode@gnu.org * Eric Abrahamsen [2019-08-02 23:11]: > > Neither bbdb nor Org is suitable for any serious collection of > > contacts. I have 192,000+ contacts, and when they are in database and > > I am using PostgreSQL, it gives me most of benefits, I can sort people > > into lists, groups, I can contact them, count interactions, open up > > their files, emails with a fast command, edit their data, add notes, > > send them faxes and SMS, maintain relations. > > That sounds pretty intense. Have you written a separate package for > interacting with the database? I wrote few generic functions and use it with helm, it works for me. It is not ready for public. Web interface works based on Gedafe[1] and then I wrote access to it through console Common Lisp and then also through Emacs Lisp. I am using Emacs module `emacs-libpq'[2] to interact with PostgreSQL. Let's say I am looking for somebody, Hyper-C asks me for query, I enter something, then I can choose to open Org file relating to the person. When dealing with various companies, things related to a company shall be in the directory related to company. Things related to person, for example assignments related to one person shall be in the file belonging to that person. That way full file can be sent to the person for review, it becomes clear what has been done, and what is yet to be done. Mixing assignments, TODO, agendas from all subjects, groups and persons into one file would give me terrible confusion. Jean Footnotes: [1] https://gedafe.github.io/index.en.html [2] https://github.com/anse1/emacs-libpq#start-of-content