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

[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 of the select?



   

Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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?



   

Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Blob handling in command line tool sqlite3

[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 3.3.17
Enter ".help" for instructions
sqlite> create table t (x blob);
sqlite> insert into t values (X'ccaaffee');
sqlite> select * from t;

sqlite>

I would like to see the X'ccaaffee' again as result of the 'select'.

Regards

Guido

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Mailinglist archive files

[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, any private offer to send me 
those files by email would be most welcome.


Regards,

Guido

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Amalgamation questions

[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 will generate it from 3.3.17... just want to make
sure I have to do that :)
 
2) With the old way of configuring, generating and building the sqlite
library, I have a makefile that builds both a linkable library as well
as an installable command-line tool. With the amalgamation, I no longer
need to build the linkable library because I can directly drop it into
my project... but then what is the recommended way to also build the
command-line tool and install it, under this paradigm?
 
3) Is there a set of compile-time options that I'd have to include in my
project makefile (which would now include the amalgamation of sqlite),
that would otherwise have been in sqlite's own makefile under the old
paradigm?
 
Thanks!
Brett

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

[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 appears.

Thanks again

Tim

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 PROTECTED]
-