About SQLite FTS5 and offsets

[edwinyzh]

Hello Anton,

Just read your article about SQLite is not a toy database and found that comments were not enabled, and I'm wondering if I can take this chance to ask do you happen to know how to implement the offsets function for FTS5?

Thanks!

[nalgeon]

Hello Edwin! What's an offsets function, could you give an example?

[edwinyzh]

Anton,

It's the official offsets functions supported by FTS3/4 but not supported by FTS5.

[nalgeon]

Quoting from FTS5 docs:

FTS5 has no matchinfo() or offsets() function, and the snippet() function is not as fully-featured as in FTS3/4. However, since FTS5 does provide an API allowing applications to create custom auxiliary functions, any required functionality may be implemented within the application code.

I never worked with custom auxiliary functions, so I've got no idea how to implement offsets() 🤷

[edwinyzh]

No problem and I'm await your next awesome article on SQLite :)

[nalgeon]

Thank you very much, Edwin! Will do my best ツ