Re: [sqlite] sqlite3 statements and database changes

Is there any other way to detect if an prepared statement was invalidated? A different error code would really help on this issue or a function like sqlite3_isinvalid. Check out the sqlite3.h file: /* ** Return TRUE (non-zero) of the statement supplied as an argument needs ** to be recompiled. A

Re: [sqlite] [ANN] SQLite Analyzer 3

Sergey, Have you Delphi components for SQLite available? Serge Liber > Hello SQLite users, > > I'm pleased to announce the release of SQLite Analyzer. > > http://www.kraslabs.com/files/sqlanlz.exe > > -- > Best regards > > Sergey Startsev > SQLite Analyzer - SQLite database management

Re: [sqlite] Attributenames in Views

Hi, as requested I have created Ticket 1162. Thanks for your quick reply. - Jan -- Jan StÃrtz Software Engineer CONTACT Software GmbH Wiener Str. 1-3 28359 Bremen - Germany - On 14.3.2005 17:28, D. Richard Hipp wrote: On Mon, 2005-03-14 at 16:44

RE: [sqlite] [ANN] SQLite Analyzer 3

Serge, Check ZeosLib at http://www.zeoslib.net/ Although it works only for sqlite 2.8x; it is supposed to be the best db component for Delphi. -Guru Kathiresan > -Original Message- > From: Serge Liber [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 15, 2005 12:29 AM > To:

Re: [sqlite] Row count after prepare

--- Leif Jensen <[EMAIL PROTECTED]> wrote: > Hi All, > > I'm quite new to SQLite, but like it very much. > >I am trying it out for an existing applicationm which seems good, but > I have one problem: > >How do I get the number of rows in the result set after having called >

Re: [sqlite] [ANN] SQLite Analyzer 3

Quoting Serge Liber <[EMAIL PROTECTED]>: Sergey, Have you Delphi components for SQLite available? Serge Liber Hello SQLite users, I'm pleased to announce the release of SQLite Analyzer. http://www.kraslabs.com/files/sqlanlz.exe -- Best regards Sergey Startsev SQLite Analyzer - SQLite database

Re: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

> I have not tried this with SQLite, but if I was using SQLite for such > an app, I assume I would need to serialize all such writes through a > single thread or process. E.g., in my web server, the connection > thread servicing the user request would send a message to my one > single db writer

RE: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

Regarding: ... As an example the ethernet card you're probably using right now. ... they detect the collision, wait a short period, and retry. For those using Unix/Linux, would this provide the queuing needed for those apps with numerous parallel writes?

Re: [sqlite] Row count after prepare

Hi Dan, Ah yes, of course (I knew this was a newbie question ;-) ). So I guess I will have to use sqlite3_get_table in this case. Thank you for the enlightment, Leif Dan Kennedy wrote: --- Leif Jensen <[EMAIL PROTECTED]> wrote: Hi All, I'm quite new to SQLite, but like it very

Re: [sqlite] Row count after prepare

> ... guess I will have to use sqlite3_get_table in this case Be aware that sqlite3_get_table is no longer a recommended API and may not do everything you want. See Regards

RE: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

The problem with queuing all writes is that you're playing fast and loose with the isolation of the transactions. Imagine two threads (A and B). Each reads the same value, increments it, and then writes it (Ar Aw, and Br Bw). If the operations interleave properly (Ar Aw Br Bw), the final values

RE: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

> Regarding: ... As an example the ethernet card you're probably using > right > now. > ... they detect the collision, wait a short period, and retry. > > For those using Unix/Linux, would this provide the queuing needed for > those > apps with numerous parallel writes? >

[sqlite] Conversion mysql -> sqlite

Hi all, I know very little about mysql and sqlite - I've only played around a little bit with databases, so I'm a newbie in this area. There's a blogger called Wheatblog that I've been trying to convert from mysql to sqlite so I don't have to run a full RDMBS deamon on my underpowered machine

Re: [sqlite] Conversion mysql -> sqlite

On 15-mrt-05, at 21:26, Peter Jay Salzman wrote: It appears that the error is a "syntax error" near where my arrow (<--) is. Can someone throw some charity my way? Is there anything obviously wrong here? Yes, remove the "TYPE=MyISAM" part. This is a MySQL specific extension. HTH, - Rob

RE: [sqlite] Conversion mysql -> sqlite

Peter Jay Salzman wrote: > Hi all, > > I know very little about mysql and sqlite - I've only played > around a little bit with databases, so I'm a newbie in this area. > > There's a blogger called Wheatblog that I've been trying to > convert from mysql to sqlite so I don't have to run a full >

Re: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

On Tue, Mar 15, 2005 at 01:24:51PM -0500, Ned Batchelder wrote: > The best solution is to rollback entire transactions when the database is > busy. This means structuring your code so that all transactions can > rollback and retry. In my experience, this is necessary (though *far* less >

[sqlite] Re: Vacuum Error with 2.8.16

Mitchell Vincent <[EMAIL PROTECTED]> writes: > D. Richard Hipp wrote: >> Your database schema became corrupted. I do not know how it >> happened. >> I am unable to reproduce the problem. Without additional information >> there is nothing more I can do. > > What additional information can I

Re: [sqlite] Conversion mysql -> sqlite

On Tue 15 Mar 05, 9:36 PM, Rob Laveaux <[EMAIL PROTECTED]> said: > > On 15-mrt-05, at 21:26, Peter Jay Salzman wrote: > > >It appears that the error is a "syntax error" near where my arrow > >(<--) > >is. Can someone throw some charity my way? Is there anything > >obviously > >wrong

[sqlite] mysql_insert_id()

Sorry to ask this, but I just want to make sure there aren't any surprises. There's a mysql function: mysql_insert_id( $db_handle ); that returns the ID number of an AUTO_INCREMENT column by the previous INSERT query. I've replaced the call with a sqlite call that sounds like it does the

Re: [sqlite] Row count after prepare

Hi Leif: Will "Select Count(*) from (Your_SQL)" give you what you want? Be careful if Your_SQL includes Group By clause, don't know if work as expected. Marcelo

Re: [sqlite] Row count after prepare

Hi Marcelo, It would, but I don't know the contents of the SQL at the point where I need get the row count, so I would have to scan the statement. Putting in the extra 'count(*)' all over is not really possible. Does anyone know the timing of a sqlite3_step() compared to sqlite3_step()

Re: [sqlite] Conversion mysql -> sqlite

At 3:26 PM -0500 3/15/05, Peter Jay Salzman wrote: And here's how I've tried to implement it on sqlite using PHP. Note that DB_query() is a wrapper for sqlite_query(). I've changed the "auto_increment" to "INTEGER PRIMARY KEY", as the FAQ said. I'm very new to SQL, but I guess "INTEGER PRIMARY