Ben Chuanlong Du's Blog

It is never too late to learn.

Application Tracking Using OpenCats

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

OpenCats looks like a great applicant tracking system!

http://www.opencats.org/

http://forums.opencats.org/

http://opencats-documentation.readthedocs.io/en/latest/

http://demo.opencats.org/index.php?m=companies

https …

Tips on Maven

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

The Central Repository

$HOME/.m2

maven: shade plugin, scala compile plugin, exclude manifest files, ...

import as maven project ...

find an updated version of scala archetype for maven

mvn package  
mvn clean …

Connect to MySQL Using PyMySQL

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

sudo pip3 install PyMySQL

Tricks

  1. Connection in PyMySQL is not autocommit by default. You must commit to save your changes.

    # suppose conn is the connection object
    conn.commit()
    
  2. parameterized sql: %s …

Connect to Databases Using pyodbc in Python

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

pyodbc only supports qmark

https://github.com/mkleehammer/pyodbc/wiki

Unicode Converter Buffer Overflow

This issues arises in Python3 but not Python2, so the simplest way is to use Python2 if …

The CentOS Linux Distribution

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

  1. The wheel group is the sudo group. So to grant a user the sudo previlege, just add it to the wheel group.
    gpasswd -a user_name wheel
    

EPEL

sudo yum -y install …

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 …