docs: sections: 1 row where breadcrumbs contains "Enabling full-text search for a SQLite table", page = "full_text_search" and references = "[{"href": "https://github.com/simonw/csvs-to-sqlite", "label": "csvs-to-sqlite"}]"

1 row where breadcrumbs contains "Enabling full-text search for a SQLite table", page = "full_text_search" and references = "[{"href": "https://github.com/simonw/csvs-to-sqlite", "label": "csvs-to-sqlite"}]"

Search:

descending

id ▼	page	ref	title	content	breadcrumbs	references
full_text_search:configuring-fts-using-csvs-to-sqlite	full_text_search	configuring-fts-using-csvs-to-sqlite	Configuring FTS using csvs-to-sqlite	If your data starts out in CSV files, you can use Datasette's companion tool csvs-to-sqlite to convert that file into a SQLite database and enable full-text search on specific columns. For a file called items.csv where you want full-text search to operate against the name and description columns you would run the following: $ csvs-to-sqlite items.csv items.db -f name -f description	["Full-text search", "Enabling full-text search for a SQLite table"]	[{"href": "https://github.com/simonw/csvs-to-sqlite", "label": "csvs-to-sqlite"}]

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [sections] (
   [id] TEXT PRIMARY KEY,
   [page] TEXT,
   [ref] TEXT,
   [title] TEXT,
   [content] TEXT,
   [breadcrumbs] TEXT,
   [references] TEXT
);