Andrew Z andrey-zh

Raspberry Pi, Static HTTPS site with Docker and Nginx

This tutorial is dated Oct 2021, if it's much further on than that this information might be out of date.

This is a guide on setting up a static HTTPS website on your raspberry pi using docker and nginx. The aim is to have this running on the raspberry pi and to be able to access it from a host computer on the same local network. You should already be able to ssh into your pi from your host computer and have raspberry pi OS set up.

Find your raspberry pi

Here is the best setup (I think so :D) for K-series Keychron keyboards on Linux.

Note: many newer Keychron keyboards use QMK as firmware and most tips here do not apply to them. Maybe the ones related to Bluetooth can be useful, but everything related to Apple's keyboard module (hid_apple) on Linux, won't work. As far as I know, all QMK-based boards use the hid_generic module instead. Examples of QMK-based boards are: Q, Q-Pro, V, K-Pro, etc.

Most of these commands have been tested on Ubuntu 20.04 and should also work on most Debian-based distributions. If a command happens not to work for you, take a look in the comment section.

Make Fn + F-keys work (NOT FOR QMK-BASED BOARDS)

Older Keychron keyboards (those not based on QMK) use the hid_apple driver on Linux, even in the Windows/Android mode, both in Bluetooth and Wired modes.

Activate wsl2

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart
dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart
wsl --set-default-version 2

Install and Configure Ubuntu

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

Awesome Go

financial support to Awesome Go

A curated list of awesome Go frameworks, libraries and software. Inspired by awesome-python.

	{
	"loader": "ts-node/esm",
	"extensions": ["ts"],
	"spec": [
	"tests/*.ts"
	]
	}

	{
	"title": "Quake-style Hotkey Window for Wezterm",
	"rules": [
	{
	"description": "Launch/show Wezterm if it is not in foreground",
	"manipulators": [
	{
	"type": "basic",
	"from": {
	"key_code": "escape",

	- This page is a collection of some of the Advanced queries from the [[Datalog]] channel on the [[Logseq/Discord]] server. #datalog
	id:: 61db13f4-75e8-4f87-ad60-3ac3479c5fc8
	- ### Resources
	- [link: The first message on the datalog channel](https://discord.com/channels/725182569297215569/743139225746145311/743139795865174119)
	- [link: Logseq docs - Advanced queries](https://docs.logseq.com/#/page/advanced%20queries)
	- [link: Logseq datascript schema](https://gist.github.com/tiensonqin/9a40575827f8f63eec54432443ecb929)
	- [link: Logseq frontend db model](https://github.com/logseq/logseq/blob/master/src/main/frontend/db/model.cljs)
	- [link: How to Graph Your Data - talk by Paula Gearon](https://youtu.be/tbVwmFBnfo4)
	- [link: Domain modelling with datalog - talk by Norbert Wojtowicz](https://youtu.be/oo-7mN9WXTw)
	- [link: Athens Research ClojureFam](https://github.com/athensresearch/ClojureFam)

	# Docker compose to set up containers for all services you need:
	# VPN
	# Sonarr, Radarr, Lidarr, Qbittorrent
	# Non-VPN
	# Plex, get_iplayer
	# Before running docker-compose, you should pre-create all of the following folders.
	# Folders for Docker State:
	# /volume1/dockerdata. - root where this docker-compose.yml should live
	# /volume1/dockerdata/plex - Plex config and DB
	# /volume1/dockerdata/sonarr - Sonarr config and DB

	## ZSH Options
	# http://zsh.sourceforge.net/Doc/Release/Options.html

	# Changing Directories
	# http://zsh.sourceforge.net/Doc/Release/Options.html#Changing-Directories
	setopt auto_cd # if a command isn't valid, but is a directory, cd to that dir
	setopt auto_pushd # make cd push the old directory onto the directory stack
	setopt pushd_ignore_dups # don’t push multiple copies of the same directory onto the directory stack
	setopt pushd_minus # exchanges the meanings of ‘+’ and ‘-’ when specifying a directory in the stack