sections: full_text_search:configuring-fts-using-csvs-to-sqlite

This data as json

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"}]