Debugging database

Fri, 03/12/2010 - 02:25 | by gabor

SDK Version:

When I first tried to manage an sqlite database on an android device I was not sure about where I fail in it. Can I even insert the records into the database, or I fail only to read the data from it? So I started to search for possibilities to debug the database lifecycle.

The system stores databases in the /data/data/package_name/databases folder by default.

In a command line using the adb (Android Debug Bridge - found in the android sdk tools library) you can access the databases on a running emulator like below:

adb -s emulator-5554 shell
 
sqlite3 /data/data/package_name/databases/database_name

After this you can type normal SQL commands to test the content. For example:

SELECT * FROM table_name;

This will list the table content (in an ugly format), or say that it does not exists.

The sqlite3 command will not give an error if the database itself does not exists, it will be created. So you wont notice if the database creaton was unsuccessfull in yuor application, or you simply did a typo in the command.

It is also not too effective to test everything by having to write SQL statements, so lets see a moore user frendy way, using graphical tools, to look into the database.

We will use DDMS ( Dalvik Debug Monitor Server - from the android sdk too) through Eclipse and SQLite Database Browser.

First run yuor application on a virtual device, then open the DDMS perspectine in Eclipse. window/open perspective/other... Then select DDMS.

In the DDMS perspective the running emulator is showed, after selecting it you can list the file system of the virtual device.

Here simply select the database defaultly in /data/data/package_name/databases/ then press the button near the top right of the file explorer to "pull a file from the device". (If the application is still running an the emulator it probably prevents the pulling, beacause using the file, so leave the application it this problem occurs)

The last part is to open the pulled database file using the SQLite Database Browser, where you can easily check its structure and content on a graphical interface.

Tags:

Bookmark/Search this post with

Comments

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

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

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

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

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

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

nn7575 | Mon, 12/12/2011 - 17:10.

شات صوتي

شات السعودية شات سعودي شات

m7pq | Sun, 12/11/2011 - 19:21.

شات السعودية

شات سعودي

شات حلا
شات حلا السعودية
منتدى حلا السعودية
شاتات
صور في صور
توبيكات مسنجر
ازياء فساتين
بسطة بنات
مقاطع يوتيوب
بنات حواء
عالم الفن
اسرار فضائح
شات الحب

شات حلا

شات الحب

شات حلا السعودية

منتديات حلا السعودية

رابط حلا السعودية

These kind of posts are

sunitha | Tue, 08/09/2011 - 02:23.

These kind of posts are always inspiring and I prefer to read quality content so I am happy to find out many good point here in the post, writing is simply great, thank you for the post.

Hire Joomla Developers | Hire a Joomla Developer

yeah

aryhidayat | Sat, 08/06/2011 - 17:59.

Very interesting information
My blog l My product

Hudson Jeans

styla786 | Sat, 08/06/2011 - 05:08.

iPad Movies
macarons

Hudson Jeans
Skin Care Products

It is utterly right.

very nice post

behellepaspasang | Sat, 08/06/2011 - 02:11.

nice post! this is really useful!

behel lepas pasang

Good post. Very impressive.

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

Good post. Very impressive. Thanks for sharing. Nice work

android tablet

Android

Jessica Smith | Thu, 08/04/2011 - 21:01.

Great job for this articles. Very interesting topics.
batik art

nice post!

zukaholic | Sun, 07/31/2011 - 23:02.

very nice post! it's really informative,,

heavenrooms.com

I Like this topic.

siamgame | Sun, 07/31/2011 - 10:51.

Thank you for good android topic.
game

Adonai

manokwari | Sun, 07/31/2011 - 06:10.

nice article...
by
sarang semut

Nice article

asus123 | Sat, 07/30/2011 - 01:19.

Many thanks for this such a nice article

map of california

great

kolomayah | Sun, 07/24/2011 - 11:35.

This post gives the light in which we can observe the reality. this is very nice one and gives indepth information.
Baju Anak-Alat Kesehatan-Paket Aqiqah- Aqiqah- Harga Alat Bantu Dengar-Aqiqah-Alat Bantu Dengar- Aqiqah Murah-Percetakan Jakarta-Aqiqah-Kambing Aqiqah
Sari Kurma-Toko Online-Sari Kurma-Madu-asuransi kesehatan-alat gula darah-Alat Gula Darah

زفات

fahad999 | Sat, 07/23/2011 - 14:24.

thank you

زفات

fahad999 | Sat, 07/23/2011 - 14:27.

