@Ibendlin - Yes, SQLite on device is what I meant. Sorry about the confusion @Drezden - I somehow don't have that option to add images to MediaStore, keeping the file path in the SQLite database. I would like to still try retrieving those images stored in the database before deciding which way to really go. Anything you could tell me about doing that?
Thanks, AB On Aug 22, 5:45 pm, Drezden <[email protected]> wrote: > What you're looking for in SQLite is called a BLOB (Binary Large > Object) but this is usually NOT recommended, the better approach would > be to add the images to your MediaStore and then store the file path > in your SQLite database. Then you can retrieve the images as needed > from the resource path like this: > > BitmapFactory.Options options = new BitmapFactory.Options(); > options.inSampleSize = 2; > options.inTempStorage = new byte[16*1024]; > options.inJustDecodeBounds = false; > > Bitmap preview = > BitmapFactory.decodeStream(getContentResolver().openInputStream(imagePath), > null,options); > > Hope this helps. > > On Aug 22, 3:04 pm, Abhi <[email protected]> wrote: > > > > > > > > > Hi > > > I have a database of low res images that I am trying to use for one of > > my applications. What I would like to do is to retrieve the images one > > by one and display them in a slideshow. I was told that images are > > stored as byte arrays in sql database. I am new to sql and looking for > > some direction on how to do this, what query to put and how to extract > > the byte array from the database for further use. > > > Any help appreciated. > > > Thanks, > > AB -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
