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.