How to add SQLite3 Full Text Search to existing Ecto tables
We will leverage the built-in FTS5 plugin to search through messages in a simple chat app. This blog post is inspired by Fly.io’s SQLite3 Full Text Search With Phoenix but instead of creating a new virtual table from scratch we keep our existing messages table and add a new virtual table for our search functionality on top. This has some advantages: The new search functionality and the old data & code are more separated....