Thursday, March 26, 2015

Using SQLite Expert to develop and administer SQLite3 databases

SQLite is today's de facto database for mobile development, particularly as the local database used in Android and iOS apps. It is also widely used to handle data storage in embedded system.

In fact, SQLite is also a good choice for lightweight database to handle data storage and query for Windows / Linux / Mac applications. It is released in the public domain and free for use (compared with other non-free alternative such as MS Access database). It is serverless and doesn't need installation nor configuration of database system (compared with alternative such as MySQL, PostgreSQL, etc.)

Now come to the big question: how to create, develop and maintain the SQLite databases?

There are quite a number of tools available, some are free and some are non-free. I have chosen SQLite Expert for use in Windows development environment.

SQLite Expert comes in 2 editions: the free Personal Edition (free for both personal and commercial use), and the non-free Professional Edition with additional features. You can click here to find out the feature differences between the 2 SQLite Expert editions. The Personal Edition should be good enough for most SQLite application developers.

SQLite Expert is able to handle Unicode data, Views and Virtual Tables.

SQLite Expert has a nice and easy to use GUI. It even comes with Hex Editor (to edit fields with binary data) and Image Editor (to edit fields with image data).


It has a powerful visual editor for database table creation, restructuring and maintenance, which able to handle columns, indexes, foreign keys, triggers, unique and check constraints.


It also has a handy Data Definition Language (DDL) viewer to show the DDL of tables.


For the Professional Edition, you will also get a Visual SQL Query Builder, able to import and export data, Lua / Pascal scripting support, etc.

If you are in search for a good database tool for SQLite3, I strongly recommend this one to you.

Monday, March 9, 2015

Opened a CIMB AirAsia Savers Account

I am switching over my traditional CIMB savings account to a new CIMB AirAsia Savers Account for better interest rate and additional benefits that come with this online savings account.

CIMB AirAsia Savers Account is an online savings account in partnership with AirAsia. It is paperless, and you won't get any passbook nor paper monthly statement. Transaction details and online statements are available in the CIMB Clicks website.

 So, what's the big deal about this CIMB AirAsia Savers Account?

  • It offers an interest rate from 0.15% up to 1.00%. No big deal as some other banks are giving higher rate than this, but this rate is also higher than the traditional CIMB savings account or CIMB basic savings account.
  • If you maintain an average monthly balance of above RM5,000, and there is no over-the-counter transaction in that month, you will get a monthly RM5 cash rebate. Consider you are keeping RM5,000 in the account, that will translate into 5/5000 x 12 = 1.2% additional interest rate.
  • If you maintain an average quarterly balance of above RM3,000, you will get automatic entries into a Quarterly Contest to win holiday packages, complimentary flights, E-Gift Vouchers and other prizes. Every average quarterly balance of RM3,000 entitles you to one automatic entry.
  • If you maintain an average quarterly balance of above RM1,500, you will earn 250 AirAsia BIG Points quarterly. In my experience, the AirAsia BIG Points are very difficult to collect through buying air tickets from AirAsia, this seems to be a faster way to collect more points easily.
  • If you maintain an average monthly balance of above RM3,000, you will get E-Gift Voucher on your birthday month.
  • You will have priority booking benefit to grab the best deals during AirAsia sales one day before the general public.
If you already have a CIMB savings or current account, and you already have access to CIMB Clicks online banking facility, you don't even need to visit to CIMB branch in order to open a new CIMB AirAsia Savers Account, as you can do it inside CIMB Clicks. That's how I did it, and my new CIMB AirAsia Savers Account was opened instantly after I clicked the Confirm button.

To open a new CIMB AirAsia Savers Account from CIMB Clicks, just drop down the Apply For menu and select Savings Account. Then, select "CIMB Bank AirAsia Savers Account" under Product Type.


To link your CIMB AirAsia Savers Account with your AirAsia BIG Shot ID, click here.


If you need to lookup your AirAsia BIG Shot ID number, you can click here.


Click here to get more detail about CIMB AirAsia Savers Account from CIMB website.

Friday, March 6, 2015

Boost WiFi coverage with TP-Link TL-WA860RE 300Mbps WiFi range extender with AC passthrough

My TP-Link TL-WDR3600 N600 wireless dual band gigabit router is located upstairs near the center of the house, and my HiMedia Q5II Android 3D smart TV + media player box is located downstairs.

