Re: [sqlite] SQLite version 3.7.6
On Apr 12, 2011, at 2:49 PM, D. Richard Hipp wrote: > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ I expect you meant 'now available' :) Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Datetime mystery
On Oct 8, 2009, at 16:16 , Jay A. Kreibich wrote: > On Thu, Oct 08, 2009 at 08:29:10AM +0200, Fredrik Karlsson scratched > on the wall: > >> Yes, that would have been my guess too, but I am on CET, which I >> understand is UTC+1. CET is CEST in summer, which is UTC+2 Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 datbase disk image malformed
On Thu, Mar 05, 2009 at 04:30:50AM -0800, donnied wrote: > > rsync was corrupting the database. I'll have to exclude the database from > rsync backup. I feel a need to point out that it is not, technically, rsync that was corrupting the database. The issue is that rsync does not take -snapshots- of files; for that matter, very few backup tools do. One fix/workaround is to have a cronjob for making textual dumps. Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] iPhone
Apple's new iPhone uses SQLite 3.1.3 to manage its database of certificates :) Cheers, Peter - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] perfomance degradation for expr "foo = X or bar =X"
On 9-mei-2007, at 11:28, bash wrote: SELECT type, stamp_id, old_player_id, new_player_id FROM town_log WHERE old_player_id = $ID OR new_player_id = $ID ORDER BY stamp_id DESC; This query works really slowly and i don't know why :/ For example, the same result by another QUERY work much faster! SELECT type, stamp_id, old_player_id, new_player_id FROM town_log WHERE old_player_id = $ID UNION SELECT type, stamp_id, old_player_id, new_player_id FROM town_log WHERE new_player_id = %d ORDER BY stamp_id DESC; Hello Humanoid, UNION performing much better than an equivalent query with OR is a known 'limitation' in many database systems, including MySQL and SQLite. Page 52 of http://www.sqlite.org/php2004/slides-all.html explicitly recommends to use UNION here. Cheers, Peter. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] A suggestion
On 9-mei-2007, at 11:06, A.J.Millan wrote: As a suggestion, and even in the risk to abuse of Mr Hipp's patience. Would it be possible to include in the command-line program (sqlite3.exe) the ability to edit, an repeat at least the five or six last commands, as in Linux?. Is to say with up-arrow and down-arrow. I believe it would be too helpful. Arrow up and down work fine for me, I'm not sure what your actual request is then? Cheers, Peter. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] How fast is the sqlite connection created?
On Feb 25, 2007, at 10:03 AM, Alex Cheng wrote: I want to know how many time is spent when create a sqlite connection. Is it effeciency? My application creates a connection and close it when access DB everytime, is it OK? Hello Alex, every time you open an sqlite database file, the sqlite library has to parse all table structures. It is much better to keep your connection/handle open for longer periods of time. Cheers, Peter. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] OR, IN: which is faster?
On Feb 1, 2007, at 8:19 AM, Ion Silvestru wrote: 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" ...) IN is much faster - OR disables any use of indexes for column mycol. Cheers, Peter. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] "SQL Error: near 'Table': Syntax error"
On Jul 26, 2006, at 5:33 PM, Dennis Cote wrote: John Newby wrote: Is there any other names I need to look out for other than the "sqlite_" and "table" that SQLite doesn't like as being a table name that anyone knows of? John, All keywords need to be quoted to use them as identifiers. There is a comprehensive list of keywords at http://www.sqlite.org/ lang_keywords.html I would also suggest that you stick with the SQL standard method of quoting identifiers using double quotes (rather than the other extensions that SQLite accepts for compatibility with other non- standard database systems). Using double quotes to quote identifiers in sqlite is dangerous, as mistyping a fieldname will not yield an error. Currently the only safe way to quote identifiers is using backticks, as in MySQL. Cheers, Peter.