BLOB support in Gears Database

[aahmad]

In version 0.5, will there be support for loading and saving BLOBs
into the Gears database? If not, I suppose I could:
1) generate a unique URL,
2) use LocalServer.captureBlob to save the data
3) store the URL in the database in place of the BLOB itself.

However, in the latter case it would be nice (but not required, I
suppose) if ResourceStore had a method on it for returning an unused
URL name.

[Aaron Boodman]

No, there won't be any support for storing blobs in the database in
0.5. The workaround you suggested will work fine, but you'll have to
come up with the unique URL yourself.

- a

[Srikanth]

The SQLite FAQ mentions about storing blobs however it throws error
while inserting blob type.

http://sqlite.org/faq.html#q10

BTW what is the SQLite version used in Gears.

Srikanth

On Nov 6, 10:32 am, Aaron Boodman <a...@google.com> wrote:
> No, there won't be any support for storing blobs in the database in
> 0.5. The workaround you suggested will work fine, but you'll have to
> come up with the unique URL yourself.
>
> - a
>

[Michael Nordman]

On Fri, Nov 14, 2008 at 5:59 AM, Srikanth <srik...@gmail.com> wrote:

The SQLite FAQ mentions about storing blobs however it throws error
while inserting blob type.

This is expected behavior right now. There is no binding from a GearsBlob to the SQLite3 blob datatype.

 

http://sqlite.org/faq.html#q10

BTW what is the SQLite version used in Gears.

3.6.1