[sqlite] compiling sqlite3 with FTS5 support
On 10/09/2015 10:18 AM, chromedout64 at yahoo.com wrote: > I noticed there was talk in the other thread of including FTS5 support in the > amalgamation. That would be great and it seems like that might solve my > problem. Is that correct? > > Also, I noticed what may be a couple typos in the FTS5 documentation at > https://www.sqlite.org/fts5.html. > In the external content table section, the example states: > CREATE TABLE fts USING fts5(a, c, content=tbl, content_rowid=d); > I think it should be CREATE VIRTUAL TABLE instead of CREATE TABLE. > > Also, in the overview section, the text says: > The expression to the right of the MATCH operator must be the nameof the FTS5 > table. The expression on the left must be a text value specifyingthe term to > search for.I think the right and left's are backwards. Thanks for these. Now fixed. Dan.
[sqlite] compiling sqlite3 with FTS5 support
I noticed there was talk in the other thread of including FTS5 support in the amalgamation. That would be great and it seems like that might solve my problem. Is that correct? Also, I noticed what may be a couple typos in the FTS5 documentation at https://www.sqlite.org/fts5.html. In the external content table section, the example states: CREATE TABLE fts USING fts5(a, c, content=tbl, content_rowid=d); I think it should be CREATE VIRTUAL TABLE instead of CREATE TABLE. Also, in the overview section, the text says: The expression to the right of the MATCH operator must be the nameof the FTS5 table. The expression on the left must be a text value specifyingthe term to search for.I think the right and left's are backwards.
[sqlite] compiling sqlite3 with FTS5 support
Is there a way to build the sqlite3 command line utility with integrated FTS5 support? I have been compiling and installing the latest version by downloading the latest 'autoconf' file, such as sqlite-autoconf-3081101.tar.gz, and building and installing that. However, I noticed that this is only configured for FTS3/FTS4 support. As a separate process, I was able to compile a 'fts5.so' loadable module by downloading the full sqlite-src-3081101.zip file and compiling just the module. This can then be loaded and used successfully using the '.load fts5' command in the command line interface. I'm just looking to see how to integrate FTS5 support directly into the sqlite3 install from the first step. Any help would be appreciated.
