Store images/files in database

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

SDK Version:

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:

//where we want to download it from
URL url = new URL(IMAGE_URL);  //http://example.com/image.jpg
//open the connection
URLConnection ucon = url.openConnection();
//buffer the download
InputStream is = ucon.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is,128);
ByteArrayBuffer baf = new ByteArrayBuffer(128);
//get the bytes one by one
int current = 0;
while ((current = bis.read()) != -1) {
        baf.append((byte) current);
}
 
//store the data as a ByteArray
//db is a SQLiteDatabase object
ContentValues dataToInsert = new ContentValues();                           
dataToInsert.put(TABLE_FIELD,baf.toByteArray());
db.insert(TABLE_NAME, null, dataToInsert);

And this is how you get the data back and convert it into a Bitmap:

//select the data
Cursor cursor = db.query(TABLE_STATIONLIST, new String[] {TABLE_FIELD},
                                                null, null, null, null, null);
//get it as a ByteArray
byte[] imageByteArray=cursor.getBlob(1);
//the cursor is not needed anymore
cursor.close();
 
//convert it back to an image
ByteArrayInputStream imageStream = new ByteArrayInputStream(mybyte);
Bitmap theImage = BitmapFactory.decodeStream(imageStream));

Storing a lot or big images in database is not recommended, but you can keep this solution in mind, there can be cases where this method can help you.

As the example shows in general it is possible to store anything in a database easily if you can convert it into a byte array.

If you're looking for the latest tips for your android phone, then check out the Dialaphone which always publishes the latest news from the mobile phone world. Click here for more information and to read their latest news, reviews and articles.

Tags:

Bookmark/Search this post with

Comments

دردشة سورية دردشة

ameer | Tue, 01/03/2012 - 11:00.

دردشة سورية
دردشة لبنانية
دردشة عراقية
شات سوري
شات لبناني
دردشة سوريا
دردشة لبنان
شات سوريا
شات لبنان
دردشة السويدي
منتديات السويدي
اغاني عراقية
صور فنانين
الرياضة العراقية
شعراء العراق
نغمات عراقية
اغاني عربية
اغاني كردية
دردشة عراقية
دردشة بنات العراق
دردشة صبايا بغداد
دردشة البصره
دردشة بغداد
دردشة بغدادية
دردشة صبايا بغداد
دردشة شباب العراق
دردشة بنات العراق
دردشة الكرادة
دردشة دمشق
دردشة بيروت
دردشة حلب
دردشة حلب
دردشة عراقية
دردشة العراق
شات عراقي
جات عراقي
دردشه عراقيه
دردشة صبايا لبنان
دردشة بنات لبنان

دردشة سورية دردشة

ameer | Tue, 01/03/2012 - 10:52.

دردشة سورية دردشة

ameer | Tue, 01/03/2012 - 07:48.

شات صوتي | دردشة صوتية | كلام

nn7575 | Mon, 12/12/2011 - 16:09.

شات صوتي

Very useful infor, can you

flower5 | Mon, 10/10/2011 - 13:16.

Very useful infor, can you let me know whether its possible to store very very big files like that too?

dekoracje domu wnętrz

Great information. I got

NigelG48 | Thu, 08/25/2011 - 12:08.

Great information. I got lucky and found your site from a random Google search. Fortunately for me this topic just happens to be something that I've been trying to find more info on for research purpose. Keep us the great and thanks a lot. David Carraway // gratis webkatalog mit pagerank

Peltikatto hmmm so i stumbled

ali.shass | Fri, 10/07/2011 - 06:45.

Peltikatto hmmm so i stumbled upon your subject from other site that discussed this. Anyway, i spent the time to study your subject but i am somewhat confused Both way, you're a first rate writer and i wished to take the effort to put in writing thank you! I've saved your website for future referral.

hey buddy,this is one of the

ali.shass | Wed, 09/14/2011 - 12:11.

hey buddy,this is one of the best posts that I’ve ever seen; you may include some more ideas in the same theme. I’m still waiting for some interesting thoughts from your side in your next post
makeup videos

Hey your collection is

ali.shass | Wed, 09/14/2011 - 12:10.

Hey your collection is outstanding,I never see such a type of collection before.Thanks for sharing it with us.keep it up
skin care reviews

happy to see your article, I

ali.shass | Wed, 09/14/2011 - 12:08.

happy to see your article, I very much to like and agree with your point of view. Thank you for sharing.Welcome to look at my website and blog articles.Hope we can become good friends, and exchange and to help each other! Thanks!!
natural skin care

