Skip to content

Instantly share code, notes, and snippets.


Philipp Keller philippkeller

View GitHub Profile
View font_awesome_codpoints.dart
import 'package:flutter/material.dart';
import 'package:font_awesome_flutter/font_awesome_flutter.dart';
// to generate this, locate font_awesome_flutter.dart in console, and then:
// awk '
// /IconData/ && !skip { print }
// { skip = /Deprecated/ }
// ' font_awesome_flutter.dart | rg -o 'static const IconData ([^ ]+)' -r ' "$1": FontAwesomeIcons.$1,' | nocolor > /tmp/fa.txt
/// Icon data map for FontAwesome
View weather.dart
import 'package:http/http.dart' as http;
import 'dart:convert';
const apiKey = 'my-secret-api-key';
class Weather {
final int temp;
final int condition;
final String city;
philippkeller /
Created Apr 4, 2020
set up raspberry headless

Prepare SD Card

  • flash raspbian lite on micro sd card using etcher
  • setup wireless and ssh, desribed here

setup raspberry

  • passwd # set new password
  • set authorized keys
  • sudo raspi-config: set password, timezone, locale, enable spi
View output.txt
pi@raspberrypi:~/sonos-lcd $ pip3 install -U --force-reinstall pillow-simd
Looking in indexes:,
Collecting pillow-simd
Using cached
Building wheels for collected packages: pillow-simd
Running bdist_wheel for pillow-simd ... error
Complete output from command /usr/bin/python3 -u -c "import setuptools, tokenize;__file__='/tmp/pip-install-c7i2f9uv/pillow-simd/';f=getattr(tokenize, 'open', open)(__file__);'\r\
n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/pip-wheel-7fv32_j6 --python-tag cp37:
running bdist_wheel
running build
philippkeller /
Last active May 14, 2020
How to upload MS-Regionen of Switzerland to Metabase
philippkeller /
Created Oct 18, 2018
flatten json using flatten_json
#!/usr/bin/env python3
import flatten_json
import sys
import json
if __name__ == '__main__':
if len(sys.argv) < 3:
print(f'usage: {sys.argv[0]} in.csv out.csv')
f_out = open(sys.argv[2], 'w')

Getting Started With Superset: Airbnb’s data exploration platform

These instructions are for Amazon Linux Version 2

Update Python and PIP versions on EC2 (Amazon AMI)

sudo yum update -y
sudo yum install python3 -y
philippkeller / ami-mappings.yaml
Created Feb 16, 2018
Amazon Linux 64bit as of Feb 2018 (for acloudguru AWS cloudformation course)
View ami-mappings.yaml
"AMALINUX" : "ami-531a4c3c"
"AMALINUX" : "ami-8ee056f3"
"AMALINUX" : "ami-403e2524"
"AMALINUX" : "ami-d834aba1"
philippkeller / scanbd.conf
Created Jan 19, 2018
initial scanbd.conf
View scanbd.conf
* $Id: scanbd.conf 213 2015-10-05 06:52:50Z wimalopaan $
* scanbd - KMUX scanner button daemon
* Copyright (C) 2008 - 2015 Wilhelm Meier (
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
philippkeller / scanbd.conf
Last active Jan 19, 2018
sample scanbd.conf
View scanbd.conf
global {
# log to console. put to 'false' once you're done with testing
debug = true
# 1=error, 2=warn, 3=info, 4-7=debug
# 3 was sufficient for me (shows when script is triggered)
debug-level = 3
scriptdir = /etc/scanbd/scripts