What I Touched This Week 2017-08-06

Programming

Source Directories Not Being Created In New Project – IDEs Support (IntelliJ Platform) | JetBrains
Check the option, otherwise the directories must be created manually before creating Java/Kotlin new files using context menu.
PostgreSQL’s Powerful New Join Type: LATERAL - Heap Blog
LATERAL scopes sub SELECT with columns in preceding FROM items. It is useful to query completed associative information in one SQL.
Auto raise Python Tkinter main window
Qt API设计原则 (译) | 酷壳 - CoolShell

apt-get install debian-keyring debian-archive-keyring
apt-get update

Update using columns in joined table:

UPDATE A
SET A.c1 = expresion
FROM B
WHERE A.c2 = B.c2;

UPDATE T1, T2,
[INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1
SET T1.C2 = T2.C2,
    T2.C3 = expr
WHERE condition