Get the latest tech news
SQLite FTS5 Extension
an SQLite virtual table module that provides full-text search functionality to database applications. In their most elementary form, full-text search engines allow the user to efficiently search a large collection of documents for the subset that contain one or more instances of a search term.
The highlight() auxiliary function returns a copy of the text from one of the columns of the current match with each instance of a queried term within the result surrounded by specified markup (for example "<b>" and "</b>"). Instead of using bm25() with no trailing arguments, the specific auxiliary function mapped to the rank column may be configured either on a per-query basis, or by setting a different persistent default for the FTS table. 0..31 (32 bits) Page number The structure record identifies the set of segment b-trees that make up the current FTS index, along with details of any ongoing incremental merge operations.
Or read this on Hacker News