One of my favourite little-known PostgreSQL features is trigram indexes. They let you speed up queries that need to match substrings within a text column - queries like this:
select * from articles where title like '%smil%'
There's a great explanation of how these work in PostgreSQL here: <https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/#trigram-indexes>
I would _love_ to have a version of this functionality in SQLite. There's an experimental module for that here, but it's not seen any work in seven years: <https://github.com/jonasfj/trilite>
Has anyone seen a SQLite-oriented solution for this?