search

tekartik / sqflite

SQLite flutter plugin
BSD 2-Clause "Simplified" License
2.88k stars 526 forks source link

Support for FTS5 #702

Open paulocoutinhox opened 3 years ago

paulocoutinhox commented 3 years ago

Hi,

Can you add support for FTS5 module?

Reference: https://www.sqlite.org/fts5.html

Thanks.

oseiasmribeiro commented 2 years ago

Currently the sqlite version is at 3.32.2 in sqflite: ^2.0.0+4. Are there any plans to update it to 3.9.0 so we can enjoy FTS5 functions? This is very important. I've been waiting for this for a long time.

alextekartik commented 2 years ago

sqflite itself uses whatever SQLite version installed on the device so the version depends on your device.

Using sqflite_common_ffi, you can build, bundle and use the SQLite you need. For example you can use sqlite_flutter_libs. I'm not sure whether FTS5 is supported though