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 …

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

• MySQL Cheat Sheet
• MySQL …

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

{"\(and": [{"tags": {"\)regex": "idea"}}, {"tags": {"$regex": "idea"}}]}

{"\(and": [{"tags": {"\)regex": "idea"}}, {"tags": {"$regex": "mob"}}]}

mongoimport -d notes -c note notes.json

mongodb: dbpath, centos: /data/db by default

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

https://www.elastic.co/guide/en/elasticsearch/reference/2.1/setup-service.html

SQL Support

1. Elasticsearch supports SQL syntax starting from version 6.3. There is also an unofficial SQL support of …