Re: sqlite error with roundup-demo

Hi Tonu:

In message <CABDFm8iEM_+KoBYSy5e5r9aUC0ZWfKnfEYwy55qTMSiFzjnSPQ@mail.gmail.com>
,
Tonu Mikk writes:
>The results of the command are inline.  Looks like the sqlite3 in my case
>is compiled with FTS3 (not 5) support.

Yup that's what it look like.

>Not sure if the roundup installer could take advantage of FTS3 as well
>as FTS5?

The FTS3 is an older and less capable method. At minimum, it would
require changing the Roundup code to use the FTS3 methods and to munge
requests to FTS3 syntax and generate new testing paths to support both
FTS3 and FTS5. It's a good amount of work, added overhead per request,
and added complexity.

If you want to use Roundup 2.2.0 or newer, your choices are to:

  1) upgrade to a modern sqlite with FTS5 (released in 2015).
     support. Preferably your operating system should support that
     version.

  2) As I mentioned before:  In theory you
     could edit the installed back_sqlite.py and comment out the calls to
     self._add_fts5_table(). As long as you didn't try to use native-fts as
     the indexer config option, I think it would work. But YMMV.

Sorry I don't have better news.  Have a good week.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.