Re: [sqlite] unsubsribe plz

Bennie wrote: > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Me too please! ___ sqlite-users mailing list

[sqlite] odd behavior for sqlite/mac

I have an application which uses a sqlite database shared across a network. Under conditions where the database is resident on a PC, and I share it from a mac, and the mac/pc are both contending for access to the database, my mac sometimes turns off it's monitor and enters system "sleep" mode. It

Re: [sqlite] Reusing prepared statements is slower than creating new ones

On 19 Mar 2010, at 10:46pm, Thomas Kopp wrote: >> What are your indexes exactly? > I do have two different indices. One on each field. Indexing each field separately is not the same thing as making one index on both fields. Simon. ___ sqlite-users

Re: [sqlite] Reusing prepared statements is slower than creating new ones

>> I'm confused. Can someone give me a hint, why reusing the prepared query >> is so much slower? > > What are your indexes exactly? I do have two different indices. One on each field. > If you have 2 different indexes for Column3 and Column4 then SQLite > has to choose which index to use during

Re: [sqlite] Question about binding

On Mar 19, 2010, at 3:29 PM, David Bicking wrote: > > > --- On Fri, 3/19/10, Vance E. Neff wrote: > > >> UPDATE table1 set (?, ?, ?) WHERE col1=? and col2=?; >> >> I've never used binding before but have known it is a good >> idea in order >> to avoid injection of bad

Re: [sqlite] Question about binding

--- On Fri, 3/19/10, Vance E. Neff wrote: > UPDATE table1 set (?, ?, ?) WHERE col1=? and col2=?; > > I've never used binding before but have known it is a good > idea in order > to avoid injection of bad stuff. > > Vance > You count the question marks from left to

Re: [sqlite] Question about binding

On Fri, Mar 19, 2010 at 03:13:19PM -0400, Vance E. Neff scratched on the wall: > First of all, I apologize for hijacking the thread! I did not intend > to, I just screwed up! > > Second: > Question about binding: > > I know how to prepare an INSERT state, for example: > INSERT into table1

Re: [sqlite] Question about binding

You can do it like this: UPDATE table1 set col1 = ?, col2 = ?, col3 = ? WHERE col1=? and col2=?; And don't confuse indexes of columns and indexes of parameters. To mention indexes of parameters explicitly I'd suggest to do it like this: UPDATE table1 set col1 = ?1, col2 = ?2, col3 = ?3 WHERE

[sqlite] Question about binding

First of all, I apologize for hijacking the thread! I did not intend to, I just screwed up! Second: Question about binding: I know how to prepare an INSERT state, for example: INSERT into table1 values (?, ?, ?); and in the wrapper I am using I can specify the index # (1, 2 or 3) of the column

Re: [sqlite] R*Tree and sqlite3_last_insert_rowid() API - possible bug?

On Mar 19, 2010, at 11:04 PM, Minář Petr wrote: > Hi, > I was experimenting a bit with R*Tree extension in my project and I > encountered weird behavior. Consider following code: > > CREATE VIRTUAL TABLE table USING rtree > ( > Id INTEGER NOT NULL PRIMARY KEY, > MinXREAL,

Re: [sqlite] R*Tree and sqlite3_last_insert_rowid() API - possible bug?

You just hijacked someone else's thread. That is really disrespectful toward the original poster as his question hasn't even been answered yet, but is already "polluted" with a different conversation. Starting a new thread is free. Please start a new thread for a new issue. On Fri, Mar 19, 2010

[sqlite] Available alternatives to syntax diagrams in documentation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 While trying to look up the syntax of a command in the documentation, I noticed that it switched to syntax diagrams in 3.6.4. I use a screen reader, and these diagrams are useless to me. What alternatives are available besides using the 3.6.3 docs

[sqlite] R*Tree and sqlite3_last_insert_rowid() API - possible bug?

Hi, I was experimenting a bit with R*Tree extension in my project and I encountered weird behavior. Consider following code: CREATE VIRTUAL TABLE table USING rtree ( Id INTEGER NOT NULL PRIMARY KEY, MinXREAL, MaxXREAL, MinYREAL, MaxY

Re: [sqlite] Reusing prepared statements is slower than creating new ones

> I'm confused. Can someone give me a hint, why reusing the prepared query > is so much slower? What are your indexes exactly? If you have 2 different indexes for Column3 and Column4 then SQLite has to choose which index to use during preparing. According to your results in first general case it

[sqlite] FTS3 code compile

In the FTS3 code, there are still some calls to low-level C char handling functions. Shouldn't the corresponding sqlite3* functions be called instead, for consistency? Here are the names I've to replace before compile in order to get rid of these functions in my statically linking of the

[sqlite] Reusing prepared statements is slower than creating new ones

I'm using SQLite3 on an embedded system for logging some kind of information. I have 4 SQL-statements (2x SELECT, 1x INSERT, 1x DELETE) which are called every time I information has to be logged (which can be several times within a second or only once in an hour). I decided to wrap these 4

[sqlite] unsubsribe plz

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Updated FTS3 compression patch

Hello! Patch is here http://sqlite.mobigroup.ru/src/vinfo/d3d9906674 Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users