> -Original Message-
> From: Jacob Engstrand [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 11:18 AM
> To: Will Leshner
> Cc: Forum SQLite
> Subject: Re: [sqlite] Dropping an old index
>
> Yes, I thought about that, but the quotes are not part of the name in
> the SQLITE_MASTER
> -Original Message-
> From: Ali Sadik Kumlali [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 3:09 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [sqlite] Is using max(rowid) instead of count(*) safe?
>
>
> Thanks for taking your time. I'm using P3 600Mhz, 512MB, Win2K Pro for
> th
> -Original Message-
> From: Rubens Jr. [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 5:00 PM
>
> I read the OnLine Doc many times and I do not notice this :
> "SQLite expects the SQL string that you pass in to be
> unchanged until the
> SQL has finished executing."
>
> If
> -Original Message-
> From: Banek, MB Matthew (8773) @ IS [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 1:19 PM
>
> The problem I'm having is that the trigger does not use IGNORE for
conflict
> resolution, but uses REPLACE instead, since (as the documentation states)
> trig
> -Original Message-
> From: Dan Thill [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 22, 2004 2:03 PM
> To: Williams, Ken
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Precompiled queries forcing db syncs?
>
>
> Ahh. The archives I was browsin
> -Original Message-
> From: Dan Thill [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 22, 2004 10:34 AM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] Precompiled queries forcing db syncs?
>
> In short, when I switch to precompiled queries, according to gprof, it
> looks like the DB is be
> On my PC the following query requires about 53 seconds:
> select * from TABG a, TABB b where (a.S='3' or a.S='12 or...) and
> b.G=a.G order by a.G asc;
>
> (On Oracle with the same scheme and data it requires only 0.4
> seconds.)
In my experience, even though SQLite has very low overhead and
> -Original Message-
> From: Balthasar Indermuehle [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 15, 2004 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] Multiuser experience under win32 anyone?
>
>
> Hi all,
>
> Has anyone been doing some testing on how sqlite performs in
> a
> -Original Message-
> From: Griggs, Donald [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 01, 2004 11:14 PM
>
>
> I would think a general database program would do as sqlite
> does -- call the
> carefully written, standard posix routines (or their PC or
> MAC analogues),
> and massa
Hi Donald,
> From: Griggs, Donald [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 01, 2004 10:46 AM
>
>I suppose that for a system to really care about a leap
> second jump, it
> would have to be at least reasonably synched to the NIST clocks as a
> precondition -- otherwise the normal compu
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 28, 2004 6:57 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] time calculations
>
>
> I also added the ability to put a time value in as the
> modifier and shift the date by that amount.
> -Original Message-
> From: Jay Macaulay [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 27, 2004 10:56 AM
>
> Another solution that would allow using an index would be to
> add another
> column, flatname, and insert the name into that column
> without any accents
> while still ins
> -Original Message-
> From: Michael Hunley [mailto:[EMAIL PROTECTED]
>
> Solution 1: implement your own OrderBy function and call that instead
> Solution 2: Implement a Flatten function that converts
> accented characters
> to their non-accented and, optionally, converts all uppercase
> -Original Message-
> From: zeb warrior [mailto:[EMAIL PROTECTED]
> I've been unable to carrry out your request: The address
>
>[EMAIL PROTECTED]
>
> was already on the sqlite-users mailing list when I received
> your request, and remains a subscriber.
It looks like it's trying
-Original Message-
From: Greg Obleshchuk [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 4:00 PM
To: Williams, Ken; [EMAIL PROTECTED]
Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index
Hi Ken,
>Every sqlite table has an (hidden) index for its OID. W
> -Original Message-
> From: Michael Hunley [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 09, 2004 3:45 PM
> To: Williams, Ken; 'Greg Obleshchuk'; [EMAIL PROTECTED]
> Subject: RE: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index
>
> So, you are
> -Original Message-
> From: Greg Obleshchuk [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 09, 2004 2:38 PM
> To: Michael Hunley; [EMAIL PROTECTED]
> Subject: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index
>
>
> Hi,
> Doing some testing , creating a primary key with the IN
Hi,
I notice that when I have an index on column x, "SELECT MIN(x) FROM table"
and "SELECT MAX(x) FROM table" will use the index, but "SELECT MIN(x),
MAX(x) FROM table" won't. See the output below.
I'm not sure how the optimizer should properly handle this case, but
obviously it could be done.
> -Original Message-
> From: Williams, Ken [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 4:57 PM
> To: SQLite-Users (E-mail)
> Subject: [sqlite] Using multiple indexes?
>
>
> Hi,
>
> Is SQLite currently capable of using more than one inde
Hi,
Is SQLite currently capable of using more than one index in a query? I'm
adding indexes to a table, trying to optimize a query, and I only ever see
one index in the "EXPLAIN" output.
-Ken
-
To unsubscribe, e-mail: [EMAIL
> -Original Message-
> From: Matt Sergeant [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 4:26 AM
> To: Williams, Ken
> Cc: SQLite-Users (E-mail)
> Subject: Re: [sqlite] Error on commit
>
>
> On 29 Jan 2004, at
> Don't know anything about the DBD::SQLite extension. Is there a
> separate mailing list for that? Seems like DBD::SQLite is hosted
> on sourceforge, isn't it? Probably ought to ask there.
There's no separate mailing list, just a bug tracker at http://rt.cpan.org/
. I know Matt reads this l
> -Original Message-
> From: Helphand [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 29, 2004 8:06 PM
> To: Williams, Ken; SQLite-Users (E-mail)
> Subject: Re: [sqlite] Error on commit
>
>
> At 12:23 PM 1/29/04 -0600, Williams, Ken wrote:
>
> &
Hi,
I'm using DBD::SQLite compiled with SQLite version 2.8.11. I'm getting the
following error, with RaiseError => 1:
DBD::SQLite::db do failed: at load_db.pl line 27, <$in_file> line
220663.
(Line 27 is simply $dbh->do("COMMIT"); )
So,
A) Why isn't the error string being displayed as pa
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 5:57 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> Williams, Ken wrote:
> >
> > Hmm - all of thos
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 5:23 PM
> To: Williams, Ken; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> Again, see the SQLite source, in particular the file func
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 1:58 PM
> To: Williams, Ken; 'Drew, Stephen'; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Functions & Keywords
>
>
> > Please excuse the sill
-Original Message-
From: Drew, Stephen [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 5:05 AM
To: '[EMAIL PROTECTED]'
Subject: [sqlite] Functions & Keywords
Hello,
It is straightforward to define a function in SQLite...such as MY_FUNCTION(
).
Hi Drew,
Please excuse
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 20, 2004 11:48 AM
> To: SQLite-Users (E-mail)
> Subject: Re: [sqlite] Setting sqlite-shell preferences
>
> It is suppose to execute commands in ~/.sqliterc prior to giving you
> a prompt. Thi
Hi,
Every time I use the sqlite shell, I'd like to be in column mode, and with
headers turned on. Is there a way to autoexecute ".header on; .mode column"
every time I start up? I think "sqlite -header -column" will do it, but is
there any way to put this in a stored preferences file or somethin
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
>
> You can step straight through the index in linear time. But
> for each index entry you encounter, you have to look up a
> record in the main table in order to get the data. It's the
> second step, the table look
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 10:13 AM
> To: Michael Hunley; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Optimizing a query
>
>
> But it is also still really fast. Do this: Run the same
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 9:22 AM
> To: Williams, Ken
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Optimizing a query
>
>
> Williams, Ken wrote:
> >
> > So, no w
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 13, 2004 6:17 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Optimizing a query
>
>
> > Can anyone suggest a good way to optimize the following query?
> >
> > SELECT count(*) FROM propos
Hi,
Can anyone suggest a good way to optimize the following query?
CREATE TABLE propositions (
verb_id INTEGER NOT NULL,
tag VARCHAR(10) NOT NULL,
start INTEGER NOT NULL,
stop INTEGER NOT NULL );
CREATE TABLE output (
verb_id INTEGER NOT NULL,
tag VARCHAR(10) NOT NULL,
start INTEGE
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> The important thing to understand here, is that you're not stepping
> through a set of results that you have in memory and that
> were extracted
> from the database. You are (at least for simple queries)
> ste
> -Original Message-
> From: Nate Bargmann [mailto:[EMAIL PROTECTED]
>
> While rare there are nasties like this:
> "81565","Why Not Reform the
> ""Squeek-Box?""","Editorials","Young","Sumner B.","1CO",1917,9
> just how does a person handle this case?
With the Text::CSV_XS module, avail
> -Original Message-
> From: [EMAIL PROTECTED]
>
> Maybe something along the lines of this could work. There's
> probably a more
> elegant method than this:
>
> UPDATE output
> SET stop=stop+1
> WHERE ROWID =
> (SELECT output.ROWID
>FROM output, tokens,
>WHERE
Hi Derrell, thanks for the response.
> -Original Message-
> From: [EMAIL PROTECTED]
>
> How about something like this:
>
> UPDATE table1
> SET field23 = (SELECT field42
>FROM table2
>WHERE condition);
Hmm, I'm not sure whether I can use that in
Hi,
Is it possible in SQLite to update a table using information from another
table? Something like the "UPDATE ... FROM" syntax in Postgres, or "UPDATE
table1, table2 ..." syntax in MySQL is what I'm looking for.
If not, can someone suggest a workaround?
-Ken
---
40 matches
Mail list logo
