search

denodrivers / sqlite3

The fastest and correct SQLite3 module for Deno runtime
https://jsr.io/@db/sqlite
Apache License 2.0
268 stars 22 forks source link

Fts5 #94

Closed 6rube closed 1 year ago

6rube commented 1 year ago

Hi, I am looking for an sqlite module with fts support. This module looks pretty good, but I could not find any information about fts. As far as I know fts is a standard feature from sqlite which you have to enable threw command arguments. How do I enable the extension in this case?

DjDeveloperr commented 1 year ago

Currently, there is no out of the box support for FTS5. It is possible to either:

a. Build sqlite3 yourself with the flag to enable FTS5 and point to it using DENO_SQLITE_PATH env variable. b. Build the FTS5 extension and load it using db.loadExtension.

For building both of the above, instructions are here: https://www.sqlite.org/fts5.html

However, I'll look into enabling FTS5 support in the main builds right now.

DjDeveloperr commented 1 year ago

FTS5 now works out of the box from 0.9.0 :)