3 ms·
If you look at the source, you'll see that it opens the DB in read-only mode.
by dagw 2y ago
If you look at the source, you'll see that it opens the DB in read-only mode.
- DarkCrusader2 2y agoYes you are right. Source ref for anyone interested - https://github.com/simonw/sqlite-utils-ask/blob/91277eeb26bd56183983129bd0d67e22a1d277d7/sqlite_utils_ask.py#L130 https://github.com/simonw/sqlite-utils-ask/blob/91277eeb26bd...
- jillesvangurp 2y agoThere are also some SQL parsing libraries for python that you can use to restrict things further. But opening the DB in RO mode is a good start. Another concern with tools like this is query performance and not accidentally overloading your database with some stupidly expensive query.