How To: Implement HTML5 Storage on a WebView with Android 2.0

So, after many days of using DDMS to poke around the Emulator subsystem I saw the way the new activity interacted with the data. I've took a TestCase code (which is like PhoneGap for Android, but stripped donw with only the WebView component), and hacked around with the old stickies example so that I can get it to work. So, here's the steps to do it:

Step 1: Create a WebView, similar to the one in the PhoneGap source.
Step 2. Get the webSettings, and set the Database Path. The path should be the path to your databases, which will be /path/path/your_package_name/.

appView.setWebChromeClient(new WebClient(this));
WebSettings settings = appView.getSettings();

Step 3: Create a WebChromeClient, and override the onExceededDatabaseQuota method. This is called when you first open the application because there's initially no database setup. This will allow you to set the quota in Java. Since this was test code, I just threw an arbitrary value in here.

final class WebClient extends WebChromeClient {
Context mCtx;
WebClient(Context ctx)
mCtx = ctx;
public void onExceededDatabaseQuota(String url, String databaseIdentifier, long currentQuota, long estimatedSize,
long totalUsedQuota, WebStorage.QuotaUpdater quotaUpdater)
Log.d(LOG_TAG, "We exceeded the quota");

OK, we now have a database that we can store things in. When dealing with Android Databases, remember to do all your database debugging on the device or a rooted phone, since you can't get access to the SQLite Databases from adb with the standard firmware on consumer devices, and this includes the latest images for the Android ADP1 and the Google Ion phones. I've just gotten this to work now, and I haven't tested this method with the Geolocation Database, but I would assume that it would be similar, except that there would just be the Cached Location. What I found odd about this setup was the fact that I couldn't write the database directly to the emulated SD Card on the device, which would make sense. I'm definitely going to play with this more, and refine it so that it's less hacky and more polished. However, the stickies example works now, and we will try porting existing iPhone Applications that use this SQLite storage soon.