[sqlite] Very specific use of sqlite3_backup_* with main and temp tables between a real and a :memory: database

t;temp", db2, "temp"); Because (maybe) the temporary triggers on db1 are now broken... ? I must drop all temporary things in db1 before sqlite3_backup_init() in the case where the tables already exist? And what about my queries? I mu

[sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

in the second query? Is the index used? It seems that this index is used, because otherwise more dot [.] should be printed between "step for first " and "step for second ". No? Thanks Regards, Mathieu SCHROETER #include #include #include "sqlite3.h" static int

Re: [sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

Le 20.10.2010 12:32, Mathieu Schroeter a écrit : I've made a small program with this output (please, look at the attached C code _first_): Mmmh.. sorry but the previous attached code has at least one error and some parts commented. And now I see that without EXPLAIN QUERY PLAN, the comparison

Re: [sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

Le 20.10.2010 14:14, Igor Tandetnik a écrit : > Mathieu Schroeter<schroe...@epsitec.ch> wrote: >> Le 20.10.2010 12:32, Mathieu Schroeter a écrit : >>> I've made a small program with this output (please, look at the >>> attached C code _first_): >> >>

Re: [sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

Le 20.10.2010 15:51, Drake Wilson a écrit : > Quoth Mathieu Schroeter<schroe...@epsitec.ch>, on 2010-10-20 15:41:51 +0200: >> Thanks for your interesting answer. >> >> The first plan looks the best but it does not explain the ORDER BY. >> If I could done this

Re: [sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

an index */ struct idx { struct idx *next; struct idx *prev; ... const void *data; /* ptr on 'my_data_in_the_table' */ } *idx_foobar To fix my problem then I must create my own high level index ... Thanks everyone! Mathieu > > > Pavel > > On Wed, Oct 20, 2010

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

n the next future. Hi, It works fine for me with a *Linux* Samba Server (SMB1). it is very bugged with the SMB1, SMB2 and SMB2.1 provided by Microsoft. Even if the Oplocks are disabled with SMB1. -- Mathieu SCHROETER ___ sqlite-users mailing list sqlite-us

[sqlite] bind for sub-queries

, it suggests that a significant time would be saved. Regards, Mathieu SCHROETER ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bind for sub-queries

Jay A. Kreibich a écrit : > On Sun, Jan 03, 2010 at 10:47:01AM +0100, Mathieu SCHROETER scratched on the > wall: >> Hello, >> >> I've a simple question about the bind functions. If it can >> be realistic to have in the future, a way to bind a sub-query >> in a

[sqlite] SQLite.NET.chm pages are empty

Hi, I downloaded the SQLite.NET.chmfrom the trunk [1]in order to access the .NET documentation but the pages are empty. Regards, Mathieu Schroeter [1]: http://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm

Re: [sqlite] SQLite.NET.chm pages are empty

Le 29.04.2013 11:35, Joe Mistachkin a écrit : Mathieu Schroeter wrote: I downloaded the SQLite.NET.chm from the trunk in order to access the .NET documentation but the pages are empty. Actually, this is the result of a Windows security feature that disables downloaded content. To enable