Thursday, January 10, 2019

Laragon the free WAMP platform better than XAMPP, WampServer, etc.

The Windows-Apache-MySQL-PHP or Windows-Apache-MariaDB-PHP (WAMP) is a web application server platform running on Microsoft Windows operating system, derived from the Linux-Apache-MySQL-PHP (LAMP) platform.

In most cases, the LAMP platform is used for production server of web applications, while the WAMP platform is used as local development environment for web application programmers who work on Windows computer. Even so, the WAMP platform can also be used for production server.

XAMPP and WampServer are among the most popular WAMP environment that is free for use. There are many more options available in the market, both free and commercial, including the younger Laragon.

For Apple Mac OS users, there is also a MAMP platform available in both free and commercial Pro option.

I found Laragon to be better than XAMPP and WampServer, because it is very easy to install, very straightforward to use, very flexible to turn features and plugins on/off, very easy to setup new project, and it comes with a unique auto virtual host feature to give each project a nice URL to access from web browser. More importantly, it is lightweight and usually consume less than 4MB RAM when running, the servers are fast to start and be in up-and-running state. Its PHP execution is also pretty fast compared with other WAMP platforms.


The list of services to be started by Laragon can be easily selected in the preference page. You can also modify the default running TCP port at ease.


Laragon WAMP comes pre-installed with Apache, MySQL, Nginx, PHP, Node.js, Redis, Memcached, yarn + ngrok, git, HeidiSQL, Notepad++, etc.


HeidiSQL Portable is its default database tool to access and administer the MySQL. The popular phpMyAdmin can also be automatically downloaded included with a simple mouse click.


Additional services such as MongoDB, PostgreSQL, Python, etc. can be easily installed and added with a single mouse click from the Tools > Quick Add menu.


PHP extensions can be easily switched on/off in the PHP > Extensions menu.


To start new project with popular content management system or PHP framework such as WordPress, Drupal, Laravel, Symfony, etc. is also a breeze. With a single mouse click in the Quick App menu, the framework will be automatically downloaded and installed by Laragon.


Even if you choose to start with blank project, an empty database schema is automatically created for you in MySQL.

Laragon supports multiple versions of Apache, MySQL and/or PHP, which you can select which version to run for your project. Editing their INI configuration file can also be easily done in Laragon.

You can click here to download and install Laragon into your Windows computer.

Tuesday, December 25, 2018

Auspicious dates for baby first haircut (Mundan) in 2019

In many culture, religion and/or tradition, the first haircut of a baby is considered an important milestone for his/her life. The day is known as Mundan, Chadakarana, Halaqah, Upsherin, etc.

Here is the list of auspicious dates for baby first haircut in year 2019, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Thursday, December 20, 2018

Auspicious dates for starting new job / post / assignment in 2019

For employees, especially those in leading/managing/directing position, here is a list of auspicious dates  in 2019 for starting new job/post/assignment, including joining new company or joining new team in existing company.

It can be applied to first day reporting to new company/department/office/position, or going for the post to lead/manage/direct a new business unit/team/project/programme. It can also be applied to assuming new job position after promotion/restructuring/relocation exercise. It is produced based on the Chinese almanac Tong Shu.


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Wednesday, December 19, 2018

Auspicious dates for opening business in 2019

Here is the list of auspicious dates for opening business in year 2019, which is produced based on the Chinese almanac Tong Shu.

It can be applied to new business opening, or reopening of business after a break/holiday. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates in 2019 for getting a baby / childbirth / Caesarian delivery

Here is the list of auspicious dates in 2019 (year of Boar) for getting a baby (求嗣), which is produced based on the Chinese almanac Tong Shu.

The dates have good element(s) to embro/faetus. Traditionally, the dates are referred for conception planning (making love and expecting a baby to the family). Nowadays, people also make reference to them for Caesarian delivery of new born. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for marriage proposal or engagement in 2019

Before becoming the life partner, marriage is proposed by lover and engagement is made.

Here is the list of auspicious dates for marriage proposal or engagement in year 2019 (year of Boar), which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)



Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.


Tuesday, December 18, 2018

Auspicious dates in 2019 for signing contract, register for marriage, etc.

Here is the list of auspicious dates in year 2019 for signing contract, signing offer letter, register for marriage, receiving religious baptism, and other similar agreement-related activities.

It is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)



Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for renovation in 2019

Here is the list of auspicious dates for home or office renovation in year 2019, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Monday, December 17, 2018

Auspicious dates for moving to new house / office in 2019

Here is the list of auspicious dates for moving to new house/office in year 2019, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for wedding / marriage in 2020

Many couples plan for their wedding more than 1 year ahead in order to have sufficient preparation time.

Here is the list of auspicious dates for wedding/marriage in year 2020 (year of Rat), which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

If you are looking for auspicious dates for wedding / marriage in 2019 (year of Boar), click here.

