Ben Chuanlong Du's Blog

It is never too late to learn.

Tips on Oracle SQL

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

  1. Unlike Teradata SQL, a select statement in Oracle must have the from keyword. The dual table can be used if you do not really want to select from a table.

    select …

Snappy Apps

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

Available commands for snap:

abort Abort a pending change ack Adds an assertion to the system alias Enables the given aliases aliases Lists aliases in the system buy Buys a snap …

Visualization Using Plotly

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

https://plot.ly/python/offline/

  1. plotly works out-of-box in RStudio, however, not in rmakrdown. This is due to account setup issues. Use plotly in offline mode solves the problem.

Tips on VPN

** Things on this page arefragmentary and immature notes/thoughts of the author. It is not meant to readersbut rather for convenient reference of the author and future improvement. **

  1. You might have difficulties to visit some web pages when you are using VPN. This is probably because the location set by …

Tips on MySQL

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

sudo service mysql restart
mysqladmin -u root -p variables | grep port

mysqladmin --help list the locations of my.cnf.

mysqladmin --help

Python Packages

  1. peewee

  2. PyMySQL

  3. MySQLdb

References

Rising of the Julia Programming Language

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

Array with Customized Index

https://docs.julialang.org/en/latest/devdocs/offset-arrays/

https://medium.com/analytics-vidhya/0-based-indexing-a-julia-how-to-43578c780c37

https://www.reddit.com/r/Julia/comments/7btmwr/zero_based_indexing_examples/

References