From: Michael Brand <michael.ch.brand@gmail.com>
To: "Jose E. Marchesi" <jemarch@gnu.org>
Cc: emacs-orgmode@gnu.org
Subject: Re: [OT] recutils
Date: Sat, 4 Dec 2010 08:17:34 +0100 [thread overview]
Message-ID: <AANLkTin-N-XsP+4bewDe2ZV6YRoVBPqEGSfBSVPEcW2L@mail.gmail.com> (raw)
In-Reply-To: <874oauh7zq.fsf@gnu.org>
On Fri, Dec 3, 2010 at 22:16, Jose E. Marchesi <jemarch@gnu.org> wrote:
> I apologize in advance for the off-topic, but this could be of interest
> to people liking to "organize their life" in plain text. This is about
> "storing your data" in plain text :D
>
> I just made the first release of the GNU recutils, a set of tools and
> libraries to access human-editable, text-based databases called
> recfiles. The data is stored as a sequence of records, each record
> containing an arbitrary number of named fields. Advanced capabilities
> usually found in other data storage systems are supported by GNU
> recutils: data types, data integrity (keys, mandatory fields, etc) as
> well as the ability of records to refer to other records (sort of
> foreign keys). Despite its simplicity, recfiles can be used to store
> medium-sized databases.
>
> I have been using org-mode for years and it rocks. In some way it
> changed my life. It is perfect to store all kind of hierarchical data.
> At some point I though about applying a similar philosophy to
> "sequential" repetitive data with relationships. Data that we would
> store in a relational database. A nice complement to org. The recutils
> are the result of those thoughts.
>
> I would highly appreciate any comment or suggestion on improving the
> format, the utilities, or whatever.
Hi Jose
Wow! The ability to have a _relational_ database with foreign keys in
a simple text file is so great news for me. A dream I had for many
years now. Or is it lack of knowledge from my side about already
existing solutions before recutils? Thank you a lot for your work,
sharing it to the community, posting it also on this list here and for
asking for suggestions which I would like to give at the end.
I was thinking about using sqlite from the command line and together
with shell scripts for stuff like my collection of music with
recordings, MIDI files, scores and so on. Because at least for me
editing a text file is by far simpler, more interactive and more
convenient than editing with SQL I will prefer recutils over sqlite.
But since recfiles, the text files of recutils, are not hierarchically
organized I am still considering to use only Org for the case of my
collection of music. Org would have the advantages of outlining,
hyperlinks, column view, todo, tags, agenda view, export for
publishing and many others.
Thus my wish for the file format would be to somehow keep in mind Org
to potentially
- convert the files bidirectionally between the format of recfiles and
Org, with or without something like "literate programming" of
org-babel
- use recutils as a language extension to org-babel, recutils reading
data streamed to its stdin from org-babel and piping back to into
org-babel result (no writing by recutils to the file)
- as an imagination: run recutils on a file in the format of Org, only
reading or even read/write.
I will follow up with an example of what I plan to do for my
collection of music, the database table relations squeezed
hierarchically into Org as a first attempt.
Michael
next prev parent reply other threads:[~2010-12-04 7:17 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-12-03 21:16 [OT] recutils Jose E. Marchesi
2010-12-04 7:17 ` Michael Brand [this message]
2010-12-04 8:25 ` Russell Adams
2010-12-04 12:30 ` Jose E. Marchesi
2010-12-04 12:28 ` Jose E. Marchesi
2010-12-04 18:50 ` Russell Adams
2010-12-05 18:59 ` Michael Brand
2010-12-05 20:20 ` Jose E. Marchesi
2010-12-13 12:33 ` Jean-Marie Gaillourdet
2010-12-20 18:09 ` Michael Brand
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=AANLkTin-N-XsP+4bewDe2ZV6YRoVBPqEGSfBSVPEcW2L@mail.gmail.com \
--to=michael.ch.brand@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=jemarch@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.