Simon Willison’s Weblog

Subscribe

Posts tagged search, sqlite in 2020

Filters: Year: 2020 × search × sqlite × Sorted by date

Building a search engine for datasette.io

Visit Building a search engine for datasette.io

This week I added a search engine to datasette.io, using the search indexing tool I’ve been building for Dogsheep.

[... 1,391 words]

6:12 pm / 19th December 2020 / projects, search, sqlite, datasette, dogsheep, weeknotes, baked-data

sqlite-utils 2.14 (via) I finally figured out porter stemming with SQLite full-text search today—it turns out it’s as easy as adding tokenize=’porter’ to the CREATE VIRTUAL TABLE statement. So I just shipped sqlite-utils 2.14 with a tokenize= option (plus the ability to insert binary file data from stdin).

# 1st August 2020, 9:19 pm / full-text-search, projects, search, sqlite, sqlite-utils

Types

Years

Months

Tags