Skip to content

Instantly share code, notes, and snippets.

View flipace's full-sized avatar
🙈
Peek-a-boo

Patrick Hübl-Neschkudla flipace

🙈
Peek-a-boo
  • ovos media gmbh
  • vienna
  • 13:23 (UTC +02:00)
View GitHub Profile
@flipace
flipace / checkremote.sh
Created November 25, 2019 09:11
Check all git remotes
#!/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;)
@flipace
flipace / mysql-cross-db-command.md
Last active February 27, 2019 15:36
MySQL Cross-Database Commands

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

@flipace
flipace / delete git tags
Created February 16, 2019 10:47
Delete lot's of git tags easily
git tag --list 'v*' | xargs -I % echo "git tag -d %; git push --delete origin %" | sh
@flipace
flipace / keybase.md
Created July 17, 2018 14:02
keybase.md

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:

@flipace
flipace / discrepancy-vscode-tsc.md
Created June 5, 2018 20:18
Typescript Issue Debugging
  1. Check version of tsc with tsc --version
  2. Check version of typescript used in VSCode (in the statusbar next to the "TypeScript" file mode)
  3. 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
  4. 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"
}
@flipace
flipace / gdpr-list.json
Last active June 23, 2023 11:48
List of URLs where you can request your data according to GDPR/DSGVO laws
[
{ "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": "dpo@scee.net" },
{ "name": "Humble Bundle", "email": "dpo@humblebundle.com" },
{ "name": "REWE Group AT", "email": "datenschutz@rewe-group.at" },
{ "name": "BILLA", "url": "https:
@flipace
flipace / Contract Killer 3.md
Created May 29, 2018 09:49 — forked from malarkey/Contract Killer 3.md
The latest version of my ‘killer contract’ for web designers and developers

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

@flipace
flipace / cloudSettings
Last active February 2, 2018 13:36
Visual Studio Code Settings Sync Gist
{"lastUpload":"2018-02-02T13:35:57.715Z","extensionVersion":"v2.8.7"}
@flipace
flipace / rememberMe.md
Created November 7, 2017 07:32
A list of repositories and tools i'd like to remember.
@flipace
flipace / rememberMe.md
Created November 7, 2017 07:32
A list of repositories and tools i'd like to remember.