Gavin Sinclair wrote:
> I tend to base64-encode any binary data.  That's unlikely to please
> people who need performance, though.  I don't know what the "best
> practice" is, but it would be nice to identify it and provide it in
> your package.

I see what you mean. I've been using base64 to encode/decode as well. 
(In fact, the latest version of sqlite-ruby provides two new convenience 
methods of the Database class, 'encode' and 'decode', that use Base64 
and Marshal to serialize and unserialize objects.)

Until SQLite provides support for binary data (is that in sqlite3?), 
there doesn't seem to be a whole lot else you *can* do, at least nothing 
as convenient. Does anyone else have any suggestions? What have the rest 
of you been doing for storing binary data in a sqlite database?

-- 
Jamis Buck
jgb3 / email.byu.edu
http://www.jamisbuck.org/jamis

ruby -ropenssl 
-e'k="01234567";p((c,c.padding,c.iv,c.key=OpenSSL::Cipher::BF.new,0,k,k*2)[0].decrypt.update("1A81803C452C324619D319F980D5B84DBB45FC0FE2BAA045".scan(/../).map{|n|n.to_i(16).chr}.join))'