Read-only sqlite DBs from the CLI
Honoring the principle of least
privilege, I
prefer to open sqlite
DBs in read-only mode when peeking at the data through
the CLI, to avoid unexpected modifications.
The CLI provides a -readonly
flag:
sqlite3 --help |& grep readonly
-readonly open the database read-only
Also TIL about |&
to pipe both std-out and std-err, tested in fish
and bash
.