Blog#

June 8, 2020
in python, sqlalchemy
4 min read

Compiling SQLAlchemy query to nearly real raw sql query

May 5, 2020
in python
1 min read

Using Python Contextmanager To Create A Timer Decorator

April 13, 2020
in python
4 min read

Fixing an ipython Windows ConEmu only bug on 'MouseEventType.MOUSE_DOWN'

This post is for manually fixing an ipython Windows ConEmu only bug (from prompt_toolkit): Exception ''MouseEventType.MOUSE_DOWN'' is not a valid MouseEventType.

April 13, 2020
in python, linter, vscode
2 min read

Making isort compatible with black

March 9, 2020
in python
1 min read

Flattening nested dict in Python

Flattening a nested dict/json with list as some keys' value.

February 1, 2020
in linux
1 min read

Setting up WSL

Setting up WSL (Windows Subsystem for Linux)

December 29, 2019
in powershell
1 min read

Using Powershell To Retrieve Latest Package Url From Github Releases

Github can host package releases, I will show you how to use Powershell to retrieve the latest release download url.

December 29, 2019
in powershell
2 min read

Using Scoop On Windows

I've been using Scoop for setting up my personal and professional Windows development desktops since nearly 2 years.

December 21, 2019
in elastic
1 min read

Elastic Painless Scripted Field On Null/Missing Value

This post shows how to use elastic painless language in scripted field to work on documents' keys which might not exist in some documents.

October 27, 2019
in python, ubuntu
2 min read

Install Python3 on Ubuntu

A quick tutorial for installing Python from its official source on Ubuntu with sqlite3 support.