Fwd: Urgent Question

[D. Richard Hipp]

Begin forwarded message:

> From: Ahmad Hazim <ahmad.hazim@...>
> Date: November 5, 2009 5:57:38 AM EST
> To: "sqlite@..." <sqlite@...>
> Subject: Urgent Question
>
> Hello,
> Please I’m new using SQLite3 and I have to use it with blobs, so  
> please I want from you to send me a full example on how to use blobs  
> (read/write) with full explained documentation.
> Please respond rapidly..
>
> Ahmad Hazim
> Core Extension Team
> Email : ahmad.hazim@...
> Tel: + 961 6 430067 - Mob: + 961 70 754334
>
>
> This electronic message together with the information transmitted in  
> or attached to it contains privileged and confidential information  
> and is intended for the use of the addressee only.  Any review,  
> dissemination, access, copying, disclosure, use, retransmission,  
> redistribution, other use of, or taking of any action in reliance  
> upon, of this message, any of its contents or any information in  
> whole or part that you might learned from this message by anyone  
> without prior permission of the sender is strictly prohibited.  If  
> you have received this message in error, please delete the e-mail  
> and all attachments (if any), and destroy any copies that you have  
> made. and notify the sender by reply.
> Although this e-mail and any attachments are believed to be free of  
> any virus or other defect that may affect any computer system into  
> which it is received and opened, it is the responsibility of the  
> recipient to ensure that it is virus free. No responsibility is  
> accepted by Intelligile for any loss or damage arising in any way  
> from the use of this e-mail or its attachments. E-mails are not  
> secure and cannot be guaranteed to be error-free as they can be  
> intercepted, altered, lost or destroyed. By communicating with us by  
> e-mail you are deemed to have accepted these risks.
> Intelligile may monitor outgoing and incoming e-mails and other  
> telecommunications on its e-mail and telecommunications systems. By  
> communicating with us by e-mail you give your consent to such  
> monitoring.
>
>

D. Richard Hipp
drh@...



_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Gary_Gabriel]

>> Hello,
>> Please I’m new using SQLite3 and I have to use it with blobs, so  
>> please I want from you to send me a full example on how to use blobs  
>> (read/write) with full explained documentation.
>> Please respond rapidly.
Hi- try this example. Blob Example
<http://www.sqlite.org/cvstrac/wiki?p=BlobExample>

Here's the wiki for more focused info- Wiki
<http://www.sqlite.org/cvstrac/wiki>

- Gary Gabriel

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Tim Romano]

I am encountering significant differences in the way the data libraries
for SQLite produced by a "major player" are handling joins, unions, and
inline views, in combination, compared to several other GUI front ends
for SQLite which have been well-received and which jibe with each
other.  Is there a standard test-harness that will reveal the degree of
SQLite-compatibility of these libraries?  Can I point these libraries at
a harness database, run a set of standard queries, and compare the
results with what ought to have been produced?



_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Simon Slavin-3]

On 6 Nov 2009, at 4:08am, Tim Romano wrote:

> I am encountering significant differences in the way the data  
> libraries
> for SQLite produced by a "major player" are handling joins, unions,  
> and
> inline views, in combination, compared to several other GUI front ends
> for SQLite which have been well-received and which jibe with each
> other.  Is there a standard test-harness that will reveal the degree  
> of
> SQLite-compatibility of these libraries?  Can I point these  
> libraries at
> a harness database, run a set of standard queries, and compare the
> results with what ought to have been produced?

I don't think there's any automated way of doing it.  You may have to  
look through the results for the strange behaviour you think exists,  
and without knowing exactly which features you're talking about it's  
hard to tell you where to look.  But this page

<http://www.sqlite.org/testing.html>

explains SQLite's own testing suites, and tells you where to find two  
out of three of them.  You may be able to use these to prove that your  
"mayor player"'s code is wrong, or perhaps even vice versa.  Does that  
help ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Tim Romano]

Very helpful, Simon. Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users