FS#6217 - SQLite3 with FTS on

Attached to Project: Arch Linux
Opened by Alberto Simoes (ambs) - Sunday, 14 January 2007, 18:27 GMT
Last edited by Andreas Radke (AndyRTR) - Saturday, 02 February 2008, 17:20 GMT
Task Type Feature Request
Category Packages: Extra
Status Closed
Assigned To Andreas Radke (AndyRTR)
Architecture All
Severity Low
Priority Normal
Reported Version 0.7.2 Gimmick
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 4
Private No

Details

SQLite includes since version 3.3.8 (the latest on Arch) a plugin named Full Text Search. It is compiled together with SQLite3 (it is included in the source tarball) and would be nice to have it available on Arch package.

For details how to build it check
http://www.sqlite.org/cvstrac/wiki?p=FtsOne

In any case, here is the important part:

Building FTS1

FTS1 can be built either as a standalone shared library, or statically linked into the SQLite library.

To build the module as a shared library, compile all source files in the ext/fts1 subdirectory of the source tree into a shared library (.so or .dll) on your platform



Cheers
TIA
Alberto
This task depends upon

Closed by  Andreas Radke (AndyRTR)
Saturday, 02 February 2008, 17:20 GMT
Reason for closing:  Implemented
Comment by Christoph Zeiler (Rabyte) - Friday, 21 December 2007, 19:33 GMT
+1. Needed for tkhtml3 alpha16 (in AUR).
Comment by Roman Kyrylych (Romashka) - Tuesday, 08 January 2008, 00:07 GMT
Well, FTS is very useful, but ...at the referenced wiki page there's a notice that FTS2 (still in development?) is recommended to use instead of FTS1 (unsupported, permanent beta). Oh, and there's even FTS3 mentioned in the changelog! :-/
Comment by Andreas Radke (AndyRTR) - Saturday, 02 February 2008, 17:19 GMT
i've applied a patch taken from http://www.sqlite.org/cvstrac/tktview?tn=2791,35 and now the libs are bigger. the extra modules should be included now.

please ask to reopen and give a solution if they don't work.

Loading...