[GH-ISSUE #377] Migration to FTS5 #241

New issue

Closed

opened 2026-02-25 23:33:46 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 23:33:46 +03:00

Owner

Originally created by @fmartingr on GitHub (Feb 22, 2022).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/377

Originally assigned to: @fmartingr on GitHub.

The update to the new SQLite driver without C dependencies (#307) updated the full-text search engine from fts4 to fts5, which isn't backward compatible with shiori 1.5.0.

Only the create table was updated, and if a any 1.5.1+ version try to load bookmarks from 1.5.0 or lower version it will fail with:

failed to fetch count: SQL logic error: no such module: fts5 (500)

Problems with this:

Being free of C is good for builders and maintainabilty in general
modernc/sqlite only supports fts5
shiori does not support migrations at this point in time #270

Putting a procedure to migrate the content from the fts4 table to an fts5 will make a check in every shiori run, but is the only fix that we can make in a reasonable amount of time until we have proper systems in place.

Maybe some queries may need to be updated as well.

Documentation: https://www.sqlite.org/fts5.html#appendix_a

Related: #291

Originally created by @fmartingr on GitHub (Feb 22, 2022). Original GitHub issue: https://github.com/go-shiori/shiori/issues/377 Originally assigned to: @fmartingr on GitHub. The update to the new SQLite driver without C dependencies (#307) updated the full-text search engine from fts4 to fts5, which isn't backward compatible with shiori 1.5.0. Only the create table was updated, and if a any 1.5.1+ version try to load bookmarks from 1.5.0 or lower version it will fail with: ``` failed to fetch count: SQL logic error: no such module: fts5 (500) ``` Problems with this: - Being free of C is good for builders and maintainabilty in general - modernc/sqlite only supports fts5 - shiori does not support migrations at this point in time #270 Putting a procedure to migrate the content from the fts4 table to an fts5 will make a check in every shiori run, but is the only fix that we can make in a reasonable amount of time until we have proper systems in place. Maybe some queries may need to be updated as well. Documentation: https://www.sqlite.org/fts5.html#appendix_a Related: #291

kerem

2026-02-25 23:33:46 +03:00

closed this issue
added the
type:bug

component:backend

database:sqlite

priority:high
labels

kerem commented

2026-02-25 23:33:46 +03:00

Author

Owner

@fmartingr commented on GitHub (Feb 24, 2022):

Closed by https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5
Added notice in v1.5.1 release

@fmartingr commented on GitHub (Feb 24, 2022): - Closed by https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5 - Added notice in [v1.5.1 release](https://github.com/go-shiori/shiori/releases/tag/v1.5.1)