Best way to use SQLite as back end

I have a SQLite database that has various data and using python, I can access this database locally, perform calculations on the data housed in the database and return results.

I want to take it to the next step and deploy this online as a backend to a webpage whereby the front end user would be able to click and invoke one of several python scripts, and have the data passed back into the web framework. If possible I would like the user be able to update the data from the web framework, i.e. not have it read only.

I'm very much a newbie and content to thrash around, what i'm struggling with is the best workflow to move forward.

SQLite -> Python -> Javascript running in browser? Whereby a user would click a button that would use javascript to invoke the python script, the data then being passed back as some kind of json or xml or similar?

Is it better to try and do the whole thing using python using something like web2py?

Are there any frameworks that make this easy like wordpress (which I think is php)

Is SQLite even the best program or would it make more sense to migrate to something like MySQL?