Levi Gillette raven-rock

Key mappings

map J nextTab
map K previousTab

map z passNextKey " great for youtube, e.g., zf -> fullscreen

map <c-p> togglePinTab " How often do you really print webpages with c-p anyway?

Exporting your 2FA tokens from Authy to transfer them into another 2FA application

IMPORTANT - Update regarding deprecation of Authy desktop apps

Past August 2024, Authy stopped supported the desktop version of their apps:
See Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August for details.

And indeed, after a while, Authy changed something in their backend which now prevents the old desktop app from logging in. If you are already logged in, then you are in luck, and you can follow the instructions below to export your tokens.

If you are not logged in anymore, but can find a backup of the necessary files, then restore those files, and re-install Authy 2.2.3 following the instructions below, and it should work as expected.

Optimizing postgresql table for more than 100K inserts per second

Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:

	#!/bin/sh

	# menu (dmenu, rofi, fzf, etc.)
	menu_cmd='dmenu -i -p Bookmark'

	# browser
	browser_cmd='firefox --new-tab'

	# in case the automatic profile detection does not work properly,
	# replace <PROFILE> with your profile id (e.g. ik52yqxf.default-1574488801337) and uncomment

	#!/bin/bash

	# Recommended steps:
	#
	# bootstrap before entering chroot
	# copy this script into INSTALL_DIR
	# rootinit after entering chroot
	# x (if installing graphics)
	# pkgs
	# xpkgs (if installing graphics)

	# Define ULID_DECODE and ULID_ENCODE which convert a ulid string to a binary and vice versa.

	delimiter //
	DROP FUNCTION IF EXISTS ULID_DECODE//
	CREATE FUNCTION ULID_DECODE (s CHAR(26)) RETURNS BINARY(16) DETERMINISTIC
	BEGIN
	DECLARE s_base32 CHAR(26);
	SET s_base32 = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(UPPER(s), 'J', 'I'), 'K', 'J'), 'M', 'K'), 'N', 'L'), 'P', 'M'), 'Q', 'N'), 'R', 'O'), 'S', 'P'), 'T', 'Q'), 'V', 'R'), 'W', 'S'), 'X', 'T'), 'Y', 'U'), 'Z', 'V');
	RETURN UNHEX(CONCAT(LPAD(CONV(SUBSTRING(s_base32, 1, 2), 32, 16), 2, '0'), LPAD(CONV(SUBSTRING(s_base32, 3, 12), 32, 16), 15, '0'), LPAD(CONV(SUBSTRING(s_base32, 15, 12), 32, 16), 15, '0')));
	END//

	;; This is a macro, and must be in clojure. It's name and location is the same as
	;; the cljs file, except with a .clj extension.
	(ns cljs-made-easy.line-seq
	(:refer-clojure :exclude [with-open]))

	(defmacro with-open [bindings & body]
	(assert (= 2 (count bindings)) "Incorrect with-open bindings")
	`(let ~bindings
	(try
	(do ~@body)