Willie Möller W1M0R

🗺️ OSM - self host the entire planet 🌎 in ~30 minutes 🚀

TL;DR

mkdir osm
wget -O osm/planet.mbtiles https://hidrive.ionos.com/api/sharelink/download?id=SYEgScrRe
podman run -ti --rm -p 9000:9000 --name sms -v $(pwd)/osm/:/data/ registry.gitlab.com/markuman/sms:latest
firefox http://localhost:9000

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

Set up Keybase.io, GPG & Git to sign commits on Gitlab

This is a step-by-step guide on how to create a GPG key on keybase.io, adding it to a local GPG setup and use it with Git and Gitlab.

This guide is a fork of: https://github.com/pstadler/keybase-gpg-github

Requirements

Install Homebrew: https://brew.sh

How to seamlessly integrate Windows Subsystem for Linux (WSL) with Windows

Installation

Install an Ubuntu version from Microsoft Store.

Ubuntu - Ubuntu (latest)
Ubuntu 18.04 - Ubuntu 18.04
Ubuntu 16.04 - Ubuntu 16.04

Please check out the Windows 10 Installation Guide written by Microsoft itself.

Export your public key:

keybase pgp export > keybase-public.key

Export your private key:

keybase pgp export --secret &gt; keybase-private.key

Setting Up OpenCL for OpenCV on Android, the full story

The tutorial Use OpenCL in Android camera preview based CV application show us how we can use the Transparent API to dramatically increase the performance of some expensive operations.

The first step in order to be able to execute the tutorial example is to re-compile opencv with the correct flags:

# Export your NDK, it will be looked for OpenCV to compile your project. In my case
export ANDROID_NDK=~/graffter/libs/android-ndk-r10d/

# Download the necessary code

Multi user nix installation

Each section should be run as the user or as root, pay attention to which one!

Install nix single user

As $USER

curl https://nixos.org/nix/install | sh

	# https://twitter.com/brsn76945860/status/1171233054951501824
	pip install mmh3

	-----------------------------
	# python 2
	import mmh3
	import requests

	response = requests.get('https://cybersecurity.wtf/favicon.ico')
	favicon = response.content.encode('base64')

	#!/usr/bin/env bash
	# Convert your asciinema cast into a gif

	# https://github.com/asciinema/asciicast2gif#docker-image
	# https://brunswyck.blog/2017/05/17/record-your-bash-shell-and-upload-as-a-gif-file/

	# usage: in directory containing .cast file and this script: ./asciigifs <file name without .cast extension>

	command -v docker >/dev/null 2>&1 \|\| (echo "docker must be installed" && exit 1)

	{ pkgs ? import <nixpkgs> {} }:

	let

	# To use this shell.nix on NixOS your user needs to be configured as such:
	# users.extraUsers.adisbladis = {
	# subUidRanges = [{ startUid = 100000; count = 65536; }];
	# subGidRanges = [{ startGid = 100000; count = 65536; }];
	# };