From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Christopher Dimech Newsgroups: gmane.emacs.help Subject: Re: Designing people and organization management for Emacs Date: Fri, 4 Dec 2020 17:42:22 +0100 Message-ID: References: <87zh2tdhdl.fsf@ucl.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="33799"; mail-complaints-to="usenet@ciao.gmane.io" Cc: help-gnu-emacs@gnu.org To: Jean Louis Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Dec 04 18:01:47 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 1klESn-0008dq-4a for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 18:01:45 +0100 Original-Received: from localhost ([::1]:33196 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1klESh-0000l5-MH for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 04 Dec 2020 12:01:39 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:54620) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1klENv-0000it-4k for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 11:56:43 -0500 Original-Received: from mout.gmx.net ([212.227.17.20]:49221) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1klENt-0002Uh-1Y for help-gnu-emacs@gnu.org; Fri, 04 Dec 2020 11:56:42 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1607100998; bh=pui6CfZJyNxWH1IHW/lh9ddZg8dTp+dmNh5M/B8/vKk=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=B/mss4XJG5c8VQBoc+lB5xTFxfPs+h4fauDOxbzb0MmrWFe1dmkFyXtN0hvnsfOKF 1YDK6wa20m3ByjIVCy2ycZjHTY1sYsIjHN0hPJ8fa9AIxUCIJceCqMdzeevhnrIGR7 gECktpMnp0HQUWG5Crxzulr9czVxqGQLdOnwwtxc= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Original-Received: from [213.165.168.94] ([213.165.168.94]) by web-mail.gmx.net (3c-app-mailcom-bs11.server.lan [172.19.170.179]) (via HTTP); Fri, 4 Dec 2020 17:42:22 +0100 Importance: normal Sensitivity: Normal In-Reply-To: X-UI-Message-Type: mail X-Priority: 3 X-Provags-ID: V03:K1:m4K03aVVYx21aIrzZ5rLbdTu2zfOIqfUnE9N1hzkY978jpCkoFUzHFQ+Z9bZzi88VR0mM 7HNQVMXVXkqsesr8MyFUDKfPsJG9e9e/osf9LoUfKZEoQzx25RNK89xt3lZ7/Qzvb1wXoG4DrrRR lHjAMuT+vgIEE61hPlK+OwoYPBlPj4rkAIOyh1B7b3tqtWCpoapEVrbYKWjE3u50GC9ds221j9bg tfOuMw0ze2AgHUytls054zY4z7JgGaWqCfB2PQYta/Q3ZowWT/DEC/UH+sNlvgr/1kNV1oUDdEfO vo= X-UI-Out-Filterresults: notjunk:1;V03:K0:HDqfcpHGTb4=:Q24QhFsBZucTkDSc5N5KHr vvXd2RFQTGvthOGrCzgDc9Q5oQEtD5JmD+TExSUFQSaTe3feCZ0C3GllNv7vWfbgJyiGYFBOo YSspVFO38zgHTGcOqvwZSWmB2FStypWOCCctKf04BacwnEtNdtQULqZoThMOxOrP+5U+7Wxmu 8L9rJ+I8Ulg1GK3a5t4R9MIAAxE0rh7kndF4w26xabBBlxW9F9Hdk3xfoeVZ0hi5HyLjcFQIu RejVbBa+/UqAcqFooBBBuu4PPVcfKnzRuk3+J+A0RtqsfrXp7+j1eZs/sBoMDxwI+yv3kkkBv g9TsRRCYJl/q9xbnPRyuvoq/1H2wlt/Up1B4zObTiUHPJuW8hpl3bsJ1vOx9k4z+nesAxNcDr Xlj4O3gRh6II1b6EWghKt75p2eGqfUwUOOvJUo9nq5AVzjzM03zQFJqWojztgX0Bi8LwRJ2Ek XzNGzMn56GhdSPNjwOA0pP4L9zyUCu1ijYaRV1Fs3ja/tHpyXz+O8JLCS+MWnk6zFouh16xCo R5sUMw/u2H+LRfpSmz0uqkRGDfJU0dJBbdkoQ3qNly4BqLc/a3rC4ssfKVKARfKDPU+J3+A/c UF3MNLlGx89Ho= Received-SPF: pass client-ip=212.227.17.20; envelope-from=dimech@gmx.com; helo=mout.gmx.net X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham 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:125979 Archived-At: > Sent: Friday, December 04, 2020 at 5:26 PM > From: "Jean Louis" > To: "Christopher Dimech" > Cc: help-gnu-emacs@gnu.org, "Eric S Fraga" > Subject: Re: Designing people and organization management for Emacs > > * Christopher Dimech [2020-12-04 19:12]: > > > Model is designed based on data to enter in the future. If data > > > changes in the future it is very easy to change the model. Good > > > example with my experience is that few people that I know over long > > > span of years changed their email addresses multiple times. But I do > > > like to have capability to keep those obsolete email addresses as th= ey > > > are still related to the person and emails of the person. By using > > > person's ID I can quickly access all email files. But if I have only= 3 > > > fields for email addresses I have no space for 4th and 5th field. > > > > I meant, could users be able to set their own models? > > Users can always design their database tables or models. > > In relation to this project "people" I am now polishing the table > unless there are no comments in the way how I think is best. Then > users can adapt table if they wish to or make their own functions to > enhance. Would need some useful description of making new tables and some functions that would help users do that. At least spare them some of the process. > Let us say there table has: > > people_firstname > people_middlenames > people_lastname > > For myself only lastname is required, and there can be anything like > even email address, as some people are unknown. It can be > 'Unknown'. In some countries people must have first name, maybe > somebody wish to make it obligatory so they can impose that on the > database level and on the Emacs Lisp level. > > Let us say somebody does not want to use those columns at all but just > one column, that person can add it: > > ALTER TABLE people ADD COLUMN people_name TEXT; > > and then other columns need not be used. > > But my system is enough general that will allow designing any table > and then editing such table. The minimum requirement would be to keep > for every table _id like people_id with unique number. > > First we have to have good contacts management that is upgradable with > other tables. > > Jean > >