RE: [sqlite] Why do you use SQLite? Comments for an article needed

2007-06-09 Thread Tim Anderson
Many thanks to those who have commented (more are welcome of course; though I won't be able to use all of them). I'll post a link to the piece when it appears. Thanks again Tim - To unsubscribe, send email to [EMAIL

Re: [sqlite] Why do you use SQLite? Comments for an article needed

2007-06-09 Thread Lucas (a.k.a T-Bird or bsdfan3)
I personally like it for embedded (in other applications) jobs because of its small code footprint compared to a RDBMS. Tim Anderson wrote: Many thanks to those who have commented (more are welcome of course; though I won't be able to use all of them). I'll post a link to the piece when it

[sqlite] Amalgamation questions

2007-06-09 Thread Brett Keating
Hi, I am interested in upgrading my sqlite3, and the amalgamation looks like an interesting option. However I have some questions. 1) The page says with 3.3.18, the amalgamation will be available for direct download. Is 3.3.18 not available yet? It's not on the download page. If it's not I

[sqlite] Mailinglist archive files

2007-06-09 Thread Guido Ostkamp
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,

[sqlite] Blob handling in command line tool sqlite3

2007-06-09 Thread Guido Ostkamp
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

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

2007-06-09 Thread Joe Wilson
.dump > 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?

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

2007-06-09 Thread Guido Ostkamp
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

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

2007-06-09 Thread Joe Wilson
CREATE TABLE t(b blob); INSERT INTO "t" VALUES(X'ABCD'); select quote(b) from t; X'ABCD' > 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