Thanks. That’s great info for

NigelG48 | Thu, 08/25/2011 - 08:49.

Thanks. That’s great info for a newbie like me. I even like how you segmented your blog clearly… I’m still trying to get mine that focused. I guess it’s all a work in progress. Darren Carrington // AAAFx Forex Broker

An impressive share I just

NigelG48 | Wed, 08/24/2011 - 10:58.

An impressive share I just given this onto a colleague who was doing a little analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx... Dave Whiting // Eigene Model Homepage professionell

Good one

counselorx | Thu, 08/18/2011 - 05:22.

Thanks for this. Image files are pretty tricky to store in a database. I had some screenshots of how to buy and sell cars that I needed to store in a database and it took me about a couple weeks to figure out.

good article

Adam1234 | Thu, 08/11/2011 - 06:40.

airstream
I recently came across your blog and have been reading along.I thought I would leave my first comment.I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

There must have been some

GoberDongs | Thu, 08/11/2011 - 04:50.

There must have been some kind of unclear criterias when they want to decide who are going to received the award thoug. Because I have been seeing many old names in the industry are stilll there. We need some new faces. google page rank

The site is currently

DanarTero | Thu, 08/11/2011 - 04:13.

The site is currently undergoing more and more improvements in order to be able to cope with global requirements from their visitors. I think to have some commercial corner to sell/buy things could also something good in this tough. شات

Just want to say your article

ali.shass | Thu, 08/11/2011 - 04:49.

Just want to say your article is stunning. The lucidity in your post is simply striking and i can assume you are an expert on this subject. Well with your permission allow me to grab your rss feed to keep up to date with incoming post. Thanks a million and please keep up the delightful work.
waterproof decking

learning guitar online

jhonejhaone | Thu, 08/11/2011 - 03:18.

Storing a lot or big images in database is not recommended, but you can keep this solution in mind, there can be cases where this method can help you.
learning guitar online

I do not know what the

JamarPery | Thu, 08/11/2011 - 02:32.

I do not know what the consideration of those who entrust their personal data online. Although they offer the security of super-sophisticated, but still I have more confidence when put in the personal property database. Swimming Pool enclosures

Google has been well known

FredaMels | Wed, 08/10/2011 - 23:35.

Google has been well known for their good quality software. This Google doc is something that will signify their quality even more. I believe this is just another great good story of their achievement. ICTMarktplaats.nl

byte array

sveinn | Wed, 08/10/2011 - 18:28.

Great post! And it's also true that it is more possible to store anything in a database if it is converted into a byte array! italian lottery

ready looking forward to

sveinn | Wed, 08/10/2011 - 18:23.

ready looking forward to who will be nominated for the Award this year. Nothing better than recognize the achievements of individuals and organizations working for the promotion of intercultural dialogueThis years award theme "Dialogue For Citizenship And Freedom" is a great choice spanish lottery and el gordo

tatuaggi maori

jazzz12345 | Wed, 08/10/2011 - 13:14.

Storing a lot or big images in database is not recommended, but you can keep this solution in mind, there can be cases where this method can help you. tatuaggi maori

I want to see what people are

CarbosJake | Wed, 08/10/2011 - 06:42.

I want to see what people are thinking when it comes for them to be able to act regarding to what they believe in. I need to see whether or not this is something we can share the importance with them. the very best low carb diet and weight control information

VisitX

VisitX | Wed, 08/10/2011 - 03:04.

The best girls from around the world at your fingertips simply click and each of them can be yours. Each of them will do whatever you want to invite you from VisitX!

Many thanks for making the

passionlab | Wed, 08/10/2011 - 02:27.

Many thanks for making the sincere effort to explain this. I feel fairly strong about it and would like to read more. If it's OK, as you find out more in depth knowledge, would you mind writing more posts similar to this one with more information?
free sounds

Well, bad for you lol. I use

MatesAma | Wed, 08/10/2011 - 00:15.

Well, bad for you lol. I use it in my mobile phone as a tool if I need to edit or create xls file while traveling. It is quite useful. Bible Study Lessons

Living in the current society

WinarSae | Tue, 08/09/2011 - 22:48.

Living in the current society is hard, but we enjoy the ups too. So sometimes getting up with a headache must be understood, lol. No problem at all. no win no fee

acer aspire 5332

rock12 | Tue, 08/09/2011 - 07:14.

