Re: [sqlite] SQLite version 3.7.6

2011-04-13 Thread Peter van Dijk
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

Re: [sqlite] Datetime mystery

2009-10-09 Thread Peter van Dijk
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

Re: [sqlite] sqlite3 datbase disk image malformed

2009-03-06 Thread Peter van Dijk
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

[sqlite] iPhone

2007-07-02 Thread Peter van Dijk
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"

2007-05-09 Thread Peter van Dijk
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

Re: [sqlite] A suggestion

2007-05-09 Thread Peter van Dijk
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

Re: [sqlite] How fast is the sqlite connection created?

2007-02-26 Thread Peter van Dijk
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

Re: [sqlite] OR, IN: which is faster?

2007-01-31 Thread Peter van Dijk
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

Re: [sqlite] "SQL Error: near 'Table': Syntax error"

2006-07-27 Thread Peter van Dijk
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.