About SQLite FTS5 and offsets about sqlean HOT 5 CLOSED

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

from sqlean.

Anton,

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

from sqlean.

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() 🤷

from sqlean.

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

from sqlean.

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

from sqlean.