Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, fulltextsearch

Filters: Type: entry × sqlite × fulltextsearch × Sorted by date


Weeknotes: datasette-dump, sqlite-backup, talks

I spent some time this week digging into Python’s sqlite3 internals. I also gave two talks and recorded a third, due to air at PyGotham in October.

[... 928 words]

4:47 am / 11th September 2020 / fulltextsearch, speaking, sqlite, datasette, weeknotes, sqliteutils

Exploring search relevance algorithms with SQLite

SQLite isn’t just a fast, high quality embedded database: it also incorporates a powerful full-text search engine in the form of the FTS4 and FTS5 extensions. You’ve probably used these a bunch of times already: many iOS, Android and desktop applications use SQLite under-the-hood and use it to implement their built-in search.

[... 1390 words]

3:29 am / 7th January 2019 / fulltextsearch, projects, search, sqlite, datasette

Types

Years

Tags