l will definitely bookmark this blog for future reference and further viewing. Thanks a bunch for sharing this with us! Mike Round //

acer aspire 5332

casse amplificate|casse attive

jhonejhaone | Tue, 08/09/2011 - 04:36.

Storing a lot or big images in database is not recommended, but you can keep this solution in mind, there can be cases where this method can help you.
casse amplificate|casse attive

It is very light, just like

JomlaCepy | Tue, 08/09/2011 - 04:18.

It is very light, just like it’s name, and also easy to use. That is main reason people love it. I think translator is just the same everywhere. Komodo Liveaboard

True. Once it is in your

VianaMolsa | Tue, 08/09/2011 - 02:38.

True. Once it is in your life, it will be hard to dismiss it. We can do literally a lot lot lot of things in the web. Unbelievable. It's like magic to the world. Elite Business Centers

I can just say good luck. It

MisaoCole | Mon, 08/08/2011 - 20:40.

I can just say good luck. It is unlikely to be in a more different case rather than what is anticipated. They should be able to handle it. Miami Tummy Tuck

It's valuable information and

jak2011 | Mon, 08/08/2011 - 15:08.

It's valuable information and helpful Thank you for this add-on
العاب سيارات

Benicassim

Venta de Muebles | Mon, 08/08/2011 - 13:55.

Issues are very interesting and very useful, thank you for the information provided. Benicassim

General Finances

jhonejhaone | Mon, 08/08/2011 - 05:10.

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

Hrmm that was weird my

passionlab | Sun, 08/07/2011 - 15:28.

Hrmm that was weird my comment got eaten. Anyway I wanted to say that it's nice to know that someone else also mentioned this as I had trouble finding the same info elsewhere. This was the first place that told me the answer.euro millions

Sign Companies

jhonejhaone | Sun, 08/07/2011 - 08:28.

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.
Sign Companies

Woah esta é apenas uma

Bruno49 | Sat, 08/06/2011 - 05:45.

Woah esta é apenas uma quantidade insana de informação deve idades tomadas para compilar assim muito obrigado por apenas compartilhar com todos nós. Se a sua vez em qualquer necessidade de informação relacionada com talvez um pouco de técnicas de sedução coaching ou apenas dicas gerais basta verificar o meu próprio site! Ali Kundra // air conditioning repair Canada

Yardy

white rock | Sat, 08/06/2011 - 05:04.

There are many people searching about that now they will find enough resources by your post. T5 Adapter

The article is written in a

eavedrop44 | Fri, 08/05/2011 - 23:18.

The article is written in a very good manner.It help me in my college project.Thanks for sharing it.
Boats for Sale

GOOD

wenger backpack | Fri, 08/05/2011 - 22:11.

Good post. Very impressive. Thanks for sharing.
wenger backpack

Good

wenger backpack | Fri, 08/05/2011 - 22:07.

Good post. Very impressive. Thanks for sharing. android tablet

This is the type of

shazmani | Fri, 08/05/2011 - 05:56.

This is the type of information that should be shared around the web.

hand tools

If possible, as you gain

ali.shass | Fri, 08/05/2011 - 03:19.

If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me. Lappatrici usate

Clever work and reporting!

ali.shass | Fri, 08/05/2011 - 03:25.

Clever work and reporting! Keep up the great works guys I've added you guys to my blogroll. This is a great article thanks for sharing this informative information.. I will visit your blog regularly for some latest post.thanks for sharing. kids clothing

Found your weblog by accident

ali.shass | Fri, 08/05/2011 - 03:31.

Found your weblog by accident for the second time these days so I considered I would have a nearer appear. I've just started producing my own blog site and modeling it right after what you have done. I hope mine is going to be as profitable as yours. a math

I recently came across your

passionlab | Thu, 08/04/2011 - 12:52.

I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading what you all have to say best underwater camera

I have to say this post was

Bruno49 | Thu, 08/04/2011 - 06:48.

I have to say this post was certainly informative and contains useful content for enthusiastic visitors. I will definitely bookmark this blog for future reference and further viewing. Thanks a bunch for sharing this with us! Mike Round // Free Online Games

Awesome

Amanda123 | Thu, 08/04/2011 - 04:15.

modalert
Thanks for taking this opportunity to discuss this, I feel fervently about this and I like learning about this subject.

Store images/files in database

Comments

Main menu

New tutorials from Helloandroid

Recent Apps

Android on Twitter

Poll

Useful resources

Android Development Projects