thanks for your article its really great and useful
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفات
زفه العروس
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات
موقع زفات

Nice article

short haircuts | Wed, 07/20/2011 - 11:10.

Hi,

I just want to put my links here.

short haircuts
Wedding hairstyles
Bridesmaid Hairstyles

ask

ipadrockz | Wed, 07/20/2011 - 03:12.

im not understand this

mx tube ipaf

great and useful

blogger81 | Tue, 07/19/2011 - 08:17.

thanks for your article its really great and useful
sportbike specifications SKEMA RANGKAIAN Electronic Circuit scolarship wireless car specifications gadget and computer car first look Motorcycle Modification sexi-stars. newlaptop circuits-audio electronic projects auto girl weapons system science kids gadget bikes walpaper mobil-wallpaper MODIFIKASI MOBIL plane-wallpaper celebsexypict artist-scandal sport-cars bikespict motor-modify sexi-model laptopharga gambar-artist fast-superbike autoshowmodel harga-kamera notebook-price diamonds-collections phones-gallery camera-prices home-pic audio-gallery autocarpict living-cares homes life-style

msflexgrid

wahedum | Tue, 07/19/2011 - 01:54.

In today's busy environment, many people live a frantic and hectic lifestyle, with no time for a balanced or healthy diet. Msflexgrid

I Need Money

i-needmoney | Mon, 07/18/2011 - 12:08.

i need money actual personal bank loan is actually considered, on large interest rates, about the ailment of which a minimum of one half your quantity is employed pertaining to particular requirements and also the relaxation can be applied for obtaining the automobile. Your mortgage is definitely collateralled through the financer who seem to takes some sort of charge with this service by using once a month instalments.

Blog Dofollow Indonesia

butet | Mon, 07/18/2011 - 09:17.

Good share here !! You need more quality backlink from dofollow blogs ? Please see full complete list Blog Dofollow Indonesia 2011 here.

Great things you have always

hushcat | Sat, 07/16/2011 - 03:59.

Great things you have always shared with us. Just keep writing this kind of posts.The time which was wasted in traveling for tuition now it can be used for studies.Thanks
Kingspan Insulation

wow thanks for the tutorial

punzer | Wed, 07/13/2011 - 10:26.

wow thanks for the tutorial free android download

Great! Thanks for

new_ariq343 | Tue, 07/12/2011 - 18:16.

Great! Thanks for sharing!
Visit my blog on Cara Membuat Forum di Blogger
Masariq Blog

Thanks..

top banget

butet | Mon, 07/11/2011 - 07:50.

androids memang top banget cara berkomentar di blog nofollow

Thank you - the site very

marya2011 | Sat, 07/02/2011 - 02:48.

Thank you - the site very very nice

المجتمع المصري هو مجتمع يحب الترفية حيث ان سكان مصر تصل الى تسعون مليون فرد ولذلك نحن نقدم خدمة دردشة مصرية لكل اهل مصر ام الدنيا , وتعتبر مصر متقدمة فى هذا العالم من حيث النمو فى مجالات التكنولوجيا و الكمبيوتر بنسبة كبيرة جدا لذلك نفضل دخول شات مصري اكبر تجمع بنات و شباب فى شات الحب و اجمل بنات فى دردشة دردشة الحب , اضافة الى ذلك حيث يوجد دردشة قوية تضم جميع محافظات مصر هي شات مصرية الكتابية نتمني لكم قضاء وقت ممكن فى شات الاصدقاء و احلي دردشة التعارف الذي يوجد به بنات رومانسية فى دردشة بنات مصر المصرية

شات الحب - دردشة مصرية - شات - شات مصري - شات حب - دردشة - دردشة كتابية - دردشة الحب - شات حبنا - شات حبي - شات مصرية - دردشة حب - شات بنات - دردشة مصر - دردشة بنات مصر - شات بنات مصر - شات صوتي - chat love - دردشة ياحبي - شات بنات لبنان - الحب - شات كتابي - منتدي ياحبي - شات مصر - دردشة حبنا - العاب تلبيس البنات - دردشة بنات - شات ياحبي - Chat - شات لبناني - شات كلامنجي - دردشة كلامنجي - شبكة - تصميم مواقع - تصميم - شات الاسكندرية - دردشة لبنانية - دردشة بنات لبنان - بنات لبنان - موقع شات - سعودي كول - شات سعودي كول - شات بنت مصر - شات سكس

You must have done good

lasoon4 | Sat, 07/02/2011 - 11:12.

