Just released FTS5 ICU Tokenizer for SQLite!

This C extension provides robust multilingual text search using ICU library. Supports Chinese, Japanese, Thai, Arabic, Russian, Korean, Hebrew, Greek and more with proper word segmentation and language-specific normalization.

Works on Linux, macOS and Windows. Available now on GitHub (https://github.com/cwt/fts5-icu-tokenizer/).

#SQLite #ICU #FTS5 #FullTextSearch

BundledSQLiteDriver: новый взгляд на SQLite в Android и Kotlin Multiplatform

BundledSQLiteDriver из библиотеки androidx.sqlite — это специальная сборка встраиваемой СУБД SQLite от команды разработчиков Android Jetpack, предназначенная для использования в Kotlin Multiplatform проектах. В этой статье мы рассмотрим её особенности.

https://habr.com/ru/articles/896794/

#android #room #sqlite #fts5

I've wanted to play with #sqlite's #FTS5 (Full text #search extension) in #Deno for a long time. But this issue may not get resolved (for good reasons):

https://github.com/dyedgreen/deno-sqlite/issues/108

So I forked the repo and made a one-line change to the Makefile and bam! got my FTS.

https://github.com/teleclimber/deno-sqlite/commit/05ce37da26742e6d3b80dc7b92e3b80cbd93689b

So far it seems to work fine. Give it a shot if you like, you can import like this:

import { DB } from "https://github.com/teleclimber/deno-sqlite/raw/master/mod.ts";

I'll publish as a proper module in time if signals are positive.

#SQLite question
Am i right in thinking that you can combine use #FTS5 to have full text search on data from within #JSON columns?

I am _assuming_ it's just a matter of writing a valid trigger to extract said data into a virtual table but I'm having trouble finding an example.

I've never fully groked the syntax & limitations thereof for building those virtual tables. Utterly failed to do one with a simple join. 🤦‍♀️