Hideaki Takahashi

Thank you for the report, and information i will take a look.

Ok, I confirmed this issue in GitHub Actions (https://github.com/actions/runner-images/blob/main/images/macos/macos-11-Readme.md macos-11/Python 3.10.8/SQLite 3.39.4, likely the latest official release for 3.10.x https://github.com/python/cpython/pull/98639). I realized that maybe this is the issue I couldn't...

I could reproduce it on Linux too. it seems it happens when SQLite is static? linked to _sqlite3.so I will check what is wrong. ```console $ ldd ~/.pyenv/versions/3.10.8/lib/python3.10/lib-dynload/_sqlite3.cpython-310-x86_64-linux-gnu.so linux-vdso.so.1 (0x00007ffe2ad40000)...

Hi @macabrus, I managed make the pipeline pass (see https://github.com/hideaki-t/sqlite-fts-python/actions/runs/3710604666 ) can you try https://github.com/hideaki-t/sqlite-fts-python/tree/GH-30 ? I've never used pysqlite3. as you and I noticed, it seems static linking is...

Thank you for the report and sharing the idea. You're right. Using cffi for nested object and/or callbacks are not super easy. I didn't know pybind11, but it seems it...

do you have a simple script to reproduce the issue? before start making any change including switching FFI library, I'd like to reproduce the issue on my end to know...

I think I kept this open as `Fts5ExtensionApi` functions are not fully supported. currently only `xTokenize` is supported. maybe I can close this, and open another issue to cover more...

Thanks, Rnaking: I'll merge your implementation at gist. I'll add some test cases for CJK and other scoring functions Document: yes, I know I need to write it. I'll finish...

always this line. FTS3 works fine. ``` File "/home/hideaki/sqlite-fts-python/sqlitefts/fts5.py", line 156 in fts5_api_from_db ```

windows version interpreters don't seem to be affected. also Arch Linux's python package (3.11.7-1) is okay too.