Re: [sqlite] FTS4/5 ranking function differences

2016-08-11 Thread Jan Berkel
>>Another open question I have is how to access the user query expression >>from within the ranking function. Don't think this is exposed anywhere. >>(Looking at the source I noticed Fts5Expr *, but it is private). >>The best option would then be to pass it through to the >>ranking function as a

Re: [sqlite] FTS4/5 ranking function differences

2016-08-11 Thread Dan Kennedy
On 08/11/2016 04:41 PM, Jan Berkel wrote: You could run a regular database query from within the auxiliary function implementation. Not sure how that would perform though - perhaps similarly to the FTS3/4 approach, perhaps a little better. Or, you could add the "weight" as an UNINDEXED column to

Re: [sqlite] FTS4/5 ranking function differences

2016-08-11 Thread Jan Berkel
>You could run a regular database query from within the auxiliary >function implementation. Not sure how that would perform though - >perhaps similarly to the FTS3/4 approach, perhaps a little better. >Or, you could add the "weight" as an UNINDEXED column to the fts5 >documents table. Then

Re: [sqlite] FTS4/5 ranking function differences

2016-08-10 Thread Dan Kennedy
On 08/10/2016 12:47 AM, Jan Berkel wrote: I'm currently implementing FTS5 in my application and I'm at the stage where I want to rank the results in an efficient way. I'm following the examples from "Appendix A: Search Application Tips" (https://www.sqlite.org/fts3.html#appendix_a). Similar to

[sqlite] FTS4/5 ranking function differences

2016-08-09 Thread Jan Berkel
I'm currently implementing FTS5 in my application and I'm at the stage where I want to rank the results in an efficient way. I'm following the examples from "Appendix A: Search Application Tips" (https://www.sqlite.org/fts3.html#appendix_a). Similar to the example there I have a static weight