Patrick Hübl-Neschkudla flipace

Generate UNION ALL queries for e.g create view

SELECT CONCAT('SELECT `type` COLLATE utf8mb4_unicode_ci as type, "', schema_name, '" COLLATE utf8mb4_unicode_ci as tenant FROM `', 
    schema_name, '`.`micro_sessions` UNION ALL')
FROM information_schema.schemata
WHERE schema_name NOT IN ('information_schema','mysql','performance_schema');

Convert everything to different Charset + Collation

Keybase proof

I hereby claim:

I am flipace on github.
I am flipace (https://keybase.io/flipace) on keybase.
I have a public key ASAWzpWUBpQsE500qVOf0nxtg111lp7FY7r8qAHWRXZcVwo

To claim this, I am signing this object:

Check version of tsc with tsc --version
Check version of typescript used in VSCode (in the statusbar next to the "TypeScript" file mode)
If these two versions don't match (or if they match, but you're using the integrated VSCode version in VSCode) find the path to typescripts lib folder which tsc and the find the lib folder which contains tsserver.js and tsc.js
Add the correct sdk path to your VS Code configuration:

{
  "typescript.tsdk": "/Users/$(whoami)/.nvm/versions/node/v8.9.1/lib/node_modules/typescript/lib"
}

Contract Killer

The popular open-source contract for web professionals by Stuff & Nonsense

Originally published: 23rd December 2008
Revised date: March 15th 2016
Original post

Remember Me

A list of repositories and tools i'd like to remember.

Shell Utils

https://github.com/trishume/pro - Awesome command line git project manager

Remember Me

A list of repositories and tools i'd like to remember.

Shell Utils

https://github.com/trishume/pro - Awesome command line git project manager

	#!/bin/bash

	checkremote() {
	dir=$(pwd)

	echo "Looking for git folders in ${dir} and below. Ignoring node_modules."

	results=$(find $dir -not -path "node_modules" -not -path ".git/*" -name .git -type d);
	for f in $results; do
	(cd $f/..; echo ""; echo "$f:"; git remote -v;)

	[
	{ "name": "Amazon", "url": "https://www.amazon.de/gp/help/customer/contact-us?", "note": "Select, in this order: 'Digitale Dienste' -> 'Datenauskunft beantragen' -> 'Datenauskunft für eine spätere Zusendung beantragen' -> 'Daten aus allen Kategorien anfordern' -> Namen eingeben und Nachricht vervollständigen. -- Amazon Support Staff will review your request and send you an email, asking about a postal address. If you don't answer to their mail, your request won't be fulfilled." },
	{ "name": "McDonalds", "url": "https://corporate.mcdonalds.com/corpmcd/gdpr-rights-center.html" },
	{ "name": "willhaben.at", "url": "https://datenschutz.willhaben.at/" },
	{ "name": "Spotify", "url": "https://www.spotify.com/account/privacy/" },
	{ "name": "Google", "url": "https://takeout.google.com" },
	{ "name": "PlayStation", "email": "[email protected]" },
	{ "name": "Humble Bundle", "email": "[email protected]" },
	{ "name": "REWE Group AT", "email": "[email protected]" },
	{ "name": "BILLA", "url": "https: