Vendor custom SQLite build with ICU extension enabled #93

New Issue

Open

opened 2026-04-06 02:04:37 +02:00 by oysteikt · 2 comments

oysteikt commented

2026-04-06 02:04:37 +02:00

Owner

Needed for #23

See usage: https://ytyaru.hatenablog.com/entry/2021/03/09/000000

Needed for #23 See usage: https://ytyaru.hatenablog.com/entry/2021/03/09/000000

oysteikt added the packaging nix labels 2026-04-06 02:04:37 +02:00

oysteikt added this to the Kanban project 2026-04-06 02:04:38 +02:00

oysteikt commented

2026-04-06 02:06:07 +02:00

Author

Owner

Note that we'll need to crossbuild it for android and bundle it with mugiten as well.

It would be nice if this could be done in a way so that interactively running flutter run in the devshell just works

We can use pkgs.pkgsCross.aarch64-android.sqlite

Note that we'll need to crossbuild it for android and bundle it with mugiten as well. It would be nice if this could be done in a way so that interactively running `flutter run` in the devshell just works We can use `pkgs.pkgsCross.aarch64-android.sqlite`

oysteikt added a new dependency 2026-04-06 02:06:50 +02:00

#23 Word search: kana type independence

oysteikt commented

2026-04-06 05:23:34 +02:00

Author

Owner

Turns out that the builtin ICU won't do it, as mentioned in ytyaru's article LIKE does not work across the kana boundary.

Consider building https://hg.sr.ht/~cwt/fts5-icu-tokenizer

See also chapter 6 about static linkage: https://sqlite.org/loadext.html

Turns out that the builtin ICU won't do it, as mentioned in ytyaru's article `LIKE` does not work across the kana boundary. Consider building https://hg.sr.ht/~cwt/fts5-icu-tokenizer See also chapter 6 about static linkage: https://sqlite.org/loadext.html

oysteikt moved this to Working in Kanban on 2026-04-06 05:31:08 +02:00

1 Participants

Notifications

Due Date

No due date set.

Blocks

#23 Word search: kana type independence

mugiten/jadb

Reference: mugiten/jadb#93