You might probably also be interested with the auspicious dates for the following occasions in year 2020:

Wednesday, November 28, 2018

Avantree SP850 multifunctional wireless speaker with FM radio

I have purchased an Avantree SP850 multifunctional wireless speaker with FM radio for my father to replace his CD player that is now faulty and possibly reached its end-of-life.


This Avantree SP850 has many overlapping function with the BC-01 multimedia bluetooth speaker that I purchased 2 years ago. It costs higher at the price of RM96, but its sound quality is comparatively better, with a removable (and therefore replaceable) Nokia BL-5C Li-ion battery, and much straightforward and easier to use.


Note that this Avantree SP850 does not have alarm clock function and also unable to display the time.

Its 3 main functions are:
  • Play music and audio in MP3, WMA or WAV format
  • FM radio
  • Act as handsfree to answer/reject/hang-up incoming calls when connected to mobile phone using Bluetooth
It can accept audio source from the following:
  • FM radio
  • Micro SD card
  • AUX 3.5mm audio cable
  • Bluetooth
and it can output audio to headphone or external speaker via 3.5mm audio cable plugged to its headphone socket.

Its operation is menu driven with its LCD screen display. You can navigate the directory structure of the Micro SD card to pick the music file to play.

It supports the following music playing repeat modes:
  • Repeat all
  • Repeat folder
  • Replace once
  • Random
It has a built-in equalizer which you can set for the following music modes:
  • Natural
  • Rock
  • Pop
  • Classic
  • Jazz
  • Soft
It has 10 numeric buttons on top, makes it very easy to select song and to tune the FM radio.

You can get the FM radio to perform auto-searching of available channels, or to manually input the channel frequency number by using the numeric buttons. The manually set channels will be automatically memorized. This Avantree SP850 is able to memorize quite a lot of FM radio channels.

Due to its easy of use, this Avantree SP850 is suitable for everybody use, including elderly people.

You can watch the video below to have better understanding about this Avantree SP850.



Tuesday, November 27, 2018

Releasing handphone storage space by cleaning up WhatsApp files

Have you wonder what have silently taken up your handphone / tablet storage space? I bet the top culprit will be messaging apps such as WhatsApp.

WhatsApp stores all your individual and group chatting history in your phone storage, including all the media files and documents which you've sent out and also you've received from others. Over time, it will consume up gigabits of your phone / tablet storage.

Within the WhatsApp application itself does not have any mechanism for you to clean up old files or large files in order to release your handphone storage space.

Anyhow, you can easily locate those files stored by WhatsApp in your phone by using a file manager app such as File Manager + and navigate to the /WhatsApp/Media folder in your phone storage. The files are all there! You can then manually backup and/or delete the files there.

In fact, you can also program an Automate script to perform some sort of automated WhatsApp files housekeeping to release your handphone storage periodically.

Another easier way is to make use of an Android app called Cleaner for WhatsApp by LookAndFeel Lab to do the housekeeping.

Note that there are multiple Android apps call themselves as Cleaner for WhatsApp in the Google Play Store, and I am referring to the one developed by LookAndFeel Lab with the app icon as below:


This Android app is like a specific version of file manager to release handphone storage space taken up by WhatsApp files.

It shows you the total WhatsApp files found and the total storage space taken.

According to the WhatsApp directory structure, Cleaner for WhatsApp is able to list down the number of files and storage space taken by file types:
  • Videos
  • Images
  • Documents
  • Databases
  • Voices
  • Audios
  • Gifs
  • Stickers
  • Profile Photos
  • WallPapers


By entering the folder, it can let you review those files that you sent to others, those that you received from others, and duplicated files.

With a single tap, you can select all the files within the category (received, sent or duplicated), or you can manually select the files one-by-one, for you to perform the delete action. The files can be sorted by size (either large size first or small size first) or date (either oldest first or newest first) to make it easy for batch selection for deletion.

The function that makes a real difference from ordinary file explorer is its auto-clean function, which you can select to periodically check for the WhatsApp file and clean them by date or by size. It provides option for you to select which types of files you want to auto-clean.

With Cleaner for WhatsApp, you are able to release quite a number of handphone storage space occupied by those WhatsApp files. I would suggest LookAndFeel Lab to also provide achieve function beside cleaning to make it even better.

Thursday, November 22, 2018

Using Travel Recommends WiFi Router to access Google, Whatsapp, Facebook, Instagram, Snapchat, Youtube, etc. in China

If you are travelling to China, you will expect your Internet access to Google services (including Gmail, Google Maps, Google Calendar, Google Drive, etc.), WhatsApp, Facebook, Instagram, Telegram, Twitter, Snapchat, Blogspots, Wordpress, YouTube, and thousands over websites and Internet services be blocked and rendered inaccessible by the Great Firewall of China (GFW).

