View simple_git_workflow.md

Master is the (preferably working) development branch in most git branching models. (GitHub Flow, GitLab Flow, etc.; not Git Flow.) If you want to stabilize for a release, create a release branch and only merge bug fixes from master to it. When a branch works in your local environment (e.g. VirtualBox), push it to the remote. Ideally, merge requests should get reviewed and the remote production branch should get tested and deployed after it passes.

View gotchas.sql
-- istest != 1 does not match null, so do this:
update payments set istest = 0 where istest is null
-- utf8 is not enough for emoji in MySQL; it uses "utf8mb4" for that. Fix your database:
-- https://stackoverflow.com/a/39465494/819417
SELECT concat('ALTER TABLE ', TABLE_NAME, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_db_name'
-- Then copy/paste all results and use a db tool or scripting language to run them one by one.
-- To fix future tables as you add them, run this as well:
View mojibake.py
#!/usr/local/bin/python3
# -*- encoding: utf8 -*-
# http://stackoverflow.com/a/39549102/819417
print ( "\nEmoji to mojibake (origin):")
for emojiChar in ['😊','😣','👽','😎']:
print(emojiChar, emojiChar.encode('utf8').decode('cp1252'))
print ( "\nmojibake to Emoji (repair):")
for mojibakeString in ['😊','😣','👽','😎','🙇']:
View Tech prefs.md

Imho, Npm > Brunch > Webpack > Gulp > Grunt, Stylus > Sass > Less, Pug (aka Jade) > HTML, and CoffeeScript > JavaScript.

UTF8mb4 > UTF8 because it supports more Emoji. Use Unicode collate for proper sorting. UTF8 is most efficient at storing Latin with a minority of foreign characters.

Geany is almost Notepad++ but its find and replace dialog is terrible. TextMate is better but doesn't prefill the search text with the selected text like Npp and Geany do. Atom is slower and worse at file searching, and Sublime Text is nagware.

Double Commander is almost like Total Commander. Use external diff tool "/Applications/p4merge.app/Contents/MacOS/p4merge" from Helix P4V package, or the built-in one that's ugly but fast and probably doesn't litter swp files.

A PC laptop/notebook with Linux and [Wine](https

View bookmarklets.js
// Vimeo too slow? Control video playback rate using these bookmarklets! Just set as URLs of bookmark bar items:
javascript:document.getElementsByTagName('video')[0].playbackRate *= 2
javascript:document.getElementsByTagName('video')[0].playbackRate /= 2
View display_tech_test.md
View video.md

Video transfer tech quality with individually screened fully-wired cables:

DisplayPort > HDMI > DVI > DE15 ("VGA", 31+ kHz Hsync RGBHV. 20 or 40 euro for 15 meter.) > SCART (15.625 kHz Hsync RGB | YPbPr | S-Video) > Component (YPbPr) > S-Video > Composite (CVBS) >

View gist:f8c69bb1b93691e34d0b60281cd340cb
#!/usr/bin/perl
use Mysql;
use strict;
use vars qw($school_name);
use vars qw($pass);
require "./cgi-lib.pl";
View dec2frac.py
# https://www.quora.com/How-do-you-determine-sum-limits_-n-1-infty-frac-n+1-4-n-by-hand/answer/Job-Bouwman
def dec2frac(f):
"From scratch, 7dec15. Handles negative input since 9apr17."
of = f
f = abs(f)
n = 1
d = 2
while 1:
diff = n/d - f
View Npp_F1_Python.md

In %appdata%\Notepad++\shortcuts.xml add this command:

<Command name="Get Python help" Ctrl="no" Alt="no" Shift="no" Key="112">https://www.google.nl/#q=python+$(CURRENT_WORD)</Command>

More polished options are PyScripter and PyCharm (keymap F1 to View menu's "Quick Documentation"), but QBasic (and QB64) also show examples and related functions:

QBasic keyword help screen