[sqlite] Unicode tokenizer

2018-07-20 Thread Beatrix Willius
In my app I use a contentless table for searching with CREATE VIRTUAL TABLE bodyindex USING fts4(content='', messagebody); I want to improve unicode searching and have learned that a different tokenizer should help. Using this would be: CREATE VIRTUAL TABLE bodyindex USING fts4(tokenize=unicode

Re: [sqlite] Issue using SEE

2018-07-20 Thread Warren Young
On Jul 20, 2018, at 11:51 AM, sudeep singh wrote: > > Our application supports iOS, android and windows(UWP). Xamarin’s standard assumption is that you’re building your application with all-CLR code, which is why it’s trying to treat the DLL as a .NET assembly. That in turn means that even on

Re: [sqlite] Issue using SEE

2018-07-20 Thread Keith Medcalf
-m64 means generate 64-bit code. If you want 32-bit use -m32 -mwin32 means that the compilation is for windows. If it is not for Windows, omit this. -mdll means to compile/link as a DLL The SQLITE_API=... define adds the necessary attribute to export the API on windows. -mthreads tells the com

Re: [sqlite] Issue using SEE

2018-07-20 Thread sudeep singh
Yes I am trying to create a dll so that I can add it as reference in my project. Is there any way to do that? On Fri, Jul 20, 2018 at 11:05 AM, Keith Medcalf wrote: > > Firstly, the SQLITE_DLL define does not exist (is this a bug in the docs>? > Secondly you did not define SQLITE_HAS_CODEC as

Re: [sqlite] Issue using SEE

2018-07-20 Thread J Decker
On Fri, Jul 20, 2018 at 11:05 AM Keith Medcalf wrote: > > Firstly, the SQLITE_DLL define does not exist (is this a bug in the docs>? > Secondly you did not define SQLITE_HAS_CODEC as required to integrate the > SEE codec/ > Thirdly a .dll file cannot be created with ar. ar is for creating > libr

Re: [sqlite] Issue using SEE

2018-07-20 Thread Keith Medcalf
Firstly, the SQLITE_DLL define does not exist (is this a bug in the docs>? Secondly you did not define SQLITE_HAS_CODEC as required to integrate the SEE codec/ Thirdly a .dll file cannot be created with ar. ar is for creating libraries, not DLLs. (.a files) To statically link you should just a

[sqlite] Issue using SEE

2018-07-20 Thread sudeep singh
Hi Team, We have recently purchased SEE subscription to encrypt our data in mobile. Our application supports iOS, android and windows(UWP). We used Xamarin forms(.net standard2) approach to build this application which supports c# language. We are following this link https://www.sqlite.org/see/do

[sqlite] Build SQLite.Interop for MAC

2018-07-20 Thread Victor Da Costa
Hello, I'm trying to build the SQLite.Interop on MAC from the source code located on System.Data.SQLite.org. After building the library my application seems to detect it but I get this error on the Password field : System.EntryPointNotFoundException: Unable to find an entry point named "sqlit

[sqlite] META: polite plea to the clueful [Was: Web draft problem]

2018-07-20 Thread Ian Zimmerman
On 2018-07-20 17:51, R Smith wrote: > The Web-site seems to have a bit of an error on the draft pages (which > may only be because of the draft pages and not matter at all, but I > thought I'd post it just in case it is something needing attention). This was wholly unrelated to the post you repli

Re: [sqlite] Web draft problem

2018-07-20 Thread Richard Hipp
On 7/20/18, R Smith wrote: > The Web-site seems to have a bit of an error on the draft pages Thanks for the report. It is a missing chown in the script that syncs from development. Fixed now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailin

[sqlite] Web draft problem

2018-07-20 Thread R Smith
The Web-site seems to have a bit of an error on the draft pages (which may only be because of the draft pages and not matter at all, but I thought I'd post it just in case it is something needing attention). The steps leading to the error: 1 - Navigate to http://sqlite.org/draft/ (This redirec

Re: [sqlite] Recursive references in subqueries

2018-07-20 Thread Christian Duta
R Smith-2 wrote > The query above is perfectly defined. In fact, it works in PostgreSQL. > PostgreSQL's manual also has a very nice explanation of how recursive > queries are evaluated. The way PostgreSQL handles recursive queries was one of my motivations to post about this. PostgreSQL allows fo

Re: [sqlite] Recursive references in subqueries

2018-07-20 Thread Christian Duta
R Smith-2 wrote > The query above is perfectly defined. In fact, it works in PostgreSQL. > PostgreSQL's manual also has a very nice explanation of how recursive > queries are evaluated. The way PostgreSQL handles recursive queries was one of my motivations to post about this. PostgreSQL allows fo

Re: [sqlite] Recursive references in subqueries

2018-07-20 Thread R Smith
On 2018/07/19 10:23 PM, Lifepillar wrote: On 19/07/2018 15:53, R Smith wrote: In your example above, the full recursive set is not known at the time of first encountering the sub-query. i.e. do you expect it to have results on the first iteration? The query above is perfectly defined. In fa