Discover gists

VFIO Setup on NixOS

Disclaimer: Nobody else tested my setup so far, so this is a "works on my machine" scenario. I am not responsible for anything you break on your machine (although I'd not expect much harm).

Hardware

My system has the following hardware:

Board: ASRock X570 Pro4

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

Built-in

diskutil erasevolume HFS+ 'RAM Disk' `hdiutil attach -nobrowse -nomount ram://XXXXX`

where XXXXX is the size of the RAM disk in terms of memory blocks.

Notes:

	import subprocess
	import datetime
	import urllib.parse
	import logging
	import os
	from typing import List, Dict, Any, Optional
	import io
	import PIL.Image as Image

	function append(separator) {
	return typeof separator === "string" ? appender(separator, "") : appender("", "").apply(this, arguments);
	}

	function appender(separator, s) {
	return function tag(literalParts, ...computedParts) {
	s += literalParts[0];
	for (let i = 1; i < literalParts.length; ++i) {
	s += computedParts[i - 1] + literalParts[i];
	}

	Latency Comparison Numbers (~2012)
	----------------------------------
	L1 cache reference 0.5 ns
	Branch mispredict 5 ns
	L2 cache reference 7 ns 14x L1 cache
	Mutex lock/unlock 25 ns
	Main memory reference 100 ns 20x L2 cache, 200x L1 cache
	Compress 1K bytes with Zippy 3,000 ns 3 us
	Send 1K bytes over 1 Gbps network 10,000 ns 10 us
	Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD

	This will help you activate Microsoft Windows 10/11
	===================================================

	Run CMD as Administrator these 3 commands:

	[1] slmgr /ipk [windows_key_from_below]

	Home: TX9XD-98N7V-6WMQ6-BX7FG-H8Q99
	Home N: 3KHY7-WNT83-DGQKR-F7HPR-844BM
	Home Single Language: 7HNRX-D7KGG-3K4RQ-4WPJ4-YTDFH

	/**
	Replace the "<DOCID>" with your document ID, or the entire URL per say. Should be something like:
	var EMAIL_TEMPLATE_DOC_URL = 'https://docs.google.com/document/d/asdasdakvJZasdasd3nR8kmbiphqlykM-zxcrasdasdad/edit?usp=sharing';
	*/

	var EMAIL_TEMPLATE_DOC_URL = 'https://docs.google.com/document/d/<DOCID>/edit?usp=sharing';
	var EMAIL_SUBJECT = 'This is an important email';

	/**
	* Sends a customized email for every response on a form.

	# Quick and easy one line command to setup a global .gitignore file and ignore macOS .DS_store files globally
	git config --global core.excludesfile "~/.gitignore" && echo .DS_Store >> ~/.gitignore

	Per this forum post: https://esp32.com/viewtopic.php?t=6701
	The way to calculate max PWM frequency is integer (log 2 (LEDC_APB_CLK / frequency))

	With a LEDC_APB_CLK == 80MHz, these are the following maximum values, in Hz:

	LEDC_TIMER_1_BIT, 40000000
	LEDC_TIMER_2_BIT, 20000000
	LEDC_TIMER_3_BIT, 10000000
	LEDC_TIMER_4_BIT, 5000000
	LEDC_TIMER_5_BIT, 2500000