Re: [sqlite] Incompatibility in virtual table mechanism when upgrading from 3.7.14.1 to 3.13.0
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 itself, or by xFilter, or both. One should never completely ignore a WHERE-clause term. xFilter will only get involved if argvIndex is set. So if argvIndex is not set, the processing is solely up to SQLite. Hence, the omit flag should be ignored if argvIndex is not 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 virtual table index to use) or to speed up data transfer for our > partitioned table implementation (returning the composite record image > instead of n distinct fields therough 2 levels of SELECT statements). > > SQL syntax requires that they be named in an expression, but since their > value is not required the argvIndex is left at 0 (instead of having to > append unique index values, with SQLite generating arguments to xFilter that > are simply ignored). > > 3.13.0 opcodes: > > asql> explain select __table from cma_ct_card_42 where __table=0; > addr opcode p1p2p3p4 p5 comment > - - -- - > 0 Init 0 13000 Return > 1 VOpen 0 0 0 vtab:6205C08 00 VColumn > 2 Explain0 0 0 SCAN TABLE cma_ct_card_42 VIRTUAL > TABLE INDEX 0: 00 > 3 Integer0 1 000 Int64 > 4 Integer0 2 000 Int64 > 5 VFilter0 11100 VUpdate > 6 VColumn0 35300 VRename; > cma_ct_card_42.__table > 7 Ne 4 103 (BINARY) 53 Eq > 8 Copy 3 5 000 SCopy > 9 ResultRow 5 1 000 CollSeq > 10VNext 0 6 000 Init > 11Close 0 0 000 ColumnsUsed > 12Halt 0 0 000 Integer > 13Integer0 4 000 Int64 > 14Goto 0 1 000 Gosub > > 3.7.14.1 opcodes: > > asql> explain select __table from cma_ct_card_05 where __table=0; > addr opcode p1p2p3p4 p5 comment > - - -- - > 0 Trace 0 0 000 NULL > 1 Integer0 1 000 NULL > 2 Goto 0 12000 NULL > 3 VOpen 0 0 0 vtab:1D32698:2B178127BA70 00 NULL > 4 Integer0 2 000 NULL > 5 Integer0 3 000 NULL > 6 VFilter0 10200 NULL > 7 VColumn0 35500 > cma_ct_card_05.__table > 8 ResultRow 5 1 000 NULL > 9 VNext 0 7 000 NULL > 10Close 0 0 000 NULL > 11Halt 0 0 000 NULL > 12Goto 0 3 000 NULL > > > ___ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This communication (including any attachments) is intended for the use of > the intended recipient(s) only and may contain information that is > confidential, privileged or legally protected. Any unauthorized use or > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please immediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Will the next release include support for VS 2015 Update 3?
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/downloads.wiki are > for update 2, and they don't work. How don't they work? Updates rarely break old things from working just make new things not work the old way... not the other way around. > Looking at the timeline, it appears > that support for update 3 has been added on July 2nd. The release > scheduled for sometime this August doesn't seem to include support for > update 3, judging by the notes on the release history. Will support for vs > 2015 update 3 be included? Also, any idea if the release is scheduled for > sometime in the next few days, or is it a matter of weeks? > > Thanks > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Incompatibility in virtual table mechanism when upgrading from 3.7.14.1 to 3.13.0
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 virtual table index to use) or to speed up data transfer for our partitioned table implementation (returning the composite record image instead of n distinct fields therough 2 levels of SELECT statements). SQL syntax requires that they be named in an expression, but since their value is not required the argvIndex is left at 0 (instead of having to append unique index values, with SQLite generating arguments to xFilter that are simply ignored). 3.13.0 opcodes: asql> explain select __table from cma_ct_card_42 where __table=0; addr opcode p1p2p3p4 p5 comment - - -- - 0 Init 0 13000 Return 1 VOpen 0 0 0 vtab:6205C08 00 VColumn 2 Explain0 0 0 SCAN TABLE cma_ct_card_42 VIRTUAL TABLE INDEX 0: 00 3 Integer0 1 000 Int64 4 Integer0 2 000 Int64 5 VFilter0 11100 VUpdate 6 VColumn0 35300 VRename; cma_ct_card_42.__table 7 Ne 4 103 (BINARY) 53 Eq 8 Copy 3 5 000 SCopy 9 ResultRow 5 1 000 CollSeq 10VNext 0 6 000 Init 11Close 0 0 000 ColumnsUsed 12Halt 0 0 000 Integer 13Integer0 4 000 Int64 14Goto 0 1 000 Gosub 3.7.14.1 opcodes: asql> explain select __table from cma_ct_card_05 where __table=0; addr opcode p1p2p3p4 p5 comment - - -- - 0 Trace 0 0 000 NULL 1 Integer0 1 000 NULL 2 Goto 0 12000 NULL 3 VOpen 0 0 0 vtab:1D32698:2B178127BA70 00 NULL 4 Integer0 2 000 NULL 5 Integer0 3 000 NULL 6 VFilter0 10200 NULL 7 VColumn0 35500 cma_ct_card_05.__table 8 ResultRow 5 1 000 NULL 9 VNext 0 7 000 NULL 10Close 0 0 000 NULL 11Halt 0 0 000 NULL 12Goto 0 3 000 NULL ___ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: h...@scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite
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, 2016 at 6:02 PM, Lloyd wrote:
> 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 = DbProviderFactories.GetFactory("System.Data.
> SQLite");
> using (DbConnection cnn = fact.CreateConnection())
> {
> cnn.ConnectionString = "Data Source=test.db3";
> cnn.Open();
> }
>
> How can I associate a DBContext with this connection? Is it possible to
> create tables in my sqlite database based on my entity classes?
>
> I couldn't find any tutorial on using System.Data.SQLite with Entity
> Framework.
>
> Any hint/help/a link to tutorial is greatly appreciated
>
> Thanks,
> Lloyd
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite
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 =
DbProviderFactories.GetFactory("System.Data.SQLite");
using (DbConnection cnn = fact.CreateConnection())
{
cnn.ConnectionString = "Data Source=test.db3";
cnn.Open();
}
How can I associate a DBContext with this connection? Is it possible to
create tables in my sqlite database based on my entity classes?
I couldn't find any tutorial on using System.Data.SQLite with Entity
Framework.
Any hint/help/a link to tutorial is greatly appreciated
Thanks,
Lloyd
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Setting temp location with Python
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 purposes? Thanks, Jonathan Hi Kevin, Yep, Item 5.0 was the one I was looking at, but as best I can tell there is no OS-agnostic way of doing it except the PRAGMA. But the pragma has been deprecated so I was wondering what the new, post-deprecation, OS-agnostic solution. Cheers, Jonathan On 11/08/2016 15:42, Kevin O'Gorman wrote: > On Wed, Aug 10, 2016 at 6:50 AM, Jonathan Moules < > jonathan-li...@lightpear.com> wrote: > >> Hi List, >> I'm using Python's sqlite3 library to access a SQLite db. I'd like to >> set the location for the temporary databases in a platform agnostic fashion >> (*nix or Windows). >> >> This page - https://www.sqlite.org/tempfiles.html - gives a number of >> options, but the only good one I can see for using it via Python would be >> the PRAGMA. >> But the docs for PRAGMA temp_store_directory; ( >> https://www.sqlite.org/pragma.html#pragma_temp_store_directory ) say this >> is deprecated. >> >> So what's the recommended way to achieve this? >> >> >> Take a look at https://www.sqlite.org/tempfiles.html, specifically item > 5.0. which addresses this question. It varies a bit depending on your > environment, so there's no single answer. On my Linux system, I fiddle > with the SQLITE_TMPDIR environment variable. > > You might want to describe your environment so that folks with a similar > environment can respond more helpfully. > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Compatibility SEE and System.Data.SQLite
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? No. Databases encrypted by the legacy encryption mechanism in SDS are not readable or writable with SEE, and vice versa. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Compatibility SEE and System.Data.SQLite
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-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Will the next release include support for VS 2015 Update 3?
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 support for update 3 has been added on July 2nd. The release scheduled for sometime this August doesn't seem to include support for update 3, judging by the notes on the release history. Will support for vs 2015 update 3 be included? Also, any idea if the release is scheduled for sometime in the next few days, or is it a matter of weeks? Thanks ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15
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 pointer-heavy data structures can be up to twice as big in memory in 64 bit, sometimes not fitting in cache anymore, and therefore negatively affecting performance at times. So gains from using the 64-bit chip "natively" can be lost to those cache misses. Just a broad generic statement of 32 vs 64-bit. --DD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
