From mboxrd@z Thu Jan 1 00:00:00 1970 From: jemarch@gnu.org (Jose E. Marchesi) Subject: Re: [OT] recutils Date: Sun, 05 Dec 2010 21:20:37 +0100 Message-ID: <87y684vune.fsf@gnu.org> References: <874oauh7zq.fsf@gnu.org> <87vd39yb60.fsf@gnu.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from [140.186.70.92] (port=51252 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PPLA1-0006m1-Bk for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 15:26:18 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PPLA0-0002Q4-AU for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 15:26:17 -0500 Received: from fencepost.gnu.org ([140.186.70.10]:40357) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PPLA0-0002Q0-8r for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 15:26:16 -0500 In-Reply-To: (Michael Brand's message of "Sun, 5 Dec 2010 19:59:56 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Michael Brand Cc: emacs-orgmode@gnu.org On Sat, Dec 4, 2010 at 13:28, Jose E. Marchesi wrote: > But note that the "relational" characteristics in > recutils are not very sophisticated. > > The rule here is: if you need something more complex then you probably > should be using a real relational dbms instead :) Ok, maybe I expected a bit too much for the initial version 1.0. But is it already possible or planned to allow recsel deliver field values from two tables, joined together with a foreign key or what does the manual mean with "the ability of records to refer to other records (sort of foreign keys)"? Right now the recutils use the information of the "foreign keys" (compound fields) just to pick the type of the field in the "referenced" record descriptor. For the next version it is planned to support joins in recsel. For example, having a database like: %rec: Hacker %key: Name Name: Mr. foo %rec: Package Name: GNU foo Hacker:Name: Mr. foo Name: GNU bar Hacker:Name: Mr. foo It will be possible to invoke recsel like: $ recsel -t Hacker -p Name,Package:Name foo.rec Name: Mr. Foobar Package:Name: GNU foo Name: Mr. Foobar Package:Name: GNU bar -- Jose E. Marchesi jemarch@gnu.org GNU Project http://www.gnu.org