Tips and Traps¶
The Pythonic way of checking whether a collection (string, list, set, dict, etc.)
collis non-empty is to useif coll. However, do NOT useif arrto check whether a numpy array is non-empty or not. Instead, you shoule usearr.size >0to check whether a numpy array is non-empty or not.
Questions on SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
-
比如在 LEFT JOIN 中过滤条件写在 ON 和 WHERE 的区别。
-
Table-value function 和 scalar-valued function 的区别.
-
char、varchar、nvarchar之间的区别(包括 …
General Tips on SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Performance
-
Avoid implicit data convertion! This might cause full table scan which hurts performance badly. For more discussions, please refer to 一条垃圾SQL，把 64 核 CPU 快 …
Load Images into Pillow
VirtualBox API
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
https://www.virtualbox.org/sdkref/interface_i_mouse.html
Tools for Audio Analysis
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
pyAudioAnalysis
pyAudioAnalysis is a Python library covering a wide range of audio analysis tasks.