Warning: This site is primarily for myself, I write down what I came across and how I solved it. Some of it might even interest you 😉

Programming

I’ll document some adventures encountered while programming.

Python

• Comparison of unicode strings doesn’t work

Computer

This is a section filled with system related topics (ex. list open files in cmd.exe, SSH port tunneling, etc.). I’ve divided it in several sections, as the list will grow.

Linux / Unix / macOS

• Set system time behind http proxy
• Create SSH port tunnel
• Debug Bash script
• Show connections and open sockets/ports
• Ubuntu: Apple Keyboard generates strange space character
• Use Linux behind a proxy
• Use mplayer in terminal
• Search in files
• Find empty directories
• Record traffic with tcpdump

MacOS

• Use CrossOver in a shell script
• Mac won’t go to sleep
• Parallels - prl_disp_service won’t start
• VMWare Fusion - Network not available
• Limit network bandwidth
• Disable .DS_Store file creation on network drives

Windows

• Delete undeletable files
• PowerShell: Change encoding
• PowerShell: Natural Scrolling
• Reset Permissions to default
• Delete files oder than X days
• Import Windows Events into MySQL

Software

• Backup & Imaging
• Sublime

Databases

There is no way around storing data. Databases are omnipresent and deserve a section.

PostgreSQL

• psql: A few useful commands
• Backup databases

MS SQL Server

• (De-)Prefix all tables
• Copy table (data)

MySQL

• Replace numeric autoincrement ID with another order