Ben Chuanlong Du's Blog

It is never too late to learn.

Hands on Full-text Search in SQLite3

FTS5 (Full-text Search) in SQLite3

  1. If tokens in the search phrase are separated by either spaces or plus signs, then they are matched in order by tokens in the text. To match tokens orderless, you can separate tokens in the search phrase with the keyword AND.

Disable Jedi in IPython

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

In the meantime, looks like there is a way one can disable jedi in ipython with Completer.use_jedi: https://ipython.readthedocs.io/en/stable/config/options/terminal.html

Specifically you can …

Print Colored Text in Terminal

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://stackoverflow.com/questions/287871/how-to-print-colored-text-in-terminal-in-python

Tips on Xonsh

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://github.com/xonsh/xonsh/wiki/Cheatsheet

Tricks and Traps

  1. While $() in xonsh works similar to $() in (all variants of) shell, it cannot be used in the middle of argument of …