Vol. VII  ·  No. 38  ·  The Autumn Folio Reader-Supported Issue

A Handwritten Journal Called

Pens  ✎  Paper  ✎  Ink  ✎  Letters

A Postage Log in Plain SQL

By Oskar Lindqvist September 17, 2026 The Workbench 1 min read 1,328 Views 11 Comments

One table, one query, and an honest picture of who actually writes back.

A reader’s photograph, used with thanks.

After a year of pen pals I wanted to know how long replies really took, so I logged every envelope in a small database.

letters.sqlSQL
CREATE TABLE letters (
  id INTEGER PRIMARY KEY,
  recipient TEXT NOT NULL,
  sent_on DATE NOT NULL,
  stamp_cost REAL,
  replied_on DATE
);

SELECT recipient, julianday(replied_on) - julianday(sent_on) AS days
FROM letters
WHERE replied_on IS NOT NULL
ORDER BY days;

The fastest correspondent answered in six days. The slowest took eleven weeks and sent the longest letter of the year.

11 Comments  on this note

  1. R
    Rufus Tennant Reply ›

    Is there a printable version of the practice sheet? I would happily pay for one.

  2. I
    Iris Kettering Reply ›

    Came for the pens, stayed for the writing. Subscribed to the newsletter.

  3. I
    Iris Kettering Reply ›

    Tried the warm-up routine before an exam and my hand did not cramp once.

    1. K
      Keiko Sato Reply ›

      Try a medium stub. It hides a lot of wobble.

    2. E
      Elsie Marchetti Reply ›

      Try a medium stub. It hides a lot of wobble.

  4. R
    Rufus Tennant Reply ›

    The quote at the end made me go and find my old letters in the attic.

  5. O
    Odette Lambert Reply ›

    Great tip on flushing. I lost a vintage pen to dried ink before I learned that.

  6. I
    Iris Kettering Reply ›

    I laughed at the bit about losing the loupe. Mine is in a drawer I cannot find.

  7. K
    Keiko Sato Reply ›

    Is there a printable version of the practice sheet? I would happily pay for one.

    1. T
      The Ink Desk Staff Reply ›

      A printable sheet is on the list. We will announce it in the newsletter first.

  8. H
    Hamid Rostami Reply ›

    I disagree slightly about the paper, but the rest is spot on. Thin paper is worth the ghosting.

Leave a Comment

All comments are reviewed prior to publication. Your email address will not be displayed. Fields marked * are required.