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/).
BundledSQLiteDriver: новый взгляд на SQLite в Android и Kotlin Multiplatform
BundledSQLiteDriver из библиотеки androidx.sqlite — это специальная сборка встраиваемой СУБД SQLite от команды разработчиков Android Jetpack, предназначенная для использования в Kotlin Multiplatform проектах. В этой статье мы рассмотрим её особенности.
I just released the search functionality in reciperium, built with #rust #sqlite #fts5 and I'm quite happy with the results 💪 , check this example out here:
https://www.reciperium.com/recipes?search=no-sugar
@PierreC @silvermoon82 While making a bookmark database with tagging & descriptions usable in #Emacs with fuzzy searching would be relatively trivial for me (for the most part I'd be leaning on #SQLite and its #FTS5 virtual table so descriptions are usable too), that's not exactly the case for everyone and replicating that functionality in a textfile would be quite obnoxious.
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. 🤦♀️
