Daniel Illi-Zuberbühler daniel-illi

I wrote this short tutorial because extending my internal storage using my new micro SD card on my Retroid Pocket 2+ failed all the time. Only setting it up as portable/external worked. However, this instructions should work in any Android 5.0+ device.

So, in case you have problems setting up your SD card on your Android device via graphical interface (setting up storage as extended internal memory or portable), and you get a corrupted SD card or any other error, follow these steps to fix it via adb shell:

Make sure you have adb access to your Android device: Settings > System > About, touch/click on Build number until Developer options are enabled:
Go to Settings > System > Developer options and enable USB debugging.
Assuming you have adb installed on your remote terminal run the following:

adb shell

Migrating a Rails project from MySQL to PostgreSQL

This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.

No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!

I chose [pgloader][1] because it's extremely fast. YMMV.

Replace mysql2 gem with pg in Gemfile.
Update config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.

	#!/bin/bash
	# copied from https://askubuntu.com/questions/892076/how-to-selectively-purge-old-kernels-all-at-once/892077#892077

	# NAME: rm-kernels-server
	# PATH: /usr/local/bin
	# DESC: Provide dialog checklist of kernels to remove
	# Non-GUI, text based interface for server distro's.

	# DATE: Mar 10, 2017. Modified Aug 5, 2017.

	# vim: syntax=ruby
	# Copyright (c) Conrad Irwin <conrad.irwin@gmail.com> -- MIT License
	# Source: https://github.com/ConradIrwin/pry-debundle
	#
	# To install and use this:
	#
	# 1. Recommended
	# Add 'pry' to your Gemfile (in the development group)
	# Add 'pry-debundle' to your Gemfile (in the development group)
	#

	class Object
	def ergo(&b)
	if block_given?
	b.arity == 1 ? yield(self) : instance_eval(&b)
	else
	self
	end
	end
	end

	CREATE OR REPLACE FUNCTION truncate_tables(username IN VARCHAR) RETURNS void AS $$
	DECLARE
	statements CURSOR FOR
	SELECT schemaname, tablename FROM pg_tables
	WHERE tableowner = username AND schemaname = 'public';
	BEGIN
	FOR stmt IN statements LOOP
	EXECUTE 'TRUNCATE TABLE ' \|\| quote_ident(stmt.schemaname) \|\| '.' \|\| quote_ident(stmt.tablename) \|\| ' CASCADE;';
	END LOOP;
	END;

 button {
   position: absolute;
   visibility: hidden;
 }
 button:before {
   content: "goodbye";
   visibility: visible;
 }

	# /etc/fail2ban/filter.d/traefik-auth.conf
	[Definition]
	failregex = ^<HOST> \- \S+ \[\] \"(GET\|POST\|HEAD) .+\" 401 .+$

	#!/bin/sh
	docker run --rm -u 1004:1004 -v "$PWD":/data vimagick/youtube-dl $@

	#!/bin/bash
	cat .gitignore \| sed 's/^/\.\//g;s/\(.\)\/\([0-9a-zA-Z\\?\.]*\)$/svn propedit svn:ignore "\2" \1 /mg' \| bash