Skip to content

Instantly share code, notes, and snippets.

View SxDx's full-sized avatar
🦖

René Koller SxDx

🦖
View GitHub Profile
@SxDx
SxDx / commands.sh
Last active September 28, 2022 10:28
Custom jira app
// macOS
nativefier https://canvadev.atlassian.net/jira/software/c/projects/RMV/boards/1175 --icon ~/Pictures/icons/jira.png --name "Jira" --single-instance --internal-urls ".*?(canvadev\.atlassian\.net|www.google.com\/a\/canva.com\/acs).*?" --inject ~/Documents/jira.css --title-bar-style="hiddenInset"
// Windows
nativefier https://canvadev.atlassian.net/jira/software/c/projects/RMV/boards/1175 --icon ~/Pictures/icons/jira.png --name "Jira" --single-instance --internal-urls ".*?(canvadev\.atlassian\.net|www.google.com\/a\/canva.com\/acs).*?" --inject ~/Documents/jira.css --platform="windows"
// Linux
nativefier https://canvadev.atlassian.net/jira/software/c/projects/RMV/boards/1175 --icon ~/Pictures/icons/jira.png --name "Jira" --single-instance --internal-urls ".*?(canvadev\.atlassian\.net|www.google.com\/a\/canva.com\/acs).*?" --inject ~/Documents/jira.css --platform="linux"
@SxDx
SxDx / pg_postgres
Created July 15, 2020 15:37
pg gem + Postgres.app
gem install pg -v '1.2.3' -- --with-pg-config=/Applications/Postgres.app/Contents/Versions/9.6/bin/pg_config
@SxDx
SxDx / youtube_partial_download
Last active July 15, 2020 10:19
Download a portion of a youtube video (first time param is start, second time param is duration)
ffmpeg $(youtube-dl -g '$YOUTUBE_URL' | sed "s/.*/-ss 00:10 -i &/") -t 01:00 -c copy out.mkv
@SxDx
SxDx / dev-user.sql
Created July 15, 2020 09:30
MongoDB Dev User Permissions
db.createUser(
{
user: 'mongo',
pwd: '$PASSWORD',
roles: [ { role: 'root', db: 'admin' } ]
}
);
@SxDx
SxDx / fix_sequences.sql
Last active January 13, 2020 08:00
Fix Sequences #postgres
SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'