Home ›

bytearray

Store images/files in database

Mon, 05/03/2010 - 08:19 | by gabor
SDK Version: 
M3

Hoever the practice is to store them normally and save the access route (Uri), sometimes it can be handy to store files/images completely in database.
In sqlite database there are only a few data types, so its easy to choose: files can be stored in a text as a ByteArray.

Lets see a sample code, where we download an image from the Internet then store it in the local database:

  1. //where we want to download it from
  2. URL url = new URL(IMAGE_URL);  //http://example.com/image.jpg
  3. //open the connection
  4. URLConnection ucon = url.openConnection();
  5. //buffer the download
  6. InputStream is = ucon.getInputStream();
  7. BufferedInputStream bis = new BufferedInputStream(is,128);
  8. ByteArrayBuffer baf = new ByteArrayBuffer(128);
  9. //get the bytes one by one
  10. int current = 0;
  11. while ((current = bis.read()) != -1) {
  12.         baf.append((byte) current);
  13. }
  14.  
  15. //store the data as a ByteArray
  16. //db is a SQLiteDatabase object
  17. ContentValues dataToInsert = new ContentValues();                          

Syndicate content