SQLite driver does not commit data

[lllama]

The SQLite executor does not call commit on the connection and so data is only saved for the lifetime of the application. I'm currently using Mayim with Sanic and while all new data is reflected in the application while it is running, if I quit the server then the data is lost.

(I've wrapped my inserts in a transaction but there's no difference in the behaviour).

Looking at the code, it seems only the MySQL driver explicitly calls commit on the connection.

It would be useful to be able to configure the commit behaviour. e.g. auto-commit after each query, commit at the end of a Sanic request-response cycle, explicit call a commit method on the executor, etc, etc

[lllama]

Just as an FYI for anyone else with this issue, I'm currently working around this with:

@app.on_response
async def commit_db(request, response):
    executor = Mayim.get(LinksExecutor)
    await executor.pool._db.commit()