I’ve seen a lot of impressive animated bar charts(i.e. Bar Chart Race) and was wondering how they were created. After extensive research, it turned out a lot of tools offer this feature, such as Tableau, Flourish(web-based), Canva.com; however all of
SQL left join ON clause/filter
I always considered myself SQL advanced however when I came to the following sql code, I couldn’t figure out the correct answer: The below table has 5 rows(from on the first sql ), what will be the result of the
Hummingbot – Liquidity Mining (Part 2)
What’s my latest position towards Hummingbot since my last post in November last year? During the past 3 months, my journey was testing out its inbuilt strategies, participated in Liquidity mining, participated in its sister project Dminer, wrote my own
Free VPN server setup
I recently posted on how to host WordPress for free using Oracle VM, this is a follow-up post to show how to run a VPN server on the same machine. The easiest is to follow Oracle’s official post “Launching Your
Free VPS for WordPress
I was a small blogger so never had the idea to move on to a “Pro” WordPress hosting plan; however I was constantly approached by my hosting provider saying “my site exceeds their resource limit”. I felt pushed that it
Hummingbot – Liquidity Mining
The first time I saw a miner offered by Hummingbot, I was so confused: was it just a tool like GPU mining in the old days? How does it relate to Hummingbot and why does Liquidity Mining keep popping up?
Hummingbot – trading strategies
Since last post, I’ve been using Humming bot for the past couple of weeks. I’ve setup a number of bots using different strategies: Fixed grid, pure market, arbitrage and cross exchange market making. Theoretically both arbitrage and cross exchange market
Open source tool for creating trading bots
If you’re in Crypto world, you probably heard “Trading bots” a lot. A lot of so called “DeFi” projects always brag themselves that they have “trading bots” making money; unfortunately most of them are just scams simply because “trading bots”
Google Cloud SQL(Postgresql) to enable private IP
Due to security requirement, most companies don’t allow Google Cloud SQL (Postgresql) to be accessible via public IP. This article shows how to configure private IP for the db so that a web service built on App engine can communicate
Installing two graphic cards on Ubuntu
easiest way to install two graphic cards on Ubuntu