Datasette for CSV files

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.

Configuring full-text search

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.