How MySQL Collation & Charset Settings Impact Performance
michael Worth to learn https://www.percona.com/blog/charset-and-collation-settings-impact-on-mysql-performance
changing field char set to store Emoji Character in MySQL
https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-mysql-database php $this->pdo = new PDO(“mysql:host=$ip;port=$port;dbname=$db;charset=utf8mb4”
Avoid single quote in MySQL fields
use ‘’’ instead of ” code:
ffmpeg cheat sheet
cheat sheet:
find replace update mysql table field
UPDATE db_name SET filename = REPLACE(filename, ’_JPG’, ’.JPG’) WHERE 1;
Manage Wi-Fi with Terminal commands on OS X
detailed tech: How to manage Wi-Fi with Terminal commands on OS X updated with new ln -s location for newer OS https://apple.stackexchange.com/questions/81221/how-do-i-get-wi-fi-info-from-within-terminal
ffmpeg best quality merge
youtube-dl -f ’bestvideo+bestaudio/bestvideo+bestaudio’ –merge-output-format mp4 “link to youtube video”
re-arrange array key order by another array
SOF https://stackoverflow.com/questions/348410/sort-an-array-by-keys-based-on-another-array
synology –restart nginx
sudo synoservicecfg –restart nginx
python serial
import serial import time, sys, math #s = serial.Serial(port=’COM6’, baudrate=9600) s = serial.Serial(port=’/dev/ttyACM1’, baudrate=9600) print s #s.write(’text’) c=2000 print c s.write("one") while c>0: res= s.read() if (c % 20 ==…