Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of olliflee@gmail.com designates
 209.85.128.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKkz8Q2sqh-j7z6cYeBF4AvL4XRqrv+x_3p6+dByKT1fZH=2bg@mail.gmail.com>
References: 
 <CAGfq0uuKCRpi8y6+qT1bv5LuX4qJq9YXij+rZgfbQRVA=3-LpA@mail.gmail.com>
	<CAKkz8Q0Wdfv484Dn0sxYBGXmWQ8cbPbM_PQeaXkdLHVLwVEjeA@mail.gmail.com>
	<CAM1R5Hw2vJC1=NDAtMtj_iNbyCr55TCQzUHSzENFHzcye7sMiw@mail.gmail.com>
	<CAKkz8Q2sqh-j7z6cYeBF4AvL4XRqrv+x_3p6+dByKT1fZH=2bg@mail.gmail.com>
Date: Tue, 9 Jul 2013 22:40:40 +0800
Message-ID: 
 <CAM1R5HyUcosh1nf-a4r3oivH6FM1sRRqAhz--a-cjDxpuVuHwQ@mail.gmail.com>
Subject: Re: Purpose of BLOB datatype
From: Ollif Lee <olliflee@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7bd6c64220188704e11525a9

--047d7bd6c64220188704e11525a9
Content-Type: text/plain; charset=UTF-8

Thank you for your patience. That is what I have expected.
PS. Do you know any direct ways in CQL to handle BLOB, just like DataStax
Java driver?


On Tue, Jul 9, 2013 at 4:53 PM, Sylvain Lebresne <sylvain@datastax.com>wrote:

> > Pls explain why and how.
>
> Why and how what?
>
> Not encoding blobs into strings is the "preferred way" because that's
> obviously
> more efficient (in speed and space), since you don't do any encoding pass.
>
> As for how, "use prepared statement" was the "how". What are the exact
> lines of
> code to use to do prepared statements will depends on the client driver you
> use, and you should check your driver documentation.
>
> But, to give you an example, if you use the DataStax Java driver
> (https://github.com/datastax/java-driver), this might look something like:
>
>   PreparedStatement st = session.prepare("INSERT INTO foo(myKey, myBlob)
> VALUES (?, ?)");
>   String myKey = ...;
>   ByteBuffer myBlob = ...;
>   session.execute(st.bind(myKey, myBlob));
>
>
> --
> Sylvain
>

--047d7bd6c64220188704e11525a9
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thank you for your patience. That is what I have expected.=
<div style>PS. Do you know any direct ways in CQL to handle BLOB, just like=
 DataStax Java driver?</div></div><div class=3D"gmail_extra"><br><br><div c=
lass=3D"gmail_quote">
On Tue, Jul 9, 2013 at 4:53 PM, Sylvain Lebresne <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:sylvain@datastax.com" target=3D"_blank">sylvain@datastax.com<=
/a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:=
0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir=3D"ltr"><div class=3D"im"><div>&gt; Pls explain why and how.</div>=
<div><br></div></div><div>Why and how what?</div><div><br></div><div>Not en=
coding blobs into strings is the &quot;preferred way&quot; because that&#39=
;s obviously</div>
<div>
more efficient (in speed and space), since you don&#39;t do any encoding pa=
ss.</div><div><br></div><div>As for how, &quot;use prepared statement&quot;=
 was the &quot;how&quot;. What are the exact lines of</div><div>code to use=
 to do prepared statements will depends on the client driver you</div>

<div>use, and you should check your driver documentation.</div><div><br></d=
iv><div>But, to give you an example, if you use the DataStax Java driver</d=
iv><div>(<a href=3D"https://github.com/datastax/java-driver" target=3D"_bla=
nk">https://github.com/datastax/java-driver</a>), this might look something=
 like:</div>

<div><br></div><div>=C2=A0 PreparedStatement st =3D session.prepare(&quot;I=
NSERT INTO foo(myKey, myBlob) VALUES (?, ?)&quot;);</div><div>=C2=A0 String=
 myKey =3D ...;</div><div>=C2=A0 ByteBuffer myBlob =3D ...;</div><div>=C2=
=A0 session.execute(st.bind(myKey, myBlob));</div>

<div><br></div><div><br></div><div>--</div><div>Sylvain</div></div>
</blockquote></div><br></div>

--047d7bd6c64220188704e11525a9--