[sqlite] Nested transactions

Hello, just a short question: With the current sqlite version, is it possible to have nested transactions, e.g. exec select ... from table while (fetch row) { if (criteria) exec delete from t where ... } which means execute some 'select', fetching the

Re: [sqlite] The SQL Guide to SQLite

Robert Citek wrote: > Anyone know of a way to preview the index, the table of contest, or > some sample chapters? I tried viewing form the Lulu site, but no > luck. It appears it has not been scanned by Google yet. However a limited preview of the other book "The

Re: [sqlite] SQLite (3) Documentation

Hello, So, I would like to take on an project to collect all the information and restructure it in a comprehensive SQLite 3 Manual. Sqlite.org already has (almost) all the information for the book so, if whoever has the copyright to that material allows it, it's a matter of copying, pasting

Re: [sqlite] Blob handling in command line tool sqlite3

On Sat, 9 Jun 2007, Joe Wilson wrote: CREATE TABLE t(b blob); INSERT INTO "t" VALUES(X'ABCD'); select quote(b) from t; X'ABCD' Thanks, Joe. I am just wondering why this 'quote' is not the default behavior on binary columns when the 'sqlite3' tool is used. Best regards Guido

Re: [sqlite] Blob handling in command line tool sqlite3

Joe Wilson wrote: .dump yes, but dump gives me all rows for the table and not those that are the result of a query (which might have a WHERE clause). Is there no way for format the output of the select? Regards Guido

[sqlite] Blob handling in command line tool sqlite3

Hello, when using a blob column in the command line tool 'sqlite3' im getting garbled output when selecting from a table that contains a blob column. Is there a way to get the blob column output in escaped format, like its used in the insert statement? Example: $ sqlite3 SQLite version

[sqlite] Mailinglist archive files

Hello, I would like to download compressed archives of the mailing list postings, preferable in mbox format. Does somebody know where I could get those archives? The three webpages dealing with the archive appear to be offering only webaccess. If there is no publically available method,