[sqlite] Skip scan. Was: full table scan ignores PK sort order?

On 3/2/15, James K. Lowden wrote: >> "CREATE TABLE IF NOT EXISTS test >> ( >> a INTEGER, >> b INTEGER, >> c INTEGER, >> d BLOB, >> PRIMARY KEY (a, b DESC) >> );" > ... >> "SELECT * FROM test WHERE b < ? AND c > ?;" > > A full table scan is executed because no index supports the search >

[sqlite] PRAGMA Synchronous safety

Thank you for your responses Simon and Richard. To your questions: > Are you using any PRAGMAs apart from "PRAGMA synchronous" ? PRAGMA temp_store=1 (file) PRAGMA cache_size=2000 PRAGMA page_size=4096 sqlite3_soft_heap_limit( 1GB ) Those are the only non-default settings. > Are you testing

[sqlite] List duplication

Okay, I blocked the sqlite-users at sqlite.org address in the to address so if it is sent alone, it will be blocked. On Mon, Mar 2, 2015 at 9:46 PM, Mike Owens wrote: > Oh okay. I see. I'll look into it. > > On Mon, Mar 2, 2015 at 9:23 PM, Darren Duncan > wrote: >> >> So in that case, still

[sqlite] Test

This is a test. The sqlite-users at sqlite.org address has been blocked. Only sqlite-users at mailinglists.sqlite.org should be allowed through. Mike

[sqlite] PRAGMA Synchronous safety

On 2 Mar 2015, at 4:45pm, Doug Nebeker wrote: > 1. Is setting synchronous to FULL necessary to prevent these corruption > problems? You should not be getting this corruption problem, so I don't know whether FULL would cure it. > 2. NORMAL is much slower than NONE. Is FULL much slower than

[sqlite] List duplication

Oh okay. I see. I'll look into it. On Mon, Mar 2, 2015 at 9:23 PM, Darren Duncan wrote: > So in that case, still have the SQLite mail server reject messages to the > old list rather than forwarding them, and let the problematic MUAs deal > with it. The key thing is that by not forwarding but

[sqlite] Characters corrupt after importing a CSV file

On Mon, 2 Mar 2015 09:07:55 + Hick Gunter wrote: > We do that here. Works well most of the time, but fails miserably if > the first 10 columns are not representative of the data. By "that", I take you mean sampling 10 rows to determine the appropriate widths. > Also requires each and

[sqlite] full table scan ignores PK sort order?

On Mon, 2 Mar 2015 09:48:28 + Jan Asselman wrote: > "CREATE TABLE IF NOT EXISTS test > ( > a INTEGER, > b INTEGER, > c INTEGER, > d BLOB, > PRIMARY KEY (a, b DESC) > );" ... > "SELECT * FROM test WHERE b < ? AND c > ?;" ... > A full table scan is executed because column a is not part of

[sqlite] List duplication

The problem is that this is the very bone of contention in the reply-to religious war. Is it not? I may be wrong, but I thought this is the very setting that people get so defensive about changing. As we have it now, people have a suitable default pointing back to the (correct) list but also the

[sqlite] List duplication

So far so good. I only got one copy of your test message. I also sent my own message to just sqlite-users at sqlite.org and it was bounced as expected. -- Darren Duncan On 2015-03-02 8:14 PM, Mike Owens wrote: > Okay, I blocked the sqlite-users at sqlite.org address in the to address > so if

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

On Tue, 3 Mar 2015 at 03:01 Simon Slavin wrote: > > On 2 Mar 2015, at 12:23am, Jay Kreibich wrote: > > > Every database I?ve every used starts SQL parameter indexes from 1. I?m > not sure it is part of the SQL standard, but it is more or less the defacto > standard of SQL APIs, and might be

[sqlite] [ANN] SQLiteAdmin V1.3.6

Hello Peter, may i inform you that the link provided in your announcement is wrong - you end up with a 404 error. Please crosscheck: Working link: http://www.lcsql.com/sqliteadmin.html Your link: www.lcsql.com/sqliteadmin.htm I guess it?s the lower case typo ... Cheers sonypsx

[sqlite] System.Data.SQLite and spellfix under VB.net

Hello, May I post this question again - since I did not got any reply. could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here:

[sqlite] List duplication

On Mon, Mar 2, 2015 at 5:27 PM, R.Smith wrote: > > Ah, thank you, all makes sense now. If you change the first option to YES > then nobody else's quirky reply-to headers will get into the list, and the > second option remains as is (it should be setting the standard > @mailinglists reply-to

