SQLite Arrow Key Navigation Support
The standard SQLite shell on macOS doesn’t support arrow key navigation like many standard CLI programs do. Pressing up, down, right, and left in that order outputs the following escape codes in the shell
sqlite> ^[[A^[[B^[[C^[[D
A program called rlwrap
can shim arrow key support into sqlite
.
Install rlwrap
(it’s supported by Homebrew and Nixpkgs) then run
rlwrap sqlite <the rest of the command>
and it should just work.
Recommended
Embeddings with sqlite-vector
About a year and a half ago I wrote about using sqlite-vss to store and query embedding vectors in a SQLite database. Much has changed since then and...