Drag and drop any CSV files you like to this project root and they will be converted into a SQLite database and loaded into a Datasette instance.
Hit this Remix button to get your own copy of this project:
You can uncomment lines in requirements.txt to install extra plugins.
See Running Datasette on Glitch for more about this project.
Datasette supports SQLite full-text search. You can configure it for a table using the sqlite-utils command-line tool.
In the Glitch editor select Tools -> Full Page Console, then run the following:
$ cd .data
$ sqlite-utils tables data.db --table --columns
table columns
------- ------------------------------------
example ['headline', 'body', 'url', 'extra']
This shows you the tables and columns in your database.
If you want to make the example table searchable by headline and body, run the following command:
$ sqlite-utils enable-fts data.db example headline body --fts4
Your Datasette instance will now display a search box that can be used to search the text in those columns.