Skip to content

Instantly share code, notes, and snippets.

@mathiasrw
mathiasrw / True Trello Printer
Last active February 27, 2024 21:21
Ever wanted to print your Trello board? Export as JSON and paste it into the code.
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>True Trello Printer</title>
<link href="http://netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet">
<style>
body{margin:15%;}
.panel-body{
@mathiasrw
mathiasrw / dabblet.css
Created July 11, 2014 14:28 — forked from secondfret/dabblet.css
Design Shack Pricing Table Example
/**
* Design Shack Pricing Table Example
*/
* {margin: 0; padding: 0;}
body {background: #ededed;}
#container {
width: 780px;
@mathiasrw
mathiasrw / dabblet.css
Created July 11, 2014 14:28
Design Shack Pricing Table Example
/**
* Design Shack Pricing Table Example
*/
* {margin: 0; padding: 0;}
body {background: #ededed;}
#container {
width: 780px;
@mathiasrw
mathiasrw / dabblet.css
Created July 11, 2014 14:29
Design Shack Pricing Table Example
/**
* Design Shack Pricing Table Example
*/
* {margin: 0; padding: 0;}
body {background: #ededed;}
#container {
width: 780px;
@mathiasrw
mathiasrw / usermacro.html
Last active September 21, 2015 20:02 — forked from gregmac/usermacro.html
Confluence UML Sequence Diagram user macro
## Macro title: UML Sequence Diagram
## Macro has a body: Y
## Body processing: Unrendered
##
## This macro allows use of js-sequence-diagrams from http://bramp.github.io/js-sequence-diagrams/
##
## Developed by: Greg MacLellan
## Date created: 2015-09-15
## 2015-09-21: Added suppor for displaying parse errors while rendering
## Installed by: Greg MacLellan
/* http://www.tug.dk/FontCatalogue/cabin/ */
@font-face {
font-family: 'cabinregular';
src: url(data:application/font-woff;charset=utf-8;base64,d09GRgABAAAAAG4IABMAAAAA5ogAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAABGRlRNAAABqAAAABwAAAAcaY3kKEdERUYAAAHEAAAAHgAAACABEgAER1BPUwAAAeQAABPWAABJznTHqw1HU1VCAAAVvAAAACAAAAAgbJF0j09TLzIAABXcAAAAWgAAAGB69SGiY21hcAAAFjgAAAF9AAAB0uOCyEpjdnQgAAAXuAAAAEoAAABKFRUOzmZwZ20AABgEAAABsQAAAmVTtC+nZ2FzcAAAGbgAAAAIAAAACAAAABBnbHlmAAAZwAAASpAAAIQ8hTGGgWhlYWQAAGRQAAAAMwAAADYObSYlaGhlYQAAZIQAAAAgAAAAJA+tBvtobXR4AABkpAAAAmkAAAOUi6dEz2xvY2EAAGcQAAABwgAAAczloQeubWF4cAAAaNQAAAAgAAAAIAICAXZuYW1lAABo9AAAAmYAAAgOxff1SHBvc3QAAGtcAAAB3gAAArptSzhacHJlcAAAbTwAAADDAAABQsTzbm13ZWJmAABuAAAAAAYAAAAGPJZXfgAAAAEAAAAAzD2izwAAAADJrFREAAAAANOj7RR42mNgZGBg4ANiCQYQYGJgBMInQMwC5jEAAA4WARcAAHja1Zx7bNRXdsePbR628dgJL4MhIQGSsAEKaRKMeay9iQPEJUs2yfJwEuqmaYRoswrNVklQ091tNnJRhFKKlLJRxCKWIuSCMQi51LKcWtRrWa5leV136oxcZ3Y6O5pqNBpZo1H+qLj93Pu787LH9tjYhM7Vb+b3uPfc73mfe2dsyRGRQnlQNkjOn/3Rj38k+TKHO6KU6Cc5f/onf67viXPFs1w+c6Ww5B3JKf6N6
/* denfri.dk css style forbedring */
@font-face {
font-family: 'cabinregular';
src: url(data:application/font-woff;charset=utf-8;base64,d09GRgABAAAAAG4IABMAAAAA5ogAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAABGRlRNAAABqAAAABwAAAAcaY3kKEdERUYAAAHEAAAAHgAAACABEgAER1BPUwAAAeQAABPWAABJznTHqw1HU1VCAAAVvAAAACAAAAAgbJF0j09TLzIAABXcAAAAWgAAAGB69SGiY21hcAAAFjgAAAF9AAAB0uOCyEpjdnQgAAAXuAAAAEoAAABKFRUOzmZwZ20AABgEAAABsQAAAmVTtC+nZ2FzcAAAGbgAAAAIAAAACAAAABBnbHlmAAAZwAAASpAAAIQ8hTGGgWhlYWQAAGRQAAAAMwAAADYObSYlaGhlYQAAZIQAAAAgAAAAJA+tBvtobXR4AABkpAAAAmkAAAOUi6dEz2xvY2EAAGcQAAABwgAAAczloQeubWF4cAAAaNQAAAAgAAAAIAICAXZuYW1lAABo9AAAAmYAAAgOxff1SHBvc3QAAGtcAAAB3gAAArptSzhacHJlcAAAbTwAAADDAAABQsTzbm13ZWJmAABuAAAAAAYAAAAGPJZXfgAAAAEAAAAAzD2izwAAAADJrFREAAAAANOj7RR42mNgZGBg4ANiCQYQYGJgBMInQMwC5jEAAA4WARcAAHja1Zx7bNRXdsePbR628dgJL4MhIQGSsAEKaRKMeay9iQPEJUs2yfJwEuqmaYRoswrNVklQ091tNnJRhFKKlLJRxCKWIuSCMQi51LKcWtRrWa5leV136oxcZ3Y6O5pqNBpZo1H+qLj93Pu787LH9tjYhM7Vb+b3uPfc73mfe2dsyRGRQnlQNkjOn/3Rj38k+TKHO6KU6Cc5f/onf67viXPFs1w+c6Ww5B3JKf6N6fuyNE
SELECT
REGEXP_EXTRACT((REGEXP_EXTRACT(stories.url,'http://([^/]+)/')),'([^\\.]+\\.[^\\.]+(?:\\.[a-zA-Z].)?)$') AS stories_url_domain,
COUNT(stories.id) AS stories_count,
COUNT(CASE WHEN stories.score <= 3 THEN 1 ELSE NULL END) AS storiescountscore_3_minus,
COUNT(CASE WHEN stories.score <= 3 THEN 1 ELSE NULL END) / COUNT(stories.id) *100 AS stories_percent_3_minus,
FROM [fh-bigquery:hackernews.stories]
AS stories
WHERE
REGEXP_EXTRACT((REGEXP_EXTRACT(stories.url,'http://([^/]+)/')),'([^\\.]+\\.[^\\.]+(?:\\.[a-zA-Z].)?)$') NOT IN ('')
# First thing when spinning up a newly installed debian
# bash <(curl -s https://URLURLURLURLRULRULRULURL)
echo set syntax=on >> .vimrc
echo set nowrap >> .vimrc
sudo apt-get update
sudo apt-get -y upgrade
require 'HighLine/import'
def ok(prompt = '[y/N]')
confirm = ask(prompt) { |yn| yn.limit = 1}
return true if confirm.downcase == 'y'
return false if confirm.downcase == 'n' || confirm.downcase == ''
return ok
end