Ben Chuanlong Du's Blog

It is never too late to learn.

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 …

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 …

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