Anybody use sqlite3? I'm trying to open an sqlite3 directory to which I have read but not write access, and the first thing I do is type ".tables", and it says "Error: attempt to write a readonly database". I could sudo to the user that owns the file, but then I get a little nervous because I don't want to write to the database, I just want to read it. If I write to it right now that probably means I'm breaking something. Is there a way to interact with a sqlite3 database in readonly mode?
@mcc i have, but not through the command line. I do know the engine does a lot of caching + journaling when its active, maybe that's what you're running into?
@mcc at the risk of being obvious, can you not copy it to a place where you do have write permission and then read that?
Not saying it's a general solution but might be a temporary method.
Add comment