[sqlite] List duplication

On Mon, Mar 2, 2015 at 5:24 PM, Darren Duncan wrote: > As near as I can tell, the Reply-To header from this list only contains > sqlite-users at mailinglists.sqlite.org and does not also contain > sqlite-users at sqlite.org so therefore I don't see the problem you're > stating. But if it

[sqlite] List duplication

So in that case, still have the SQLite mail server reject messages to the old list rather than forwarding them, and let the problematic MUAs deal with it. The key thing is that by not forwarding but rejecting, the mail server isn't sending out 2 copies of messages directly, and the rejecting is

[sqlite] [ANN] SQLiteAdmin V1.3.6

I'm happy to announce the release of v1.3.6 of SQLiteAdmin, an SQLite Database administration tool. This is a free release for current users. SQLiteAdmin provides a GUI-based approach to creating your database schema including many capabilities not possible within the SQLite language, plus browse

[sqlite] List duplication

On 2015-03-02 6:14 PM, Mike Owens wrote: > On Mon, Mar 2, 2015 at 5:27 PM, R.Smith wrote: >> Ah, thank you, all makes sense now. If you change the first option to YES >> then nobody else's quirky reply-to headers will get into the list, and the >> second option remains as is (it should be setting

[sqlite] List duplication

On 2015-03-02 6:08 PM, Mike Owens wrote: > On Mon, Mar 2, 2015 at 5:24 PM, Darren Duncan > wrote: >> As near as I can tell, the Reply-To header from this list only contains >> sqlite-users at mailinglists.sqlite.org and does not also contain >> sqlite-users at sqlite.org so therefore I don't see

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

On 2015-03-02 04:51 PM, Paolo Bolzoni wrote: > I kinda get your point, but still we are speaking of the C interface > all the time. Sure in other contexts, like the TCL/SQL, the indexes > start from 1. However the bind and the column function are both in the > C interface. It's when the C

[sqlite] List duplication

For clarity, here is the currently policy for Reply-to as it is set in Mailman: - Should any existing Reply-To: header found in the original message be stripped? If so, this will be done regardless of whether an explict Reply-To: header is added by Mailman or not. : *NO* - Where are

[sqlite] full table scan ignores PK sort order?

On 3/2/15, Igor Tandetnik wrote: > On 3/2/2015 4:48 AM, Jan Asselman wrote: >> But when I step over the rows they are not returned in primary key sort >> order. Why is this? > > Because you didn't add an ORDER BY clause. If you need a particular sort > order, specify it with ORDER BY. > Igor is

[sqlite] full table scan ignores PK sort order?

On 3/2/2015 4:48 AM, Jan Asselman wrote: > But when I step over the rows they are not returned in primary key sort > order. Why is this? Because you didn't add an ORDER BY clause. If you need a particular sort order, specify it with ORDER BY. > If I look at the images at the query planning

[sqlite] PRAGMA Synchronous safety

On 3/2/15, Doug Nebeker wrote: > In the documents, using PRAGMA synchronous 1 (NORMAL) is supposed to be safe > unless there is an OS crash or power failure. > > I've had a few customers (about one a month, out of thousands) that is > getting the "database disk image is malformed" ExtErr=11 error

[sqlite] PRAGMA Synchronous safety

In the documents, using PRAGMA synchronous 1 (NORMAL) is supposed to be safe unless there is an OS crash or power failure. I've had a few customers (about one a month, out of thousands) that is getting the "database disk image is malformed" ExtErr=11 error with the NORMAL pragma, and they

[sqlite] full table scan ignores PK sort order?

On 3/2/15, Jan Asselman wrote: > Hi, > > I created the following table in sqlite 3.8.6 > > "CREATE TABLE IF NOT EXISTS test > ( > a INTEGER, > b INTEGER, > c INTEGER, > d BLOB, > PRIMARY KEY (a, b DESC) > );" > > When I execute the following query > > "SELECT * FROM test WHERE b < ? AND c >

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

Valodia valodia

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

On 2 Mar 2015, at 12:23am, Jay Kreibich wrote: > Every database I?ve every used starts SQL parameter indexes from 1. I?m not > sure it is part of the SQL standard, but it is more or less the defacto > standard of SQL APIs, and might be considered part of the SQL language. I hope the SQLite

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

I kinda get your point, but still we are speaking of the C interface all the time. Sure in other contexts, like the TCL/SQL, the indexes start from 1. However the bind and the column function are both in the C interface. Oh, well... I just have to wrap my mind around it. Definitely not a real

[sqlite] List duplication

