From mboxrd@z Thu Jan 1 00:00:00 1970 From: David Masterson Subject: Re: exported contacts problem Date: Fri, 16 Aug 2019 00:07:39 +0000 Message-ID: References: <20190802160236.GR17561@protected.rcdrun.com> <87mugrb7fi.fsf@ericabrahamsen.net> <20190802213421.GZ17561@protected.rcdrun.com> <875znfaycd.fsf@ericabrahamsen.net> <20190803103340.GN23820@protected.rcdrun.com> <874l2yxnrs.fsf@ericabrahamsen.net> <20190803163219.GZ23820@protected.rcdrun.com> <87pnlmvssp.fsf@ericabrahamsen.net> <8736i3wkhv.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:47607) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1hyPmR-0008NB-Ft for emacs-orgmode@gnu.org; Thu, 15 Aug 2019 20:07:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hyPmP-0007ty-Mq for emacs-orgmode@gnu.org; Thu, 15 Aug 2019 20:07:42 -0400 Received: from mail-oln040092003109.outbound.protection.outlook.com ([40.92.3.109]:55776 helo=NAM02-BL2-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1hyPmP-0007si-D1 for emacs-orgmode@gnu.org; Thu, 15 Aug 2019 20:07:41 -0400 In-Reply-To: <8736i3wkhv.fsf@ericabrahamsen.net> (Eric Abrahamsen's message of "Wed, 14 Aug 2019 13:38:20 -0700") Content-Language: en-US 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 writes: > David Masterson writes: > >> Eric Abrahamsen writes: >> >>> But Org can be an excellent *interface* to those tools, mostly through >>> dynamic blocks. I've started using small sqlite databases to keep track >>> of things, and dynamic blocks as sql composers/views, and it works >>> great. It's very easy to play with the queries, and this is the first >>> time I'm actually starting to feel comfortable with sql. >>> >>> I think in general Org is best used as a compositional tool for data >>> drawn from elsewhere. >> >> What do you think of RDB? It seems to be an old set of Perl scripts >> derived from /rdb (an older set of Unix shell scripts) that can be used >> to do basic relational database commands on textual database tables. If >> it could be translated into an Elisp package, it would fit the Emacs >> model of open source and easily understandable data storage. It can be >> gotten via ftp here: >> >> cdb.netbsd.org/pub/pkgsrc/distfiles/RDB-2.6d.tar.gz > > I've never heard of it! But from your description it kind of sounds like > another attempt to use relational databases without actually using > relational databases :) I guess I think databases are one of those > things you should delegate to an external program. Org is already pretty > good at interfacing with them. The interesting point is that it was originally done as a series of shell scripts (in /rdb) and now is a series of Perl scripts (in RDB) that implement the key features of relational functions using textual tables as a relational database system in the Unix sense. Were I an Elisp expert (which I'm not), each script could probably be translated into Elisp and, rather than pipe from stdin to stdout, it could load the database into an Emacs buffer and then process the result into another buffer. *OR*, since RDB is open source, perhaps an Elisp front-end could be put on it to incorporate it into Org. Just an idea... -- David