Ben Chuanlong Du's Blog

It is never too late to learn.

Use JupyterLab Notebooks in Pelican

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

https://github.com/getpelican/pelican-plugins/issues/866

https://github.com/getpelican/pelican-plugins/issues/651

Plugins

pelican-plugins

https://github.com/danielfrg/pelican-ipynb

https://github.com/peijunz/ipynb2pelican#installation-and-configuration

References

https://github.com …

Use Column Alias in SQL

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

  1. Logically any SELECT is processed in following order:

    1. from
    2. where
    3. group by
    4. having
    5. olap functions
    6. qualify
    7. select
    8. sample
    9. order by

    Besides the proprietary QUALIFY/SAMPLE every DBMS will do it exactly …

Distributed Programming in Python

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

https://github.com/rq/rq

https://python-rq.org/

Measure Python Code Coverage

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

Measure Python Code Coverage using coverage.py

pip3 install coverage

poetry run coverage run -m pytest

poetry run coverage report -m

poetry run coverage html

PyTest

$ pip install pytest-cov $ py.test …