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

[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 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?

[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/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

[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 
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

[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, 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

[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 =
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

[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 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

[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?

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

[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-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?

[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 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

[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 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