You must have done good research for the work, i appreciate your efforts. Looking for more updates from your side buy a car warranty

توبيكات نونو توبيكات توبيكات

nono6com | Fri, 07/01/2011 - 03:41.

توبيكات نونو
توبيكات
توبيكات سعودي

شات صوتي
دردشة صوتية
شات كتابي

شات كتابي خليجي

شات عسل الصوتي

دردشة كتابية

chat
سعودي كول
سعودي كول 6666

دردشة صوتية سعوديه
دردشة صوتية سعودية

دردشة كتابية
دردشة كتابية خليجية
شات
دردشة
خاص للبنات

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

بنت كول
بنت كول الصوتي
شات بنت كول

دردشة بنت كول
شات بنت كول الصوتية

بنت كول الصوتيه
سعودي كول
صوتية سعودي كول
شات سعودي كول
دردشة سعودي كول
سعودي كول الصوتي
سعودي كول 6666
سعودي كول6666
سكر بنات
شات صوتي زين
شات صوتي ملوك
شات صوتي سعودي
شاتات صوتيه
مكتبة ماسنجر
شات صوتي حبي
شات صوتي كويت
YouTube - Broadcast Yourself.‏ , اليوتيوب نونو
صيف كام
شات صوتي كول
شات انحراف
وه بس
خريطة الموقع نونو
الرياض كول الصوتي
كامات 6666
شات المها
كامات6666
شات كامات 6666
كامات 666
كامات 66
سعودي انحراف
شاتكامات6666
سعودي احوه
شات سعودي احوه
سعودي احوه الصوتي
سعودي احوه كول
دردشة سعودي احوه
احوه سعودي
بنات احوه
دبي الصوتي
سعودي في اي بي الصوتي
شبكة الرياض الصوتي
روعة الليل
لايف كام
الخليج كام
شات كان زمان الصوتي
شات صوتي قصيمي
شات قلبي
ارجوان
شات صوتي قطري
بدور الخليج

منتديات روح
دردشة
شات سعودي
خليجي
شات صوتي
توبيك
موقع توبيكات
سعودي كول 6666
سعودي انحراف 2011

سعودي كول
سعودي انحراف

hohoho WTF amikom blogger

h3llkn1ght | Sun, 07/17/2011 - 08:43.

hohoho WTF

amikom blogger community goes to karimunjawa

In today's busy environment,

karen1leee | Fri, 07/08/2011 - 11:10.

In today's busy environment, many people live a frantic and hectic lifestyle, with no time for a balanced or healthy diet. Processed foods are the order of the day, and they often fail to give the appropriate ratio of vitamins required to remain healthy.

Natural vitamins supplements
and
Organic vitamins

Actually, in terms of whether

feilongfox | Wed, 06/29/2011 - 03:00.

Actually, in terms of whether this android requires debugging the database? Is not this kind of operating systems that do not use a database? pheromone cologne

Especially in terms of

feilongfox | Wed, 06/29/2011 - 02:58.

Especially in terms of ownership android is good if we try to learn the workings of the database. So if there is a slight problem we can know right away. pheromone cologne

Thanks looks easy enough

ken22 | Sat, 06/25/2011 - 15:02.

Nice work i like that you showed everyone how to do it step by step. Nice free stuff on the site. Like that you show how to use it on server or domain names. Would work great on t1 line or good dsl not on phone service. This should have some real time savings and give dividend stocks. I loans article to someone so they coul also try it.

good job

h3llkn1ght | Fri, 08/05/2011 - 15:47.

nice idea

good...

Car Wallpapers|Hyundai Elantra 2012|Nissan Navara 2011|Nissan Versa 2012|Audi Wallpaper|BMW Wallpaper|Hyundai Elantra 2012 Review|2012 Hyundai Elantra|Car Wallpapers|Mistubishi Lancer 2011 Wallpaper|volkswagen-amarok-pictures||2012-aston-martin-virage-volante-wallpaper-images|2012-aston-martin-vantage-gt3|mini-coupe-2012-pictures

thank you for information حجز

makkah | Sat, 06/25/2011 - 02:18.

thank you for information

حجز فنادق مكة
فنادق مكة

I have found so a lot of

wakthing | Fri, 06/24/2011 - 23:51.

