Re: [sqlite] Need a document/link or suggestion

2018-07-23 Thread Joe Mistachkin
sudeep singh wrote: > > Currently we are using sql-net-pcl nuget package ( > https://www.nuget.org/packages/sqlite-net-pcl/) to insert the data. Now, my > task is to encrypt the same data using SEE. > I've never used (or worked on) the "SQLite-net-pcl" project before; however, it appears to

[sqlite] Need a document/link or suggestion

2018-07-23 Thread sudeep singh
Hi Team, I have been really struggling on how to use SEE. My project which is a cross platform application is built using Xamarin forms .net standard 2.0. I have recently purchased the SEE source code but it contains only .c files which is fair but is there any link which tells user how to

Re: [sqlite] Corrupted FTS5 index? disk image is malformed - Part II

2018-07-23 Thread Nick
Hi Dan Did you receive below? Would extracted db be useful for debugging? Regards Nick > > On 18 Jul 2018 at 22:41,wrote: > > > On 18 Jul 2018, at 14:09, Dan Kennedy wrote: > > > Easiest explanation > is that something is writing directly to the

Re: [sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-07-23 Thread Dominique Devienne
On Mon, Jul 23, 2018 at 5:37 PM Dan Kennedy wrote: > On 07/23/2018 06:36 PM, Dominique Devienne wrote: > > On Mon, Jul 23, 2018 at 12:57 PM Dan Kennedy > wrote: > > The diff adds: > > > > #define CTIMEOPT_VAL2_(opt1,opt2) #opt1 "," #opt2 > > #define CTIMEOPT_VAL2(opt) CTIMEOPT_VAL2_(opt) > > >

Re: [sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-07-23 Thread Dan Kennedy
On 07/23/2018 06:36 PM, Dominique Devienne wrote: On Mon, Jul 23, 2018 at 12:57 PM Dan Kennedy wrote: On 07/22/2018 07:48 PM, Victor Costan wrote: In a custom SQLite build, SQLITE_DEFAULT_LOOKASIDE results in compilation errors, unless used with SQLITE_OMIT_COMPILEOPTION_DIAGS. This is

Re: [sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-07-23 Thread Dominique Devienne
On Mon, Jul 23, 2018 at 12:57 PM Dan Kennedy wrote: > On 07/22/2018 07:48 PM, Victor Costan wrote: > > In a custom SQLite build, SQLITE_DEFAULT_LOOKASIDE results in compilation > > errors, unless used with SQLITE_OMIT_COMPILEOPTION_DIAGS. > > > > This is because src/ctime.c includes the

Re: [sqlite] Bug: SQLITE_DEFAULT_LOOKASIDE does not compile without SQLITE_OMIT_COMPILEOPTION_DIAGS

2018-07-23 Thread Dan Kennedy
On 07/22/2018 07:48 PM, Victor Costan wrote: In a custom SQLite build, SQLITE_DEFAULT_LOOKASIDE results in compilation errors, unless used with SQLITE_OMIT_COMPILEOPTION_DIAGS. This is because src/ctime.c includes the following block: #ifdef SQLITE_DEFAULT_LOOKASIDE "DEFAULT_LOOKASIDE="

Re: [sqlite] Recursive references in subqueries

2018-07-23 Thread John G
Just to nitpick : SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. Connected to a transient in-memory database. sqlite> with recursive count_down(v) as ( ...> select 5 ...> union all ...> select n - 1 from count_down where n > 0 ...> ) ...>