[sqlite] sqlite3 command line, read-only

[Dominique Devienne]

On Mon, Apr 25, 2016 at 2:53 PM, Mark Foley <mfoley at novatec-inc.com> wrote:

> On Mon, 25 Apr 2016 14:41:30 Dominique Devienne <ddevienne at gmail.com>
> wrote:
>
> > Perhaps you're missing the leading file: ? I believe it is required. --DD
>
> No, unless I'm putting it in the wrong place. As I wrote I did:

$ sqlite3 "myDbpath?mode=ro"
>

Please (re)read the example I included. --DD

C:\Users\DDevienne>sqlite3 *file:*new.db?mode=ro
...
sqlite> update t set v = 4;
*Error: attempt to write a readonly database*
sqlite>