Re: [sqlite] What is quicker?

>I understand that BETWEEN gets translated to >= and =< (bigger or >equal, and small or equal). Some time ago I tested and observed different behaviour for BETWEEN in SQLite (sometime as >= and =<, sometime >= and <), so test it for yourself. I think it is better to use comparison signs (=,<,>)

[sqlite] Spell

http://sqlite.org/34to35.html : 2.1 The Virtual File System Object The new OS interface for SQLite is built around an object named sqlite3_vfs. The "vfs" standard for "Virtual File System". stands ___ sqlite-users mailing

[sqlite] Time to rewrite DBMS, says Ingres founder

http://www.regdeveloper.co.uk/2008/02/18/stonebraker_dbms_outdated/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re[2]: [sqlite] Fastest way to check if new row or update existing one?

>>QUESTION: is there a better way to make this important decision? using >>Sqlite >INSERT OR REPLACE may work for you. There is a problem with "INSERT OR REPLACE" in that "REPLACE" is not truly , but is (existing row is deleted and new row is added), or I am wrong? If I am correct, then a

Re[3]: [sqlite] Problems Insert with Date and Time values

>It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects >fields that are between and including the test values", so it can be >used instead of ">=" and "<=". I am sorry, but it seems I am partially correct. I tested again and concluded: 1. "BETWEEN" in SQLite is treated as

Re[2]: [sqlite] Problems Insert with Date and Time values

It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects fields that are between and including the test values", so it can be used instead of ">=" and "<=". - To unsubscribe, send email to [EMAIL PROTECTED]

Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

>We wrote Richard back in August to correct his misstatements then. He chose >to ignore the letter. August? We start to discuss about DeviceSQL some days ago, or I am wrong? - To unsubscribe, send email to [EMAIL

Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

>SW: Richard, We have written to you directly before to ask you to stop the >FUD and incorrect statements, and you have chosen to continue. I suggest you >not waste everyone's time by circulating deliberately misleading >information. I think you are very aggressive and I think you must apologise

[sqlite] http://www.sqlite.org/

I am not well versed in english, but this phrase from home page: "This the homepage for SQLite - ...", I think must be rephrased: "This is the homepage for SQLite - ...". Anyway, many thanks for SQLite and its community.

Re: [sqlite] DISQLite FTS

>Does DISQLite have its own implementation of FTS, so not using FTS2 at all? FTS1/2 are compiled in DISQLite. - To unsubscribe, send email to [EMAIL PROTECTED]

Re[2]: [sqlite] Index creation on huge table will never finish.

> drh wrote: > INSERT INTO two SELECT * FROM one ORDER BY unique_column; >The ORDER BY is important here. This is an excerpt from SQLite documentation: The second form of the INSERT statement takes it data from a SELECT statement. The number of columns in the result of

[sqlite] What's this?

This is a message I received: Hi! This is the ezmlm program. I'm managing the sqlite-users@sqlite.org mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Messages to you from the sqlite-users mailing list seem to have been bouncing. I've attached a copy of the first

Re: [sqlite] FTS: index only, no text storage - Was: [sqlite] FTS: Custom Tokenizer / Stop Words

To Ralf: >As a side effect, the offsets() and snippet() functions stopped working, as >they seem to rely on the presence of the full document text in the current >implementation. Did you tested "phrase" searching on the index-only version, didn't this kind of search rely on offsets()?

Re[2]: [sqlite] FTS: index only, no text storage - Was: [sqlite] FTS: Custom Tokenizer / Stop Words

>Just a question: did you eliminated stop-words in your tests? Sorry, you specified that you indexed source code files, so no stop-words are applicable here. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] FTS: index only, no text storage - Was: [sqlite] FTS: Custom Tokenizer / Stop Words

Thank you. Just a question: did you eliminated stop-words in your tests? >Concluding: Given the great database size savings possible by separating full >text index from data storage, I wish that >developers would consider adding such an option to the SQLite FTS interface. If such an option

Re[2]: [sqlite] FTS: Custom Tokenizer / Stop Words

But what about: I am very interested to know if it would be possible to use an FTS indexing module to store the inverted index only, but not the document's text. This would safe disk space if the text to index is stored on disk rather than inside the database.

Re[2]: [sqlite] Effect of blobs on performance

>* In SQLite, my blobs won't be corrupted if the machine loses power > the way they (probably) will be if I write my own code to access > the file-system. But, in case of a corruption, you will have entire blob DB corrupted versus at least one file (aka one row in DB) corrupted.

Re[2]: [sqlite] Effect of blobs on performance

>>I'm fairly sure disk space requirements will be nearly identical in >>each case... In case of blobs in SQLite there will be less disk space used than in case of file system (cluster size etc.) - To unsubscribe, send

[sqlite] OR, IN: which is faster?

If we have a query where we compare a column to a set of values, then which is faster: OR or IN? Ex: OR: (mycol = "a") OR (mycol = "b") OR (mycol = "c") OR... IN: (mycol IN "a", "b", "c" ...) Thanks. - To

[sqlite] SQLite read-only

Hi, Is there a possibility to open a SQLite database read-only so that database file will not be locked? This request is for updating reasons, to overwrite the database file with a newer version, while users have opened the database only for read. Thanks in advance.