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 (=,<,>) than BETWEEN. IMPORTANT! The BETWEEN...AND operator is treated differently in different databases: 1. BETWEEN..AND selects fields that are between and excluding the test values; 2. BETWEEN..AND selects fields that are between and including the test values; 3. BETWEEN..AND selects fields between the test values, including the first test value and excluding the last test value. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 question to developers of SQLite: Is it difficult to change the behaviour of the "REPLACE" part of "INSERT OR REPLACE" to be the correct behaviour, row content is updated, and not deleted then inserted? Thanks in advance and happy hollidays! - To unsubscribe, send email to [EMAIL PROTECTED] -
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 "BETWEEN..AND selects fields that are between and including the test values", so it can be used instead of ">=" and "<=", ONLY if you specify COMPLETE test values, example "20071001" AND "20071131". 2. If you specify PARTIAL test values, example "200710" AND "200711", then "BETWEEN" in SQLite is treated as "BETWEEN..AND selects fields between the test values, including the first test value and excluding the last test value". 3. It is not reliable to use "BETWEEN" for now (and not only in SQLite, but also in other DBMS), better use >= and <=. - To unsubscribe, send email to [EMAIL PROTECTED] -
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] Problems Insert with Date and Time values
I avoided "BETWEEN" because this operator is treated differently in different databases, and I don't tested how it is treated in SQLite. http://www.w3schools.com/sql/sql_between.asp - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problems Insert with Date and Time values
>is it possible (how?) to insert into 2 different fields (date) the following >values: >09:30:00(only a time value...) >14/07/07 (only year value, 14th of december 2007) Just store date and/or time as string: "20070714" or "070714", "093000". It is compact, you can sort them easily etc. You can store them also as Integer: 20070714, 93000, this will save space in database, as integers are stored in variable-length format (VarInt). - 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 PROTECTED] -
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 to, not only Richard, but to us (just see previous messages about DeviceSQL, full of suppositions). These were no "FUD and incorrect statements", nor "misleading information", these were only suppositions, and this is because it's hard to find real technical information or specifications on DeviceSQL, only marketing information. Maybe DeviceSQL is a good product, but absence of real info and abundance of marketing make us think and suppose various things (just see previous messages). All of us are waiting for what Richard stated: "If you view their web presentation and/or try out Encirq's products, I would be very interested to hear your impressions. Even better would be if you could blog about it." Even better if all of us can have access to this web presentation, to find out maybe more technical info about DeviceSQL. Any way, thank you. - To unsubscribe, send email to [EMAIL PROTECTED] -
[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. - To unsubscribe, send email to [EMAIL PROTECTED] -
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 the SELECT must exactly match the number of columns in the table if no column list is specified, or it must match the number of columns name in the column list. A new entry is made in the table for every row of the SELECT result. The SELECT may be simple or compound. If the SELECT statement has an ORDER BY clause, the ORDER BY is ignored. ^ Question: ORDER BY is ignored or not ? - To unsubscribe, send email to [EMAIL PROTECTED] -
[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 bounce message I received. If this message bounces too, I will send you a probe. If the probe bounces, I will remove your address from the sqlite-users mailing list, without further notice. I've kept a list of which messages from the sqlite-users mailing list have bounced from your address. Copies of these messages may be in the archive. To retrieve a set of messages 123-145 (a maximum of 100 per request), send an empty message to: <[EMAIL PROTECTED]> To receive a subject and author list for the last 100 or so messages, send an empty message to: <[EMAIL PROTECTED]> Here are the message numbers: 20009 20195 20199 20205 --- Enclosed is a copy of the bounce message I received. Return-Path: <> Received: (qmail 3066 invoked for bounce); 5 Mar 2007 04:49:35 - Date: 5 Mar 2007 04:49:35 - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: failure notice Hi. This is the qmail-send program at sqlite.org. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: 217.26.144.4 failed after I sent the message. Remote host said: 550 This message contains a virus (HTML.Phishing.Pay-131) - To unsubscribe, send email to [EMAIL PROTECTED] -
Re[2]: [sqlite] FTS: index only, no text storage - Was: [sqlite] FTS: Custom Tokenizer / Stop Words
Just for information: A full-text indexer based only on SQLite BTree index, not using tables: http://www.codeproject.com/useritems/Text_Indexer.asp - To unsubscribe, send email to [EMAIL PROTECTED] -
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()? - To unsubscribe, send email to [EMAIL PROTECTED] -
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 will be added, I see a big future for using SQLite as a simple, but powerful and easily customized (user tokenizers etc) full-text search engine, and not only as a DB engine. Currently we don't have many options for full-text desktop engine, there are some, like DTSearch, Onix, Lucene, but these are over-priced, can't be easily customized or too complex. - To unsubscribe, send email to [EMAIL PROTECTED] -
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. - To unsubscribe, send email to [EMAIL PROTECTED] -
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. - To unsubscribe, send email to [EMAIL PROTECTED] -
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 email to [EMAIL PROTECTED] -
[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 unsubscribe, send email to [EMAIL PROTECTED] -
[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. - To unsubscribe, send email to [EMAIL PROTECTED] -
