# full-text search in PDO_SQLITE?

- Thread: https://externals.io/message/30199
- Original archive: https://news-web.php.net/php.internals/30199
- Started by Steph Fox on 2007-06-15T21:42:17+00:00
- Messages: 2
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #30199 — Steph Fox — 2007-06-15T21:42:17+00:00

URL: https://externals.io/message/30199#30199

Hey Ilia/Wez,

I came across Google Gears completely by accident (thanks Madeleine D), and 
thereby fell across the fts2 (full text search) module in SQLite 3. It looks 
like one of those killer feature thingies from here.

Is there any chance for its inclusion in the PDO_SQLITE version? Or is it 
too unstable/under-tested at present, or are there other reasons for not 
embracing SQLite modules?

http://www.mail-archive.com/sqlite-users@sqlite.org/msg24917.html

- there's a patch there for a static build.

- Steph

---

## #30200 — Ilia Alshanetsky — 2007-06-15T22:34:38+00:00

URL: https://externals.io/message/30199#30200 · In reply to: #30199

I have plans for adding the support for it, however last I checked  
there was fts v1 and a much improved (newer) fts2. I was waiting for  
fts2 to be more tested before making it available. Probably on the  
next lib update.




> Hey Ilia/Wez,
>
> I came across Google Gears completely by accident (thanks Madeleine  
> D), and thereby fell across the fts2 (full text search) module in  
> SQLite 3. It looks like one of those killer feature thingies from  
> here.
>
> Is there any chance for its inclusion in the PDO_SQLITE version? Or  
> is it too unstable/under-tested at present, or are there other  
> reasons for not embracing SQLite modules?
>
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg24917.html
>
> - there's a patch there for a static build.
>
> - Steph

Ilia Alshanetsky