I have found so a lot of interesting thing in your blog, ngaturaken pangapunten ingkang kathah sampun ngijinaken maos ten mriki ....
Dell M102Z laptop gaming, trendy, fitur melimpah ada di indokom.biz
Mercedes-Benz Mobil Mewah Terbaik Indonesia
Mercedes-Benz Mobil Mewah Terbaik Indonesia
Tablet Android Honeycomb Terbaik Murah
Meriahkan pesta ulang tahun bersama GarudaFood
Mari Berkomunitas Di Faceblog
Harga Jual Blackberry iPhone Laptop Murah
Video Music Mp3 Beauty and Health
SmadAV Antivirus 2011 SmadAV 2011 Acne treatment

thanks data base

fudesoni | Fri, 06/24/2011 - 03:22.

I need further guidance about the data base

animacion de fiestas

mago | Tue, 06/21/2011 - 06:34.

animacion de fiestas

hisa

kolomayah | Thu, 06/23/2011 - 12:15.

Paket Aqiqah -Aqiqah

fix database

butet | Mon, 06/20/2011 - 12:16.

Some file of my database is error. I need your advise. Optimasi SEO

Error on Debugging

wanitakerdil | Fri, 06/17/2011 - 02:36.

Hi admin, i have problem when i try to debugging my database. i don't know what can i do? can u give me solution?
Tablet Android Honeycomb Terbaik Murah

Thanks

cemal | Fri, 06/17/2011 - 01:29.

En güzel En Komik Oyunlar burada Komik Oyunlar - BenTen Oyunları - Zeka Oyunları - Oyunlar- Araba Yarışı Oyunları

SQLiteOpenHelper

polling | Thu, 06/16/2011 - 11:17.

It is also not too effective to test everything by having to write SQL statements, so lets see a moore user frendy way, using graphical tools, to look into the database.

We will use DDMS ( Dalvik Debug Monitor Server - from the android sdk too) through Eclipse and SQLite Database Browser.

First run yuor application on a virtual device, then open the DDMS perspectine in Eclipse. window/open perspective/other... Then select DDMS.

a visit b visit c visit d visit e visit f visit g visit h visit i visit j visit k visit l visit m visit n visit o visit p visit q visit r visit s visit t visit u visit v visit w visit x visit y visit z visit aa visit ab visit ac visit ad visit ae visit af visit ag visit ah visit ai visit aj visit ak visit al visit am visit an visit ao visit ap visit aq visit ar visit as visit at visit au visit av visit aw visit ax visit ay visit az visit ba visit bb visit bc visit bd visit be visit bf visit bg visit bh visit bi visit bk visit bl visit bm visit bn visit bo visit bp visit bq visit br visit bs visit bt visit bu visit bv visit bw visit bx visit by visit bz visit ca visit cb visit cc visit cd visit ce visit cf visit cg visit ch ci cj ck cl ccl cm cn co cp cq cr cs ct cu cv

I visited your blog for the first time and just been your fan. Thanks for Share With Irfan and so you can read my last post Mari Berkomunitas Di Faceblog on my blog.
Mari Berkomunitas Di Faceblog Mari Berkomunitas Di Faceblog Mari Berkomunitas Di Faceblog Mari Berkomunitas Di Faceblog Mari Berkomunitas Di Faceblog Mari Berkomunitas Di Faceblog

mediafire movies | mediafire

mihir23192 | Sun, 06/12/2011 - 02:28.

New tutorials from Helloandroid

More...

Recent Apps

More...

Android on Twitter

@aSioooooooooooo (오정수)
I have just discovered territory 1 in My Railway! You can get it for FREE on Android! http://t.co/BbC5qGPf #android #androidgames

9 hours 26 min ago
@NicoLu3 (Nico Lu)
I have just discovered territory 2 in My Railway! You can get it for FREE on Android! http://t.co/8nzoaH96 #android #androidgames

9 hours 26 min ago
@jcodyv (James Vanderlois)
I have just reached level 10 in My Railway! You can get it for FREE on Android! http://t.co/B34D0Anu #android #androidgames

9 hours 26 min ago
@NotSo1nt3restin (Eli Lucero)
RT @androidcentral: No, RIM's CEO didn't say BlackBerry apps are more profitable than Android or iOS http://t.co/7LcLEUxk #android

9 hours 26 min ago
@NicoLu3 (Nico Lu)
I have just reached level 12 in My Railway! You can get it for FREE on Android! http://t.co/8nzoaH96 #android #androidgames

9 hours 26 min ago

Debugging database

Comments

Main menu

New tutorials from Helloandroid

Recent Apps

Android on Twitter

Poll

Useful resources

Android Development Projects