[Uno.sqlite-wasm] FTS5 support?

[DierkDroth]

@jeromelaban
FYI
I'm now taking an approach where I p/invoke into Uno.sqlite-wasm. So, no (Uno)SQLitePCLRaw nor sqlite-net-pcl. Basically I built a (surprisingly small) 'ADO.NET light' wrapper around Uno.sqlite-wasm. This works pretty good and got me rid of (unwanted) dependencies and of problems like this one as well. In case anyone is interested, here is a sample repo (based on UNO's own SQLiteSample.Wasm)

SQLiteSample.zip

Anyway, here is my next problem: I found that Uno.sqlite-wasm lacks the FTS5 support which my code needs.

Am I missing something or could that be 'easily' added to the build process for Uno.sqlite-wasm? In case I needed to do this: would you have any pointer on how to tweak e.g. the Makefile (or other parts of the of source package) so I could add FTS5 support to the Uno.sqlite-wasm bitcode file?

Thanks in advance

[DierkDroth]

I figured it out. Here is what I to do on my Windows 11 system:

• install WSL: wsl --install + reboot. The Ubuntu file system could be accessed in Windows explorer.
• sync clock in WSL: sudo hwclock -s
• git clone https://github.com/unoplatform/Uno.sqlite-wasm
• install emscripten
  Note: there is a caveat, you needed to install the version used by Uno.sqlite-wasm which is 3.1.12 at this point (e.g. unzip the Uno.sqlite-wasm NuGet -> buildTransitive -> native -> sqlite3.bc to see what emscripten version UNO is using). Don't try Latest, this may result in SQLite runtime errors, e.g. I saw 'attempt to write a readonly database' on SQL INSERT

git clone https://github.com/emscripten-core/emsdk.git
cd emsdk
git pull
emsdk install 3.1.12
emsdk activate 3.1.12
emsdk_env.bat

• edit <Uno.sqlite-wasm-source-dir>/src/c/sqlite_cfg.h and add compile options as needed. In my case #define SQLITE_ENABLE_FTS5 1
• build by running make. Note: you might get some errors since tools like lbzip2 make unzip are missing. Ubuntu shell provides hints on how to install those
• copy <Uno.sqlite-wasm-source-dir>/dist/sqlite3.bc to your UNO WASM project (e.g. Assets folder) and add it as resource with Build Action = Content
• remove Uno.sqlite-wasm NuGet from the UNO WASM project

I updated repo above accordingly.