SQLITE_EXTENSIONS environment variable should be DATASETTE_LOAD_EXTENSION

[simonw]

Spotted in:

• Proposal: add new DATASETTE_SSL_KEYFILE and DATASETTE_SSL_CERTFILE env vars for --ssl-keyfile and --ssl-certfile #2422

datasette/datasette/cli.py

Lines 84 to 91 in 0bc6a2a

	fn = click.option(
	"sqlite_extensions",
	"--load-extension",
	type=LoadExtension(),
	envvar="SQLITE_EXTENSIONS",
	multiple=True,
	help="Path to a SQLite extension to load, and optional entrypoint",
	)(fn)

It's inconsistent with our other environment variables, which all use the DATASETTE_ prefix.

[simonw]

SQLITE_EXTENSIONS was never mentioned in our documentation, so this is a very minor breaking change (and good for pre-1.0).

[simonw]

Actually DATASETTE_LOAD_EXTENSION is a better name, it matches the --load-extension option.

[simonw]

Tested like this:

DATASETTE_LOAD_EXTENSION=spatialite datasette --get /-/versions.json

Returned ... {"spatialite_version": "5.1.0", "spatialite_target_cpu": "arm64-apple-darwin22.4.0"...

[simonw]

Documented here: https://docs.datasette.io/en/latest/cli-reference.html#environment-variables