How to view the SQLite database on your Android Emulator

How to view the SQLite database on your Android Emulator

This tutorial will show you how to open a SQLite datbase from your Android emulator.

This requires Eclipse and the Android plugin. If you don't have them, follow this tutorial.

This also requires a SQLite viewer. I used SQLite Database Browser.

Step 1

  • With Eclipse open and your emulator running
  • select the DDMS perspective by clicking on the Window -> Open Perspective -> DDMS menu option.


Step 1


Step 2

  • Select the emulator you have currently have running. 
  • Click the File Explorer tab
  • Find the data folder.


Step 2

Step 3

  • Follow the filepath to the application you want /data/data/your.app.namespace/dbname.db
  • Click the Pull a file from the device button and save the database file on your computer.


Step 3

Step 4

  • Open the SQLite Database Viewer and click Open Database. 
  • Open the file and you can browse the data and view the schema!

Step 4

This can really help you debug some issues with your SQLite database!

Bu blogdaki popüler yayınlar

SDLC - Software Development Life Cycle

Resim
SDLC -  Software Development Life Cycle  is a process used by the software industry to design, develop and test high quality softwares. 1- Requirement Analysis 2- Defining Requirements To clearly define and document the product requirements SRS (Software Requirement Specification)   document which consists of all the product requirements to be designed and developed during the project life cycle. 3-   Designing the Product Architecture One design approach for the product architecture is proposed and documented in a DDS - Design Document Specification . DDS is reviewed by all the important stakeholders and based on various parameters as risk assessment, product robustness, design modularity, budget and time constraints, the best design approach is selected for the product. DDS defines all the architectural modules of the product along with its communication and data flow representation with the external and third party modules. 4- Developing the ...
Devamı

About Android padding, margin, width, height, wrap_content, match_parent, R Class

Padding and Margin padding  and  layout_margin  are two very similar attributes. Both determine the space around a View. The difference is that  padding  determines space within the boundaries of the view, and  layout_margin  determines the space outside the boundaries of the view. Width and Height Some of the most important properties are the width property and height property - those must be defined for every view. Remember that all views occupy a rectangular area on the screen - the width and height are the width and height of that area. You can define this in pixels, or better yet dp (stands for density-independent pixels): android:layout_width="200dp" android:layout_height="300dp" For the sake of having a layout be responsive and adjust to different devices, two common values are not numbers at all, but  wrap_content  and  match_parent  used as shown here: android:layout_width="wrap_content" android:layout_height="ma...
Devamı