issues: 563347679

This data as json

id	node_id	number	title	user	state	locked	assignee	milestone	comments	created_at	updated_at	closed_at	author_association	pull_request	body	repo	type	active_lock_reason	performed_via_github_app
563347679	MDU6SXNzdWU1NjMzNDc2Nzk=	668	Make it easier to load SpatiaLite	9599	closed	0			2	2020-02-11T17:03:43Z	2021-01-04T20:18:44Z	2021-01-04T20:18:39Z	OWNER		`$ datasette spatial.db Serve! files=('spatial.db',) (immutables=()) on port 8001 ERROR: conn=<sqlite3.Connection object at 0x11e388f10>, sql = 'PRAGMA table_info(SpatialIndex);', params = None: no such module: VirtualSpatialIndex Usage: datasette serve [OPTIONS] [FILES]... Error: It looks like you're trying to load a SpatiaLite database without first loading the SpatiaLite module. Read more: https://datasette.readthedocs.io/en/latest/spatialite.html` This error message could sniff around in the common locations for the SpatiaLite module and output the CLI command you should use to enable it: `datasette spatial.db --load-extension=/usr/local/lib/mod_spatialite.dylib` Even better: if Datasette had a `--spatialite` option which automatically loads the extension from common locations, if it can find it.	107914493	issue

Links from other tables