I recently found a good open-source project that can help me digitize all my paper invoices/receipts/bank statements, by using its tags and OCR, saving and searching documents using my phone becomes a breeze. The application is paperless-ngx , which is
Time to change your WordPress hosting provider
I was using Hostiner for this WordPress site for the past two years and when it’s time to renew I noticed it became a lot more expensive: my previous 2-year plan cost me $71 however the renewal price for the
Which is the right exchange Crypto.com or Binance?
I started my Crypto journey recently and this is my own review of crypto exchanges. I’m in Australia so being able to deposit and withdraw in AUD is a must. I started with Crypto.com simply because they offer Visa pre-paid
Be aware of Rentalcars.com
I recently had to cancle a booking with rentalcars.com and found I’d be charged for “deposit” which is about 10% of the overall amount. I don’t see any logic why I could not get full refund as their website stated
Remote desktop to Ubuntu from Windows
I configured a new Ubuntu(20.04) desktop and wanted to be able to log into it remotely. Tried many times with xrdp but kept on getting “authentication is required to create a color profile“, “authentication is required to refresh the system
Postgresql upgrade from 11.x to 12.1
This is a new post based on my previous “Postgresql upgrade from 9.6 to 10.0“, with necessary updates and corrections. The latest Postgresql 12 (12.1) further improved performance on parallel queries, partitions, automatic (but overridable) inlining of common table expressions (CTEs) .
Domain and email hosting
I recently moved my email service to Zoho as the free email service offered by my hosting company (Inmotionhosting) had never been great: delays, failures of sending and sometimes even email loss. OK, it’s a free service so nothing to
Building a development box on Docker
This article is going to show steps and configurations on how to build a development box (PHP CodeIgniter + Apache + PostgreSQL) using Docker on Windows. Why Docker Comparing to VirtualBox, it’s a lot easier and probably faster Portable. Files
Upgrading PostgreSQL from 10.1 to 10.3
After upgrading PgAdmin4 V2 to V3, I start receiving this annoying message pg_restore: [archiver] unsupported version (1.13) in file header Therefore started the migration process, which is a lot easier than I thought 🙂 Below assumes you’re already on
Using Oracle SQL Developer Data Modeller (SDDM) for Postgresql
I have been searching for a good data modelling tool (ER modelling) for Postgresql – have tried a number of products but none of them are satisfactory except for SAP Powerdesigner which I really like. However it’s expensive and I don’t