[sqlite] sqlite3_step()

2010-01-16 Thread Mike Johnston
Using sqlite 3.6.22.  Here's my sql SELECT sno, lname, fname FROM addressbook where sno>? Suppose your stepping through a 100 row result set.  I'm calling sqlite3_step(), getting my values all good.  If I were to call sqlite3_bind_int() function with a new value for my where clause at row 50,

[sqlite] SQLITE_BUSY

2009-12-01 Thread Mike Johnston
I have two threads in a Linux process using sqlite 3.6.12 in shared cache mode. One thread opens the database file in read only mode (sqlite3_open_v2()), sets to read uncommitted and only ever performs selects from the database. The other thread inserts, updates and deletes rows from the

Re: [sqlite] database filename

2008-10-18 Thread Mike Johnston
Subject: Re: [sqlite] database filename To: sqlite-users@sqlite.org Date: Saturday, October 18, 2008, 3:56 PM "Mike Johnston" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Given a sqlite3 * database handle, is there a way to retrieve the > filena

[sqlite] database filename

2008-10-18 Thread Mike Johnston
Given a sqlite3 * database handle, is there a way to retrieve the filename used to open the database? TIA __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] fetching and updating

2008-04-21 Thread Mike Johnston
the sqlite3_step finishes and I do the release on the prepared statement? Is this correct? Igor Tandetnik <[EMAIL PROTECTED]> wrote: "Mike Johnston" wrote in message news:[EMAIL PROTECTED] > I'm running the 3.5.7 version now. My understanding was that if I > have a prepared stateme

Re: [sqlite] fetching and updating

2008-04-21 Thread Mike Johnston
connection but different thread (assuming sqlite compiled with multi-thread option turned on). Many thanks Igor Tandetnik <[EMAIL PROTECTED]> wrote: "Mike Johnston" wrote in message news:[EMAIL PROTECTED] > I'm in a loop processing the result set using sqlite3_step. I need

[sqlite] fetching and updating in Ruby

2008-04-18 Thread Mike Johnston
Hi, Does anyone on the list use the sqlite3 gem with Ruby? Is this list ok to post sqlite/ruby questions? Many thanks in advance Mike - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[sqlite] last_insert_rowid

2008-03-27 Thread Mike Johnston
Hi, So I'm using the last_insert_rowid() with no issue. The note at http://www.sqlite.org/c3ref/last_insert_rowid.html states that the function returns unpredictable results should "a separate thread" do a new insert. Does that apply to a separate process as well? I have two processes

[sqlite] monitoring inserts

2007-09-11 Thread Mike Johnston
It seems clunky no real specific reason. I tried it out today and it's quite fast and simple. I'm not sure I could say the same thing about a lot of IPC stuff. thanks - Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for

[sqlite] Monitoring for inserts

2007-09-11 Thread Mike Johnston
What is the best way to get notified a table changed? I would like to monitor a table for inserts without resorting to polling. Anyway to have a trigger call a 'C' function or something? TIA, Mike - Yahoo! oneSearch: Finally, mobile search that gives

Re: [sqlite] Proposed incompatible change to SQLite

2007-08-09 Thread Mike Johnston
Game on!! We'd love to see this happen. [EMAIL PROTECTED] wrote: We are considering a change to the SQLite API which is technically not backwards compatible. On the other hand, it is difficult to imagine a situation where the change would cause anyone any serious hardship. We suspect that most

Re: [sqlite] Views

2007-07-09 Thread Mike Johnston
Mario Figueiredo wrote: > On 7/6/07, Joe Wilson wrote: > > --- Mike Johnston wrote: > > > I have to join three tables to retrieve bits of data from each. I'm > > > wondering if I use a > view > > > are there any performance issues vs. issuing t

[sqlite] Views

2007-07-06 Thread Mike Johnston
n Fri, 2007-07-06 at 07:18 -0700, Mike Johnston wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. > > Also, is it quicker to have sqlite

[sqlite] Views

2007-07-06 Thread Mike Johnston
I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view are there any performance issues vs. issuing the complete 3 table join query in code. Also, is it quicker to have sqlite do joins on primary keys between tables instead of doing three separate single

Re: [sqlite] Re: sqlite3_column_xxx question

2007-05-15 Thread Mike Johnston
Absolutely but it seems like duplicate effort if sqlite already has the info. Any guess if this is a big deal to put into the source? Igor Tandetnik <[EMAIL PROTECTED]> wrote: Mike Johnston wrote: > While using sqlite3_step(), is there a clean easy way to retrieve the > data by

[sqlite] sqlite3_column_xxx question

2007-05-15 Thread Mike Johnston
While using sqlite3_step(), is there a clean easy way to retrieve the data by column name instead of by ordinal? I know I can convert an ordinal to a column name but not the other way around. TIA, Mike - Take the Internet to Go: Yahoo!Go puts the

[sqlite] Column order in resultset

2007-05-12 Thread Mike Johnston
When doing a "select * from foo" and using sqlite3_step() with the associated sqlite3_column_xx funcs, is the order of the columns in the resultset deterministic? What is the rule that defines what the order? it seems to be the order of the create table statement but I can't seem to find

[sqlite] Select columns & performance

2007-04-11 Thread Mike Johnston
Are there any significant performance benefits by limiting the number of columns in a single table select statement? Does joining (<5 tables) make a significant difference to that answer? TIA - TV dinner still cooling? Check out "Tonight's Picks"

[sqlite] sqlite3_create_module()

2007-04-09 Thread Mike Johnston
Hi, The docs for "CREATE VIRTUAL TABLE" refer to this function (in subject line) but I can't seem to see find it anywhere. I see the full text search uses modules but some docs would be helpful on how to create my own module. TIA, Mike - Bored stiff?

[sqlite] in memory databases

2007-04-06 Thread Mike Johnston
Hi, Is it possible to have memory databases located at a specific memory address? I have a battery backed memory I'd like to store specific information apart from the main database. Thanks, Mike - No need to miss a message. Get email on-the-go with Yahoo!