stefanw

OpenRefine Reconciliation with FragDenStaat.de

Preparations

FragDenStaat.de uses letsencrypt for HTTPS certificates. Unfortunately, the standard Java installation doesn't recognize that authority and the reconciliation will be stuck in the "Working" screen. Here's how to fix this.

1. Download the cross-signed certificate: https://letsencrypt.org/certs/lets-encrypt-x3-cross-signed.pem.txt
2. Import the certificate into the keystore of OpenRefine

keytool -import -alias letsencrypt -keystore /Applications/OpenRefine.app/Contents/PlugIns/jdk1.8.0_60.jdk/Contents/Home/jre/lib/security/cacerts -file ~/Downloads/lets-encrypt-x3-cross-signed.pem.txt

konstin

WARNING  Invalid version strings in tags of Q850: ['mysql-3.23.22-beta', 'mysql-3.23.24-beta', 'mysql-3.23.27-beta', 'mysql-3.23.28-gamma', 'mysql-3.23.29a-gamma', 'mysql-3.23.30-gamma', 'mysql-3.23.31', 'mysql-3.23.32', 'mysql-3.23.33', 'mysql-3.23.34', 'mysql-3.23.35', 'mysql-3.23.36', 'mysql-3.23.37', 'mysql-3.23.38', 'mysql-3.23.39', 'mysql-3.23.41', 'mysql-3.23.42', 'mysql-3.23.44', 'mysql-3.23.45', 'mysql-3.23.46', 'mysql-3.23.47', 'mysql-3.23.48', 'mysql-3.23.50', 'mysql-3.23.51', 'mysql-3.23.52', 'mysql-3.23.53', 'mysql-3.23.54', 'mysql-3.23.55', 'mysql-3.23.56', 'mysql-3.23.57', 'mysql-3.23.58', 'mysql-4.0.1', 'mysql-4.0.2', 'mysql-4.0.3', 'mysql-4.0.4', 'mysql-4.0.5', 'mysql-4.0.6', 'mysql-4.0.7', 'mysql-4.0.8', 'mysql-4.0.9', 'mysql-4.0.10', 'mysql-4.0.11', 'mysql-4.0.12', 'mysql-4.0.13', 'mysql-4.0.14', 'mysql-4.0.15', 'mysql-4.0.16', 'mysql-4.0.17', 'mysql-4.0.18', 'mysql-4.0.19', 'mysql-4.0.20', 'mysql-4.0.21', 'mysql-4.0.22', 'mysql-4.0.23', 'mysql-4.0.24', 'mysql-4.0.25', 'mysql-4.0.26', 'mysq

garybernhardt

This document has moved!

It's now here, in The Programmer's Compendium. The content is the same as before, but being part of the compendium means that it's actively maintained.

bearfrieze

Comprehensions in Python the Jedi way

by Bjørn Friese

Beautiful is better than ugly. Explicit is better than implicit.

-- The Zen of Python

I frequently deal with collections of things in the programs I write. Collections of droids, jedis, planets, lightsabers, starfighters, etc. When programming in Python, these collections of things are usually represented as lists, sets and dictionaries. Oftentimes, what I want to do with collections is to transform them in various ways. Comprehensions is a powerful syntax for doing just that. I use them extensively, and it's one of the things that keep me coming back to Python. Let me show you a few examples of the incredible usefulness of comprehensions.

lelandbatey

Description

This simple script will take a picture of a whiteboard and use parts of the ImageMagick library with sane defaults to clean it up tremendously.

The script is here:

#!/bin/bash
convert "$1" -morphology Convolve DoG:15,100,0 -negate -normalize -blur 0x1 -channel RBG -level 60%,91%,0.1 "$2"

Results

XVilka

THIS GIST WAS MOVED TO TERMSTANDARD/COLORS REPOSITORY.

PLEASE ASK YOUR QUESTIONS OR ADD ANY SUGGESTIONS AS A REPOSITORY ISSUES OR PULL REQUESTS INSTEAD!

henrik

tmux cheatsheet

As configured in my dotfiles.

start new:

tmux

start new with session name: