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://s
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
___
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 -snapshot
Apple's new iPhone uses SQLite 3.1.3 to manage its database of
certificates :)
Cheers, Peter
-
To unsubscribe, send email to [EMAIL PROTECTED]
---
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!
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-
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 sqlit
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 index
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.
9 matches
Mail list logo