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
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”
Tableau to show HTML data
I was working on Tableau to show some records that were extracted from a database, one of the columns is a HTML document, unfortunately Tableau cannot show HTML data properly. I did my research but found no solution, someone in
Bigquery parallel loading
There are many ways to load data into BQ but using Python gives us the most control. Below I’m going to demonstrate loading files into BQ in parallel. My test scenario is: 191 csv files, sizing from 10Mb – 1Gb
Running a Django application on IIS
Django is a popular Python web framework, below is how to use IIS(Internet Information Service) to host Django application on Windows. Install Python on Windows https://python.org Create a python virtual environment so your future development won’t rely on existing Python executables
Embed image in Email – Gmail
I’ve struggled for some time that embedded image(company logo) in my PHP generated emails didn’t show in Gmail. In some clients(e.g. Thunderbird), the logo showed without problem, however the same email didn’t display logo in Gmail Web, nor in Gmail App on
Use of Javascript on form submit
I have been struggling with the use of Javascript on my site for a number of days. All I wanted is simple – just a button within a <form> and once the button “Add” is clicked, a small Javascript is
ACL direct link failure
We use ACL directlink to dump SAP data on a regular basis. There was an annoying error that always happened: Time, SAP-REL 730,0,526 RFC-VER 3 1478436 MT-SL T:1356 Error in program ‘ACLWin’: ======> Start ‘sapgui’ failed. T:1356 Error in program
Remove application from Android watch
When my Android(HuaWei) watch paired with my phone(Nexus 6P), a number of applications were installed automatically on the watch. One of the applications is WeChat. I like WeChat on my phone but don’t need it on the watch. How do