There is no problem for the HiMedia Q5II box to connect wirelessly to the TP-Link wireless router, until one day, when I streamed a 1080P full HD movie stored in my Transcend StoreJet 25A3 USB 3.0 1TB external harddisk which connected to the TP-Link wireless router with USB cable, over the air through WiFi to my HiMedia Q5II box which connected to my TV with HDMI cable. The movie didn't play smoothly on the TV.

As a result, I decided to boost my home WiFi coverage with a TP-Link TL-WA860RE 300Mbps WiFi range extender. The price of this WiFi range extender is just slightly below RM100.


I place this TP-Link TL-WA860RE downstairs near the center of the house, so that it can connect wirelessly with the TL-WDR3600 upstairs, and act as WiFi repeater to boost up the WiFi signal downstairs.


Now my HiMedia Q5II TV box is able to play 1080P full HD movie streamed from my Transcend external harddisk without problem.

Beside able to act as WiFi repeater to expand the WiFi coverage and boost up the WiFi signal, this TP-Link TL-WA860RE has one 10/100Mbps Ethernet LAN Port at its bottom, enabling it to become a WiFi bridge to wiredly connect to its network client using a LAN cable.

It also comes with an AC power passthrough socket in front, so that the power socket it plugged into is not wasted, and can still connect to electrical device up to 13 Amperes.

This TP-Link TL-WA860RE WiFi range extender is able to connect with the WiFi AP/router in either Universal or WDS mode.

The Universal mode can work with almost any kind of WiFi AP/router running at 2.4GHz frequency range. However, it might not be compatible with certain applications running in the WiFi clients.

The WDS mode is compatible with same TP-Link brand of wireless AP/router that also support WDS. It does not work with WiFi AP/router that doesn't support WDS, and it might not work well with other brand of WiFi AP/router even WDS is supported. It will not have applications compatibility issue with the WiFi clients.

Theoretically, passing of network packets in the range extender is more efficient with the WDS mode.

In order to enable WDS mode of connection, wee need to enable WDS bridging in the host AP/router and inform it about the range extender's SSID, MAC address and encryption method.


You can access to the web-based admin page of the TP-Link TL-WA860RE WiFi range extender by pointing your web browser's URL to http://tplinkrepeater.net/ or http://192.168.0.254 .

You must also provide the SSID and MAC address of the host AP/router information to the range extender.



When the SSID of the range extender is set to be the same with the WiFi AP/router, your mobile devices will automatically switch over to the WiFi provider with the stronger signal at its location. However, you might face problem of the mobile device keeps on connecting and disconnecting, switching from one WiFi provider to another, at the area where their signal are about equal strength.

You can also set the SSID of the range extender to be different from the WiFi AP/router. This will give you easier control over your mobile device to manually decide which WiFi provider it should connect to. Your mobile device is still able to automatically switch over to SSID with stronger signal when its WiFi connection with current connected provider is too weak to maintain the link and transmit data.

The wireless security setting must pair with the same setting in the host AP/router.



The TP-Link TL-WA860RE WiFi range extender also has a WPS button to pair with the host WiFi AP/router easily. However, this will connect it to its upstream AP/router using the universal mode instead of WDS mode.

One drawback of using WiFi range extender is that, its wireless connection is designed to work in half-duplex mode. This mean it cannot "talk" with the host AP/router and the wireless client at the same time. To relay the data over the air, it first talk with the transmitting wireless device, and then talk with the target device to pass the data on. Therefore, although the TP-Link TL-WA860RE supports wireless throughput of up to 300Mbps, when working in wireless repeater mode, the bandwidth is shared between the data sending and target devices, so each of them will get a throughput of around 150Mbps only.

On the other hand, when the TL-WA860RE is working in wireless bridge mode whereby one of the device is connected wirelessly and another device is connected through LAN port, the device connected wirelessly will get the maximum throughput of 300Mbps, while the one connected with LAN cable will get a maximum throughput of 100Mbps. The effective maximum connection bandwidth will be limited to 100Mbps, which is the highest at its Ethernet LAN port.

Bear in mind that the actual connection speed depends on the lowest supported connection speed of the 2 connected devices. Over the air, the wireless connection speed is further reduced over distance, physical blockage and signal interference with other wireless devices (such as neighbours' WiFi, cordless phone, Bluetooth devices, etc.) around the area.

Hint: Click on the "Older Posts" link to continue reading, or click here for a listing of all my past 3 months articles.