Francisco A. Lozano flozano

## migration.sql
CREATE TABLE public.vouchers (
		id serial PRIMARY KEY,
		name text NOT NULL
);

INSERT INTO vouchers
	(name)
VALUES
	('Sales'),
	('Purchase'),

## gist:87e68c048e4ed5d78b0c081b97eb1d1f
package main

import (
	"crypto/rand"
	"encoding/base64"
	"io"
	"log"
	"net/http"
	"time"

## housekeeping.sql
-- Simply set the offset to the amount of rows you want to keep. An index of (id, date desc) will make this fast.


delete from some_table st
using (
  select distinct
    x.id,
    x.date
  from some_table st1
  join lateral (

## create-relative-virtualenv
#!/bin/bash
me=$(basename $0)
set -e # exit on error

function print_help {
echo
echo $me - create a virtualenv with relative paths in a certain buildroot and fix the relative path to make it work after install
echo
echo OPTIONS
echo "	-h / --help"

## macOS keyboard layout for Linux
# permanent apple keyboard keyswap
echo "options hid_apple swap_opt_cmd=1" | sudo tee -a /etc/modprobe.d/hid_apple.conf
update-initramfs -u -k all

# Temporary & instant apple keyboard keyswap
echo '1' | sudo tee -a /sys/module/hid_apple/parameters/swap_opt_cmd

# Windows and Mac keyboards - GUI (Physical Alt is Ctrl, Physical Super is Alt, Physical Ctrl is Super)
setxkbmap -option;setxkbmap -option altwin:ctrl_alt_win

## scale-out-phoenix-with-websocket.md

      
              1 file
            
          
              5 forks
            
          
              0 comments
            
          
              21 stars
            
          
                Aetherus
                / scale-out-phoenix-with-websocket.md
            
            
              Last active
              February 23, 2024 14:31
            
              
                How to scale out a Phoenix application with websocket
              
          
    How to scale out a Phoenix application with websocket

Foreword

It's relatively easy to scale out stateless web applications. You often only need a reverse proxy. But for those stateful web applications, especially those applications that embeds websocket services in them, it's always a pain to distribute them in a cluster. The traditional way is introducing some external services like Redis to handle pubsub, however, in such way, you often need to change your code. Can Erlang/Elixir, the "concurrency oriented programming languages", best other languages in this use case? Has Phoenix framework already integrated the solution of horizontally scaling websocket? I'll do an experiment to prove (or disprove) that.
Resources


## how_to_reset_kafka_consumer_group_offset.md

      
              1 file
            
          
              86 forks
            
          
              31 comments
            
          
              314 stars
            
          
                marwei
                / how_to_reset_kafka_consumer_group_offset.md
            
            
              Created
              November 9, 2017 23:39
            
              
                How to Reset Kafka Consumer Group Offset
              
          
    Kafka 0.11.0.0 (Confluent 3.3.0) added support to manipulate offsets for a consumer group via cli kafka-consumer-groups command.

List the topics to which the group is subscribed

kafka-consumer-groups --bootstrap-server <kafkahost:port> --group <group_id> --describe
Note the values under "CURRENT-OFFSET" and "LOG-END-OFFSET". "CURRENT-OFFSET" is the offset where this consumer group is currently at in each of the partitions.

Reset the consumer offset for a topic (preview)


## mac-clear-icon-cache.sh
sudo rm -rfv /Library/Caches/com.apple.iconservices.store; sudo find /private/var/folders/ \( -name com.apple.dock.iconcache -or -name com.apple.iconservices \) -exec rm -rfv {} \; ; sleep 3;sudo touch /Applications/* ; killall Dock; killall Finder

## .gitconfig
# one or the other, NOT both

[url "https://github"]
  insteadOf = git://github

# or

[url "git@github.com:"]
  insteadOf = git://github

## certs.sh
#!/bin/sh

# certs.sh

# use this for Yocto/Edison:
LIB=lib
# use this for WRLinux/Gateway
# LIB=lib64
if [ -f /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts ]; then
  mv /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts \
	CREATE TABLE public.vouchers (
	id serial PRIMARY KEY,
	name text NOT NULL
	);

	INSERT INTO vouchers
	(name)
	VALUES
	('Sales'),
	('Purchase'),
	package main

	import (
	"crypto/rand"
	"encoding/base64"
	"io"
	"log"
	"net/http"
	"time"
	-- Simply set the offset to the amount of rows you want to keep. An index of (id, date desc) will make this fast.


	delete from some_table st
	using (
	select distinct
	x.id,
	x.date
	from some_table st1
	join lateral (
	#!/bin/bash
	me=$(basename $0)
	set -e # exit on error

	function print_help {
	echo
	echo $me - create a virtualenv with relative paths in a certain buildroot and fix the relative path to make it work after install
	echo
	echo OPTIONS
	echo " -h / --help"
	# permanent apple keyboard keyswap
	echo "options hid_apple swap_opt_cmd=1" \| sudo tee -a /etc/modprobe.d/hid_apple.conf
	update-initramfs -u -k all

	# Temporary & instant apple keyboard keyswap
	echo '1' \| sudo tee -a /sys/module/hid_apple/parameters/swap_opt_cmd

	# Windows and Mac keyboards - GUI (Physical Alt is Ctrl, Physical Super is Alt, Physical Ctrl is Super)
	setxkbmap -option;setxkbmap -option altwin:ctrl_alt_win
	# one or the other, NOT both

	[url "https://github"]
	insteadOf = git://github

	# or

	[url "git@github.com:"]
	insteadOf = git://github
	#!/bin/sh

	# certs.sh

	# use this for Yocto/Edison:
	LIB=lib
	# use this for WRLinux/Gateway
	# LIB=lib64
	if [ -f /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts ]; then
	mv /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts \