From: "Ara.T.Howard" <ahoward@...>
Date: 2004-07-05T09:17:43+09:00
Subject: Re: SQLite/Ruby update pending

On Mon, 5 Jul 2004, Jamis Buck wrote:

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

considering the nature of the binary data i am usually working with (satelite
data) it makes life much easier to simply store the path to the blob in the
database and use the file system.  it's a pain to first extract a 1gb blob and
write it to file before i can open it up in envi or something like that...

-a
--
===============================================================================
| EMAIL   :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE   :: 303.497.6469
| A flower falls, even though we love it;
| and a weed grows, even though we do not love it. 
|   --Dogen
===============================================================================