Emacs carnival: rec mode, an all-text database system

One of the key features of Emacs is that everything is just text.¹ An example of this is rec mode.² Rec mode implements a simple yet flexible database system using just text files. Accompanying rec mode, the Emacs code, is the package that includes the tools for manipulating files containing rec databases. On Debian, the package is recutils.

Entries in a rec file are defined by fields and their content. A single file will contain all the records in your database. Each record is separated from other records by a blank line. Beyond this, there is no imposed structure. For instance, each record may have different fields defined.

I use rec mode to keep track of my books. Although I do use calibre to manage my ebooks, in particular, I do not like interacting with calibre as it is mouse based.³ I have a separate rec database which tracks which books I have acquired, am reading, have finished, or wish to buy. A couple of typical entries look like this:

title: Safe Enough
author: Lee Child
status: finished
Date: 2024-08-29
# collection of short stories, none about Reacher

title: All systems red
author: Martha Wells
series: murderbot
number: 1
status: finished
Date: 2017-05-02
notes: library

Note that these two entries, although both referring to books, have different fields used.

As I'm writing about Emacs, the obvious question is: does org mode support rec files? The answer, as with all things Emacs, is "of course it does". With a src block:

#+begin_src rec :data my_books.rec
  author = 'Martha Wells'
#+end_src

the outcome on evaluating is the following table:

The best thing about rec mode is, to repeat myself, that it's all text. There is no danger of corrupting a database or, at least, if somehow the database becomes corrupt, it should be easy to fix (using Emacs, of course). Being all text means that version control is trivially supported, which brings me to the final comments below.

When writing this blog post, I spent some time thinking about which one feature was most underappreciated and I decided on rec mode, as you have read above. However, closely behind was vc mode. Many people talk about some of the killer features of Emacs, mentioning org mode and magit. These are both excellent packages and I use them both myself. However, I only use magit every now and again, relying on vc mode instead for day to day version control. Almost everything I need to do in terms of version control is supported by vc mode and, more importantly for me, vc mode is agnostic with respect to the actual version control system used. I do use git but I also use mercurial and src. The latter is particularly nice for single file projects.

You can find me on Mastodon or you can email me should you wish to comment on this entry or the whole blog.