On 2015-03-02 3:04 PM, R.Smith wrote: > On 2015-03-03 12:42 AM, Darren Duncan wrote: >> I think that what needs to be done is for each foo at sqlite.org to return an >> error/undeliverable message if someone sends a message to it, citing that all >> messages must be explicitly sent to the

[sqlite] System.Data.SQLite.DLL version 1.0.95.0 Bug

This issue should be fixed on the "nextRelease" branch, here: https://system.data.sqlite.org/index.html/info/154d609bbe Please let us know if this clears the problem for you. -- Joe Mistachkin

[sqlite] List duplication

I think that what needs to be done is for each foo at sqlite.org to return an error/undeliverable message if someone sends a message to it, citing that all messages must be explicitly sent to the corresponding foo at mailinglists.sqlite.org. That should handily solve the problem. -- Darren

[sqlite] System.Data.SQLite.DLL version 1.0.95.0 Bug

Michal wrote: > > The table does have a Primary Key. > Can you share the complete schema of the table involved? -- Joe Mistachkin

[sqlite] System.Data.SQLite and spellfix under VB.net

sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The first step would be to compile the spellfix extension as a loadable module, as documented here: https://www.sqlite.org/loadext.html Next, you can load it

[sqlite] List duplication

Ok, I've found the source of the list duplications. Some emails (Such as the one by J.K. Lowden 2-March-2015 re: Characters corrupt after importing...) contains a "Reply-To" field in the header with both list addresses which must have sneaked in there due to some automatic list feature. (By

[sqlite] List duplication

For what it is worth, the move to mailinglists.sqlite.org is a result of the Mailman web interface having to be hosted under the following two constraints: 1. It must be on port 80 2. It cannot be on sqlite.org port 80 I explained this reasoning in a previous email. The short version is because

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

On Mar 2, 2015, at 8:51 AM, Paolo Bolzoni wrote: > I kinda get your point, but still we are speaking of the C interface > all the time. Not exactly. SQL parameters are defined in SQL, and they?re part of the SQL language. The parameter placement (and from that, their indexing and binding)

[sqlite] List duplication

On Mon, 2015-03-02 at 12:45 +0200, R.Smith wrote: > Ok, I've found the source of the list duplications. > > Some emails (Such as the one by J.K. Lowden 2-March-2015 re: Characters > corrupt after importing...) contains a "Reply-To" field in the header > with both list addresses which must have

[sqlite] List duplication

On Sat, 2015-02-28 at 14:10 -0800, Darren Duncan wrote: > > My comment on "whoever" is meant to be plural. > > I think as a general principle that whenever people reply to list messages, > they > look at the headers of the message they are writing and make sure the list > doesn't appear twice

[sqlite] System.Data.SQLite version 1.0.95.0 released

System.Data.SQLite version 1.0.95.0 (with SQLite 3.8.8.3) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

On 3/2/2015 9:51 AM, Paolo Bolzoni wrote: > I kinda get your point, but still we are speaking of the C interface > all the time. Sure in other contexts, like the TCL/SQL, the indexes > start from 1. However the bind and the column function are both in the > C interface. Not quite. There's ?N

[sqlite] problem compiling std_call dll

Thanks for clearing this up. I did wonder about this. Came across it when making a .tlb for those calls to the std_call dll. RBS On Mon, Mar 2, 2015 at 6:14 AM, Scott Robison wrote: > On Sun, Mar 1, 2015 at 10:55 PM, J Decker wrote: > > > On Sun, Mar 1, 2015 at 9:22 PM, Keith Medcalf >

[sqlite] full table scan ignores PK sort order?

Hi, I created the following table in sqlite 3.8.6 "CREATE TABLE IF NOT EXISTS test ( a INTEGER, b INTEGER, c INTEGER, d BLOB, PRIMARY KEY (a, b DESC) );" When I execute the following query "SELECT * FROM test WHERE b < ? AND c > ?;" A full table scan is executed because column a is not

[sqlite] Characters corrupt after importing a CSV file

We do that here. Works well most of the time, but fails miserably if the first 10 columns are not representative of the data. Also requires each and every query to be run twice. Not good for queries that require sorting of the result set (i.e. the ORDER BY clause is not fulfilled automatically

[sqlite] Sqlite and threads/multiple applications

Hi Olivier, On Sun, Mar 1, 2015 at 5:22 PM, Olivier Vidal wrote: > What would be the most reliable operating system for Sqlite(last version)? As other people have already mentioned, the operating system doesn't matter. Pick the one you're most comfortable or interest in using. The most reliable