Re: [sqlite] question about php_pdo_sqlite

Ok, finally I found the problem is that the PHP and Apache are installed in local drive and I put the sqlite database file on a remote file server which is a Linux / Samba. I can use sqlite3.exe to open that remote database with a mapped remote drive. And Insert, Update and Delete have no

[sqlite] Re: Query performance issues - index selection

Using Richard's suggestion of changing the where clause of my query to where +utime >= 1146441600 and +utime < 114912000 did force sqlite to use the index that gave better performance. However, I'm seeing some strange behavior that I'm hoping someone can shed some light on. With the time

Re: [sqlite] Query performance issues - index selection

Kurt, Thanks, the single primary index you suggested does give us the desired results. Steve Kurt Welgehausen wrote: Steve Green <[EMAIL PROTECTED]> wrote: CREATE UNIQUE INDEX pk_data on data( utime, r_id, u_id ); ... CREATE INDEX ix_data_ut on data( u_id, utime ); Wouldn't a unique

Re: [sqlite] Multithreading. Again.

Florian Weimer <[EMAIL PROTECTED]> wrote: > > As long as no prepared statements are outstanding, you should > > be safe moving sqlite database connections across threads, as > > of version 3.3.1. The rules are not really quite that strict, > > but the exact rules are more complex and this strict

Re: [sqlite] Strange behavior with sum

* Klint Gore <[EMAIL PROTECTED]> [2006-06-02 07:30]: > sqlite> select cast(sum(f1) as double)/cast(sum(f2) as double) from bob; > 0.869779988128673 Just casting one of them is sufficient, btw. Regards, -- Aristotle Pagaltzis //

RE: [sqlite] Multithreading. Again.

I don't think it's that uncommon to ask the user of the statement to finalize database resources explicitly, even in a managed environment. For example, Java collects memory, but the programmer must explicitly close network, file, database, and other resources. In java, I do this in a finally

Re: [sqlite] Multithreading. Again.

> As long as no prepared statements are outstanding, you should > be safe moving sqlite database connections across threads, as > of version 3.3.1. The rules are not really quite that strict, > but the exact rules are more complex and this strict rule > gives you an extra margin of safety. Is it

Re: [sqlite] .import difficulty

* cstrader232 <[EMAIL PROTECTED]> [2006-06-02 15:40]: > strange error though because ";" can't be part of a tablename > can it? sqlite> create table [b;] (a,b,c); sqlite> select * from sqlite_master; type name tbl_name rootpage sql -

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

A. Pagaltzis wrote: This suggests a different strategy: alternate between sending opt-out and opt-in mails. Indiscriminate autoresponders will unsubscribe themselves when they get an opt-out mail; people who throw the mail away will silently drop out after failing to respond to the opt-in mail.

Re: [sqlite] .import difficulty

thanks all. strange error though because ";" can't be part of a tablename can it?

Re: [sqlite] full text search

Martin Pfeifle <[EMAIL PROTECTED]> wrote: > Dear all, > I have just seen that there are some thoughts going on to incorporate full > text search into SQLite. > http://www.sqlite.org/cvstrac/wiki/wiki?p=FullTextIndex > What is the current status on that project? Work on this is progressing. It

Re: [sqlite] Multithreading. Again.

"Peter Cunderlik" <[EMAIL PROTECTED]> wrote: > > > 1. As of SQLite 3.3.5, there is no multithreading (MT) problem with > > > the SQLite itself. All problems come from the underlying OS libraries. > > > > I would argue that this has always been the case. But beginning > > in version 3.3.1, SQLite

Re: [sqlite] .import difficulty

* cstrader232 <[EMAIL PROTECTED]> [2006-06-02 15:00]: > I'm having trouble importing. I'm using sqlite3 from dos. > > sqlite3 test.db; > create table b (a, b, c); > .import "test.txt" b; > > returns "no such table b" No, it reports `Error: no such table: b;` – note the semicolon. A table

Re: [sqlite] .import difficulty

try .import "test.txt" b ; On 6/2/06, cstrader232 <[EMAIL PROTECTED]> wrote: I'm having trouble importing. I'm using sqlite3 from dos. sqlite3 test.db; create table b (a, b, c); .import "test.txt" b; returns "no such table b" tia -- With Best Regards, Vishal Kashyap.

[sqlite] .import difficulty

I'm having trouble importing. I'm using sqlite3 from dos. sqlite3 test.db; create table b (a, b, c); .import "test.txt" b; returns "no such table b" tia

Re: [sqlite] Multithreading. Again.

> 1. As of SQLite 3.3.5, there is no multithreading (MT) problem with > the SQLite itself. All problems come from the underlying OS libraries. I would argue that this has always been the case. But beginning in version 3.3.1, SQLite has taken additional steps to partially work around problems in

[sqlite] full text search

Dear all, I have just seen that there are some thoughts going on to incorporate full text search into SQLite. http://www.sqlite.org/cvstrac/wiki/wiki?p=FullTextIndex What is the current status on that project?