In response to this facebook post. I created a simple bus seat reservation user interface using VueJS. I started by preparing an SVG image of the bus seat and then render the SVG elements using Javascript (VueJS). You can use a raster image (sprite) for this but I prefer to use vector graphics (SVG) because […]
Perhaps you may need a ledger type query that can display a running total like the one on a bank statement. SELECT a.*, (@running_balance:[email protected]_balance+(a.credit-a.debit)) AS ‘balance’ FROM ledger a JOIN (SELECT @running_balance := 0) b WHERE a.id_user = ? AND a.account_type = ? AND a.year = ? […]
SELECT * FROM product t1 LEFT JOIN promo_product t2 ON t1.idProduct = t2.product_idProduct WHERE t2.idPromoProduct IS NULL […]
Do you ever wanted to have an HTML drop-down with default selected value (placeholder) that the user cannot re-select once they selected any valid value options? It can be done easily by adding selected and disabled attributes on the option element. Code Snippet <div class="row form-group"> <label class="col-12 pl-0">Status</label> <select class="form-control col-12"> <option value="" selected="selected" […]
You can easily create an Android Studio shortcut by creating an desktop entry using the following the steps below. In this guide, my Android Studio is installed in /opt/android-studio folder. Your folder location may differ. 1. Open terminal and type cd ~/.local/share/applications 2. Create a .desktop file using your favorite text editor nano android-studio.desktop 3. […]
I was building a multi-module project and I faced with this annoying problem with maven that keeps using old version of the maven project even though I uses mvn install -U. I usually delete my local .m2 repository folder but I found a much cleaner way to do it. mvn dependency:purge-local-repository […]
Did you enabled the full disk encryption (LUKS) on Ubuntu 18.04? I would like to share how you can change the LUKS password. LUKS stands for Linux Unified Key Setup developed in 2004 by Clemens Fruhwirth. Similarly, Apple’s macOS have FileVault and BitLocker for Microsoft Windows operating system. In the terminal you can check the […]
Revive your old laptop back in service using Lubuntu a light-weight version of Ubuntu. I bought this Lenovo IdeaPad S10-3 in 2012 when I was working in Muscat, Oman. This netbook has a blazing Intel Atom processor 1.66GHz, a 2GB DDR3 RAM, and 10″ LCD screen. I was initially thinking of giving it away because […]
You may want to completely erase the partition table of your USB flash drive including the boot record. In macOS you do easily do that using diskutil. During this COVID-19 lockdown in Malaysia, I wanted to use my weekend time in installing Linux on an old laptop. It turns out that old laptop only support […]
Overview I started my homelab journey in 2017 setting up small server to host my files and test my web applications. Today, I am giving my small network a bit of an upgrade by having a redundant Internet connection using a TP-Link ER6020. I appreciate that TP-Link made it affordable for us to buy business […]