I started to look into using databases with Android for my first application and searching high and low over the internet, this is what I’ve compiled. One may ask where does the sqlite database of the emulator is being stored on the hard disk of your PC, well, the files ystem of the emulator does not map to a directory on your hard drive. It’s stored as an image.
Sqlite database on your Android emulator
1.Create it in onCreate() when your app first launched:
According to Using Databases | Android developer:
The recommended method to create a new SQLite database is to create a subclass of SQLiteOpenHelper and override the onCreate() method, in which you can execute a SQLite command to create tables in the database
There’s a sample coding on how to populate the DB programmatically here at the Data Storage| Android developer.
2. Create the sqlite database on your PC and adb push it to your emulator.
- Use the Android Debug Bridge (adb) pull/push to retrieve a copy of the database on your Android emulator, populate it and put it back on the emulator.
- Fire up your emulator.
- Open up your command shell (Start -> Run -> type in cmd):
Your database will be stored in data/data/<package name>/databases/<db name of your choice>
The full command as the screenshot above is:
adb pull data/data/com.chien.programmersquote/databases/quote local_database
‘quote’ is the DB that is stored on the emulator and obviously local_database is the DB file name I will be downloading my database to at C:\users\Sted\
After that you could manipulate the DB using one of the tools available freely, namely the firefox addon, Sqlite Database Browser, SqliteSpy.
In the emulator you can access these database files directly; when connecting to a real phone however you will need root access to access the database files directly.
3. Import/Export via DDMS from Eclips
Inside Eclipse while the emulator is running, you can see your file hierarchy by going to Window -> Show View -> Other.. -> Android -> File Explorer ( or just click on the DDMS icon)
It took me some time to figure out the there are 3 buttons here on the DDMS page that serves as adb pull, adb push and delete file. Navigate to your database at data/data/<package name>/databases/ and just click on the button to either download / upload / delete the database.
Hope it helps. Ways described above are just generally some ways to deal with populating the database on your emulator for testing purposes.
Readability
Readability is an awesome tool to convert ugly/messy/unreadable web pages to a comfortable and clean view for your reading pleasure.
It’s an addon/extension to Firefox, Safari and Chrome users and bookmarklet for IE.
For example, this java tutorial, cluttered with ads.
Clutter with ads
A simple click on the Readability button and TADAAA:
After Readability is turned on
You can also adjust the font size, width and color theme to your liking.
Readability's Settings
Give it a try, you will definitely like it.