IT Blogs

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.

I have upgraded my Skype in android this week. I found there is a big improvement. The uer interface is much much nicer. Finally, it got a home screen, rather than a simple contact list style window. Moreover, now, I can send sms in there too! That is so great!

I wish to an android application. Although that is a small personal project, it still requires some server operations. Thus, I need to find a web host. I already have a web host in PHP. That is possible to write some php scripts for the communications with my android application. But Programming in PHP is not very fun. Then my next option is C#. I am a C# programmer for a few years. Writing some server logic in C# is a easy task for me. Moreover, C# is a good programming language. .Net Environment needs a lot of resource. I think that needs a VPS with 2GB of RAM to install .net and MS SQL server. That kind of VPS needs around $40 or more per month. Then Java seems to be my best option. a Glassfish and MySQL only needs 1GB RAM VPS. I can find some VPS with that kind of configurations under $30 per month. Java is a good programming language too. This option is the most feasible.