[sqlite] Calling FTS tokeniser functions manually

2016-05-13 Thread Matt Hamilton
> On 13 May 2016, at 16:04, Dan Kennedy wrote: > > On 05/13/2016 09:19 PM, Matt Hamilton wrote: >> Hi all, >> Anyone know if/how you can call the FTS5 tokeniser functions manually? e.g. >> I want to look something up in the fts5vocab table but can't as I ne

[sqlite] Calling FTS tokeniser functions manually

2016-05-13 Thread Matt Hamilton
somehow map 'running' => 'run' in order to query the fts5vocab table to get stats on that term? And how could I tokenise 'running man' => 'run', 'man' in order to look up multiple tokens? -Matt ? Matt Hamilton Quernus matt at quernus.co.

[sqlite] FTS5 ranking across multiple databases

2016-04-28 Thread Matt Hamilton
ion. Does this make sense? Or anyone else see any other way to achieve what I want to do? thanks -Matt ? Matt Hamilton Quernus matt at quernus.co.uk <mailto:matt at quernus.co.uk> +44 117 325 3025 64 Easton Business Centre Felix Road, Easton Bristol, BS5 0HE Quernus Ltd is a com