SQLite Forum

Suggestion of safe mode of command shell
Login

Suggestion of safe mode of command shell

(1) By anonymous on 2021-11-28 21:54:53 [source]

I think that improvements could be made, including:

  • Add .safe command, to activate the safe mode even after other commands have been executed (this can be a way to load extensions). (This would be a better way than the nonce way, I think.)

  • Add some way to specify which functions and virtual tables of extensions should be allowed in this safe mode.

  • Ensure that also disable some pragmas in the safe mode, and disable file controls and some db config options (for example, disallow to disable defensive mode, or enable fts3_tokenizer, in safe mode).

(2) By anonymous on 2021-11-28 22:31:15 in reply to 1 [link] [source]

In what situations do you think that such a mode would be useful? (I don’t see the benefit…)

(3) By Larry Brasfield (larrybr) on 2021-11-28 22:43:19 in reply to 2 [link] [source]

I second this question, and suggest that usage scenarios be at least briefly described where the additional feature(s) would be useful and the objective not easily attained by other means.