Read-only and zero-side-effect connection to SQLite with Python

Viewed 20

I'm building a simple demo app which, in the backend, connects to an SQLite DB and runs queries specified by the user on it (imagine a "SQLite playground" type of app for example).

In the backend (python) I'm connecting to it with file:{path-to-db}?mode=ro. Is there anything else I should be concerned with? I don't have much experience with SQLite - are there any side effects users might trigger: any special commands that work through SQL queries, any "external file access", etc.?

0 Answers
Related