hrmnjt's secure thought transfer protocol

reading files in style with duckdb and harlequin

2024-12-02 . 159 words . 1 min

Earlier, I wrote a small utility to read files with duckdb 1 and I'm finding amazing mileage for this small utility. I recently found Harlequin 2 which natively works with duckdb on the terminal. Its even better than the CLI in some cases because it does SQL IDE stuff but in the terminal.

So, I extended earlier utility function 3 to add a harlequin edit mode.

Now, when I do just npq DATASET I get the default duckdb CLI

duckdb cli

and when I do just hqp DATASET I get Harlequin TUI

harlequin tui

Fin.


footnotes

1

Here is a shard for that

2

Harlequin is "An easy, fast, and beautiful database client for the terminal.". Github repository.

3

Added a commit 48c9b44 to add an --ui [cli, harlequin] flag and added 2 more commands to justfile