[sqlite] tool to browse a sqlite database

I'm loking for some gui tools for looking at and changing my sqlite database, the only ones I know of are the firefox extension and sqlitemanager. the firefox extension fails with: Error in opening file messages.sqlite - perhaps this is not an sqlite db file Exception Name: NS_ERROR_FAILURE

[sqlite] multiple tables within a database

what's the general rule for deciding when to put multiple tables within a single sqlite db file? I think the answer is something like you put tables together in one database file if they refer to different aspects of the same data element and you put them in separate database files if there's no

Re: [sqlite] last N records

Dennis Cote wrote: Eric S. Johansson wrote: what is the easiest way to hold on to the last N records and delete all older? I can't figure out the right where expression. --- eric Eric, I posted some sample code to use a table as FIFO (last N records) to the list a while ago. See http

[sqlite] last N records

what is the easiest way to hold on to the last N records and delete all older? I can't figure out the right where expression. --- eric -- Speech-recognition in use. It makes mistakes, I correct some. - To

Re: [sqlite] Re: create or update question

Igor Tandetnik wrote: Eric S. Johansson <[EMAIL PROTECTED]> wrote: I'm trying to figure out how to do do the following: if the record exists Update record with calculation ( a = a + v) else insert record with default values It seems like the "insert or replace into" capab

[sqlite] create or update question

I'm trying to figure out how to do do the following: if the record exists Update record with calculation ( a = a + v) else insert record with default values It seems like the "insert or replace into" capabilities is close to what I need but I can't figure out how to update with a default

Re: [sqlite] How fast is the sqlite connection created?

Samuel R. Neff wrote: Some of this performance gain is probably related to caching data and query plan, not just opening the connection, but still that caching is connection related and is lost when you close the connection so it's a very real-world valid comparison. no surprise that connect()

[sqlite] more questions from the reasonably naïve

I think some of these questions fall in the category of "running in the dark with scissors". If it's a simple matter of I need to read something, just point me at the appropriate documentation. I'm trying to get a handle on this cursor thing. obviously it preserves state of some sort but

Re: [sqlite] query on match between application and sqlite

Eric S. Johansson wrote: Again, I do most sincerely apologize for size of this request. I've spent 30 years avoiding databases and I guess this is payback. :-) Any advice, good online tutorials on SQL, or feedback would be valued. urk. I hate it when I forget to ask for what I need after

[sqlite] query on match between application and sqlite

I apologize if this comes across as a "do my homework for me" type of query but I'm in a bit of a bind and I'm trying to come up to some reasonable amount of knowledge in less than no time. I've been using ad hoc DBM files for a variety of small databases and well, it's crumbling. I'm seeing