CODEWITHSUNDEEP
androiddatabaseimagesqliteblob
TomKo1
TomKo1

Reputation: 224

storing reference to image on SD efficiently in DB

I'm pretty new to programming Android and I have a problem - I'm creating an app which stores "funny" images and enables user to view all of them, rate them (at least I want to make it so ;) ). I was trying to make a very simple database which stores images as BLOBs but someone on forum told me that this is a bad idea - so I decided to store images on SD like (this code is mainly from Stack although):

private void savePicToSD(){
     Toast.makeText(getActivity(),"Saving...",Toast.LENGTH_SHORT).show();
    //getting BitMap from ImageView
    Bitmap imageToSave=((BitmapDrawable)preview.getDrawable()).getBitmap();

    // getting env var representing path
    String root= Environment.getExternalStorageDirectory().toString();
    Toast.makeText(getActivity(),root,Toast.LENGTH_LONG).show();
    File dir=new File(root+DIR_NAME_);



     dir.mkdirs();

    String fileNam="Image-"+FILE_COUNTER_+".jpg";
    FILE_COUNTER_=FILE_COUNTER_.add(BigInteger.valueOf(1));
    File fileSav=new File(dir,fileNam);


    //I don't use try-with-resources because of API lvl
    FileOutputStream out=null;
    try{
        out=new FileOutputStream(fileSav);

        //saving compressed file ot the dir
        imageToSave.compress(Bitmap.CompressFormat.JPEG,90,out);
        out.flush();
        out.close();
    }catch(Exception ex) {
        ex.printStackTrace();
        Toast.makeText(getActivity(), "Error during saving.", Toast.LENGTH_SHORT).show();
    }

    Toast.makeText(getActivity(),"Image saved.",Toast.LENGTH_LONG).show();

}

after making it I now don't know how to store this "reference" and how to implement "fetching data from DB" - I was thinking about storing (with some sort of other data releated to specific photo) in DB string contatining path to the image and later while reading data from DB, read also the image - but how to do this efficiently? (I know that fetching data from DB has to be done as a Thread (AsyncTask ? ))?

Upvotes: 0

Views: 53

Answers (2)

Raúl Pérez López
Raúl Pérez López

Reputation: 538

I think the best you can do is storing the path of the image in BDD or a relative path and then access it

Upvotes: 1

Aj 27
Aj 27

Reputation: 2427

Store imagePath/fileName in your local database along with saving the image in the file system(SD card), and then when you want to get back that image just fetch that image from the file system by using imagePath/fileName stored in database.

I hope that you know how to create file and store in SD card.

Upvotes: 1

Related Questions