Discover gists

Python is not a great programming language.

It's great for beginners. Then it turns into a mess.

Installing `pg` gem on macOS

If you're trying to install the postgresql gem pg and it is failing with the following error message:

Installing pg 1.2.3 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

    current directory: ~/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/gems/pg-1.2.3/ext
~/.rbenv/versions/3.0.0/bin/ruby -I ~/.rbenv/versions/3.0.0/lib/ruby/3.0.0 -r ./siteconf20210125-97201-pycpo.rb extconf.rb

├── bin
│   └── console
├── config
│   └── evil_martians_api.yml
├── lib
│   ├── evil_martians_api
│   │   ├── api
│   │   │   └── developers.rb
│ │ ├── client

Discord app protocol routes

Home:

/: discord://-/
friends: discord://-/channels/@me/
nitro: discord://-/store
shop: discord://-/shop
message requests: discord://-/message-requests
family centre: discord://-/family-center

OpenSSL 🔐

Install

Install the OpenSSL on Debian based systems

sudo apt-get install openssl

Make sure the domain you picked points at the IP of your Redash server.
Switch to the root user (sudo su).
Create a folder named nginx in /opt/redash.
Create in the nginx folder two additional folders: certs and certs-data.
Create the file /opt/redash/nginx/nginx.conf and place the following in it: (replace example.redashapp.com with your domain name)
```
upstream redash {
    server redash:5000;
}
```

VM-Series on Proxmox

Special thanks to Zach Forsyth

Order of operations

SSH into your Proxmox server

ssh root@pve1

	# === Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers) ===
	#
	# by Fotis Evangelou, developer of Engintron (engintron.com)
	#
	# ~ Updated December 2021 ~
	#
	#
	# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
	# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
	#