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.
ModuleNotFoundError: No Module Named _Ctypes in Python 3.7
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Issue
The error message "Modulenotfounderror: No Module Named _Ctypes" is thrown when intalling packages in Python 3.7.
Cause
libffi-dev is needed to cleanly build Python 3.7.
Solution
- Remove Python …