MensBeam/Arsse

Full-text searching with SQLite #152

New issue

Open

opened 2019-03-02 14:15:37 -05:00 by jking · 0 comments

jking commented

2019-03-02 14:15:37 -05:00

Owner

While the FTS5 extension for SQLite is not included in the standard PHP distribution (and loading the extension at run-time is practically impossible), recent Debian does include FTS5 in its libsqlite3-0 package, which PHP uses.

Given the above, The Arsse would need to detect the presence of FTS5 at start-up, check whether relevant full-text virtual tables exist if so, and create them if they do not exist.

While the FTS5 extension for SQLite is not included in the standard PHP distribution (and loading the extension at run-time is practically impossible), recent Debian does include FTS5 in its `libsqlite3-0` package, which PHP uses. Given the above, The Arsse would need to detect the presence of FTS5 at start-up, check whether relevant full-text virtual tables exist if so, and create them if they do not exist.

jking added the

label 2019-03-02 14:15:43 -05:00

jking added this to the Future milestone 2019-03-02 14:15:47 -05:00

jking added a new dependency 2019-03-02 14:29:01 -05:00

#155 Full-text searching

Sign in to join this conversation.

No labels

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Blocks

#155 Full-text searching}

MensBeam/Arsse

Reference: MensBeam/Arsse#152

No description provided.