Upsert

Create and populate an SQLite database with Python

Database indexes at a high level

FTS5 search with English stemming and and matching

Create Fts5 Virtual Table in the Sqlite Cli

SQLite FTS tokenizers

SQLite virtual tables