Python API ability to opt-out of connection plugins

[simonw]

Plugins affecting the CLI by default makes sense to me.

I'm less confident about them always affecting users of the Python API.

I'm going to have them apply by default, but I'm going to add a mechanism to opt-out on an individual database basis. Basically this:

from sqlite_utils import Database
db = Database(memory=True, execute_plugins=False)
# Anything using db from here on will not execute plugins

cc @asg017

Refs:

• 567

• 574

[simonw]

Relevant code: https://github.com/simonw/sqlite-utils/blob/3f80a026983d3e634f05a46f2a6da162b5139dd9/sqlite_utils/db.py#L346

[simonw]

Documented here: https://sqlite-utils.datasette.io/en/latest/plugins.html