How to put a BLOB in SQLite?

snowtiger · by **snowtiger** » Thu Feb 21, 2008 3:48 pm

Has anybody an idea, how to add an BLOB to the Android SQLite database?

I can see only methods for simple filetypes: String, Int, Double, Byte,...
In my case, i want to put a drawable or bitmap to my database. It starts like this:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

[...]ContentValues values = new ContentValues();
 
                values.put(Scheme.Images.IMAGE_ID, imageId);
 
                ByteArrayOutputStream bos = new ByteArrayOutputStream();
 
        ObjectOutputStream out;
 
                try {
 
                        out = new ObjectOutputStream(bos);
 
                        out.writeObject(myImage);
 
                } catch (IOException e) {
 
                        e.printStackTrace();
 
                }
 
                values.put(Scheme.Images.THUMB_DATA, bos.toByteArray());
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

But the last line doesn't work, only byte is accepted, no byteArray

plusminus · by **plusminus** » Thu Feb 21, 2008 4:10 pm

Hello snowtiger,

BLOB is not supported and probably wont be implemented in future.

You could do that using a content provider, like Google suggests :arrow:

http://code.google.com/android/devel/da ... ntprovider :

# If you are exposing byte data, such as a bitmap file, the field that stores this data should actually be a string field with a content:// URI for that specific file. This is the field that clients will call to retrieve this data. The content provider for that content type (it can be the same content provider or another content provider — for example, if you're storing a photo you would use the media content provider) should implement a field named _data for that record. The _data field lists the exact file path on the device for that file. This field is not intended to be read by the client, but by the ContentResolver. The client will call ContentResolver.openOutputStream() on the user-facing field holding the URI for the item (for example, the column named photo might have a value content://media/images/4453). The ContentResolver will request the _data field for that record, and because it has higher permissions than a client, it should be able to access that file directly and return a read wrapper for that file to the client.

Regards,
plusminus

snowtiger · by **snowtiger** » Thu Feb 21, 2008 4:57 pm

Thanx for ur reply +-,

I am already using a content provider. The problem is, that I want to do some P2P stuff in future and exchange images between users. So it would be much easier to have one database, where I can put in my imageId, tags, desription and a small thumbnail.
Besides I don't really like the google pattern to have thousands of files in one directory. If I use the insertImage-method for my current testset of 300 images, I get a new directory on my sdcard with 900 files/images. I would prefer the 300 images on my sdcard and 1 database with all thumbnails.

Well maybe I will have a look at db4o...

How to put a BLOB in SQLite?

How to put a BLOB in SQLite?

Who is online