Re: [sqlite] Incompatibility in virtual table mechanism when upgrading from 3.7.14.1 to 3.13.0

2016-08-19 Thread Richard Hipp
On 8/19/16, Hick Gunter wrote: > It seems that SQLite is no longer honoring the aConstaintUsage[].omit flag > for constraints that do not have an aContraint[].argvIndex set. I'm going to call this a bug-fix, not a break. Every term of the WHERE clause ought to be processed, either by SQLite itse

Re: [sqlite] Will the next release include support for VS 2015 Update 3?

2016-08-19 Thread J Decker
On Thu, Aug 18, 2016 at 12:37 PM, Brian Fairservice < brianfairserv...@gmail.com> wrote: > Greetings, > > I need to work with a project that uses SQLite as an ADO data source. I > have visual studio 2015 Update 3. I see the binaries on > https://system.data.sqlite.org/index.html/doc/trunk/www/do

[sqlite] Incompatibility in virtual table mechanism when upgrading from 3.7.14.1 to 3.13.0

2016-08-19 Thread Hick Gunter
It seems that SQLite is no longer honoring the aConstaintUsage[].omit flag for constraints that do not have an aContraint[].argvIndex set. This breaks a feature of our virtual table implementation that allows special hidden columns named in the WHERE clause to be interpreted as hints (i.e. which

Re: [sqlite] System.Data.SQLite

2016-08-19 Thread Lloyd
Through DBContext constructor I have associated the connection. As the table is not existing in my database, it throws an exception. Does sqlite support automatic creation of tables or do I have create the tables and relationships first and then insert the data using the framework? On Fri, Aug 19

[sqlite] System.Data.SQLite

2016-08-19 Thread Lloyd
Hi, I am trying to use SQLite with EntityFramework6 on a .Net application. I have referred the documentation, created the app.config file as specified in the documentation. When I created a sample C# file as in the documentation,it generates an empty database file. DbProviderFactory fact = DbPro

Re: [sqlite] Setting temp location with Python

2016-08-19 Thread Jonathan Moules
Hi List, To approach this question from another direction: Why was this Pragma deprecated (temp_store_directory)? Aside from the possibility of it disappearing in future builds (or current builds built without deprecateds), are there any problems I should anticipate in using it for these purpo

Re: [sqlite] Compatibility SEE and System.Data.SQLite

2016-08-19 Thread Richard Hipp
On 8/19/16, Bernd Schuhmacher wrote: > Hi > > I am working on a project using the System.Data.SQLite .net Classes. I > use the encryption available with this classes. > Is the encryption used by System.Data.SQLite when setting a password > compatible with the encryption used in the SEE version of

[sqlite] Compatibility SEE and System.Data.SQLite

2016-08-19 Thread Bernd Schuhmacher
Hi I am working on a project using the System.Data.SQLite .net Classes. I use the encryption available with this classes. Is the encryption used by System.Data.SQLite when setting a password compatible with the encryption used in the SEE version of SQLite? Regards Bernd __

[sqlite] Will the next release include support for VS 2015 Update 3?

2016-08-19 Thread Brian Fairservice
Greetings, I need to work with a project that uses SQLite as an ADO data source. I have visual studio 2015 Update 3. I see the binaries on https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki are for update 2, and they don't work. Looking at the timeline, it appears that suppo

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-19 Thread Dominique Devienne
On Fri, Aug 19, 2016 at 3:47 AM, Michael Falconer < michael.j.falco...@gmail.com> wrote: > *subquery in result set* test produces interesting outcome with the 64 bit > version bucking the trend. Any ideas there? > One cannot tell, unless comparing profiles of both. One thing to remember is that