tdegrunt

Nerd Fonts for your IDE

https://www.nerdfonts.com/font-downloads

The following solution thanks to @hackerzgz & @snacky101 will install all nerd fonts;

brew tap homebrew/cask-fonts
brew search '/font-.*-nerd-font/' | awk '{ print $1 }' | xargs -I{} brew install --cask {} || true

tdegrunt

PostgreSQL is Enough

• Just Use Postgres for Everything
• Simplify: move code into database functions
• Hacker News discussion

Background and Cron Jobs

• https://github.com/citusdata/pg_cron
• https://github.com/cybertec-postgresql/pg_timetable

tdegrunt

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

tdegrunt

I'm using a computer (Minisforum HM90) which has a AMD/MediaTek RZ608 bluetooth/wifi chipset, wifi works, but bluetooth doesn't. Initially i got a vcp.c d-bus experimental not enabled error, but that was fixed by adding experimental to /etc/bluetooth/main.conf

After a long read and investigation I found an article mentioning that RZ608 may be buggy and restarting/cycling power and or completely removing the PC from power could resolve the issue. It did.

```
[gamer@chimeraos ~]$ rfkill list
0: hci0: Bluetooth
	Soft blocked: no
	Hard blocked: no
1: phy0: Wireless LAN

tdegrunt

Booting the Steam Deck recovery image

https://help.steampowered.com/en/faqs/view/1B71-EDF2-EB6D-2BB3

SteamOS runs a custom grub to cater it's needs for it's A/B partition design. So far the said custom grub does not boot for me on ovmf/intel uefi (maybe it boots on amd? some said they managed to just rufus the image and boot it)

skip to https://gist.github.com/Kethen/698cfa8cf387e131ebd36fbfbfe9272e#gamescope-and-non-amd-gpu if it just boots for you

Upon closer inspection the official bootloader does load some kind of amd firmware before booting the kernel

tdegrunt

---
include:
  - ".solargraph_definitions.rb"
  - "app/**/*.rb"
  - "config/**/*.rb"
  - "lib/**/*.rb"
exclude:
  - test/**/*
  - vendor/**/*
  - ".bundle/**/*"

tdegrunt

使用方法

• 以下のようにしてスクリプトを取得する。もしくは、downloadして解凍。

 $ git clone git://gist.github.com/3973319.git

• 実行
• 自マシンでのIPアドレスを取得してRoute53にhoge.example.com.のAレコードを設定する

tdegrunt

sudo apt-get install autoconf bison build-essential libssl-dev libyaml-dev libreadline6-dev zlib1g-dev libncurses5-dev libffi-dev libgdbm6 libgdbm-dev libdb-dev

sudo apt-get update

sudo apt-get -y install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev software-properties-common libffi-dev postgresql-13 postgresql-13-postgis-3 libpq-dev libtool-bin cmake pkg-config

curl -fsSL https://github.com/rbenv/rbenv-installer/raw/HEAD/bin/rbenv-installer | bash
sh -c 'echo "export PATH=~/.rbenv/bin:\$PATH" >> ~/.bash_profile'
sh -c 'echo "eval \"\$(rbenv init - bash)\"" >> ~/.bash_profile'

tdegrunt

OpenSSL Playground

Certificates

Print Certificate ( crt file )

openssl x509 -in stackexchangecom.crt -text -noout

Print Certificate ( pem file )

openssl x509 -in cert.pem -text -noout

Print Certificate ( cer file )

openssl x509 -inform der -in foobar.cer -noout -text

Read part of Certificate

tdegrunt

require 'mail'
require 'securerandom'

size_distribution = {
  10 => (0..19),
  80 => (20..39),
  150 => (40..59),
  250 => (60..79),
  15_000 => (80..100)
}