One common way to gain access to those websites and Internet services in China is to subscribe to a dependable and reliable VPN service before you enter into China. There are VPN solutions in the form of computer software as well as mobile apps to tackle the GFW restrictions, but such solutions might be limited to single device usage, not a good idea if you carry several devices (laptop, tablet, smartphone, smart watch, etc.) with you, or if you are travelling with a small group of people (family, friends, colleagues, etc.) in which each of you has one or more devices that need to access to those websites and/or Internet services.

In such case, a portable WiFi router with built-in VPN specifically for use in China is a better solution. The WiFi router is even more important than a local SIM card or roaming service, because as long as you have full Internet access, you can make voice or video calls using WhatsApp, Telegram, WeChat, Line, and other messaging apps.

I have searched around the Internet and found several providers of portable WiFi router available in the market. Some don't specify whether their portable WiFi router has workable VPN function for use in China or not. Some received customers' review about having mobile signal coverage issue, VPN connectivity issue, battery drainage issue, etc.

I have chosen Travel Recommends portable WiFi router as most of its customer's reviews are positive. It might not be the cheapest one in the market, but I believe it is dependable and reliable to ensure my Internet connectivity in China. Its rental price for China of RM28 per day is quite reasonable too. In fact, I really had enjoyable experience with this Travel Recommends portable WiFi router while I was in China, and I am pleased to have made a right choice.

In order to successfully rent a Travel Recommends portable WiFi router, you need to make your reservation at their website at least several days before your departure date.

During reservation, you can choose to have the device courier to you (with additional charges), or to self pick-up at their service counter available at the arrival hall of KLIA, KLIA 2 or Penang Airport. Self pick-up is also available at specific location in Johor Bahru and Kota Kinabalu. For device returning after your travel, you can also choose to courier it back to the company, or to self drop-off at either one of the 5 service counters available.

The package comes with:

  • The portable WiFi router, sharable by up to 5 connected devices at the same time
  • A travel adapter for you to charge the portable WiFi router (which you can use it to supply power to your other devices too)
  • A USB charging cable
  • A pouch to store all the components nicely at one place
You can also opt to include a power bank in the package, with additional charge. If you carry your own power bank, then you won't be necessary to rent the power bank from Travel Recommends.

There is a RM200 deposit collected by Travel Recommends upon making online payment to confirm your rental unit. This deposit will be banked in to your bank account several days after you returned all the rented components to the company.


The portable WiFi router has built-in Li-ion battery, which can last for about 6-8 hours of continuous usage. Whenever you are indoor with available wall socket, just charge it up, and it should be able to last the whole day from morning until midnight without much problem.

For portable WiFi router to be used in China (with or without VPN), Hong Kong and Vietnam, there is a fair usage limit of 1 GB per day. Exceeding the limit will cause your Internet access to be very slow, although still can stay connected. The quota usage is shown in real time on its display for easy check up.

There is unlimited usage for portable WiFi router to be used in Japan, South Korea and Taiwan, whist for other countries such as Singapore, Europe, Australia, Canada, USA, Thailand, Indonesia, Cambodia, India and Macau, the daily fair usage limit is capped at 500 MB only.

Rental prices for different countries are not the same, and can be found at their website. On and off they will have promotional price for specific countries.

I think portable WiFi router is an important oversea travelling component for you to carry along while you are abroad, to stay connected to the Internet and remain contactable via messaging apps. This is particularly crucial for travelling in China, as you need a portable WiFi router with dependable and reliable built-in VPN to stay connected to your favourite Internet services.


Sunday, November 18, 2018

Configuring IPv6 settings in Asuswrt-Merlin for TM UniFi

All the IPv4 blocks have already fully allocated, and IPv4 should be exhausted any time from now. Although the Internet transition from IPv4 to IPv6 has been prolonged, it is advisable to make use of IPv6 now in parallel with IPv4.

In fact, many websites are found to be faster when accessed using IPv6.

Below are my settings on IPv6 for TM UniFi for your reference:

  • Connection type: Native
  • Interface: PPP
  • DHCP-PD: Enable
  • Release prefix on exit: Enable
  • Auto Configuration Setting: Stateless
  • Connect to DNS Server automatically: Disable (you can choose Enable to use the DNS servers of TM UniFi)
  • IPv6 DNS Server: you can choose to use any of the public DNS servers below:
    • Google: 2001:4860:4860::8888, 2001:4860:4860::8844
    • OpenDNS: 2620:0:ccc::2, 2620:0:ccd::2
    • CloudFlare: 2606:4700:4700:0:0:0:0:1111, 2606:4700:4700:0:0:0:0:1001
    • UncensoredDNS: 2001:67c:28a4::, 2a01:3a0:53:53::
  • Enable Router Advertisement: Enable
If your IPv6 is working, you will be able to see your LAN IPv6 Address, LAN Prefix Length and LAN IPv6 Prefix shown on the screen. More information can be found in the System Log > IPv6 screen.

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