Finally, I completed Android Notepad Tutorial. It helps me to understand SQLite database in android. Moreover, it shows how to do some advance UI, such as ListView. I recommended all Android Newbie need to read it!

I am design the architecture of my android app now. At this stage, I am considering the interface between my app and the server. I am thinking to use the XML SOAP protocol. This is because the XML is very heavy weighted. There are Extra text in xml , such as "". So, I choose to JSON. Because that used less text. Moreover, I think JSON is good to de-serialize in Java. But GlasshFish does not come with JSON webservice by default. I have to use some extra package. I need to learn in Java!

One of my blogs is upgraded to WordPress 3.2.1 during last week. That is very smooth. All I need is uploading the files to my home directory. Then Loading the homepage again, it will run the update script. That is so easy!

I found the interface got the big improvements. I love in this version, it has a top toolbar in the public frontend, after you logined. It got the shortcut to create a new post and display the number of comments are waiting for approval. That is so user-friendly!

I got an email from Microsoft about new SQL Server version ,"Denali" CTP3, is released. I read their documents it got more support features in cloud. Moreover, its express version is more focus on localDB. This sounds like a in-process DB. That is very similar with sqlite. I have a look on that to how much improvements they have.

Click here to download from Microsoft

Reference:
SQL Server Code Name "Denali" Cloud On Your Terms
SQL Express

I had built a new application using System.Data.Sqlite. When I run the application, I got an exception, System.BadImageFormatException.Well, I found I was using 64-bit version, because System.Data.Sqlite will call some unmanaged dlls. So, it still needs to be in 32-bit. After I changed to use 32-bit dll,then all goods. Or you can switch your build target to 64 bit and using 64 bit dlls.