Discover gists

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

Which GGUF is right for me? (Opinionated)

Good question! I am collecting human data on how quantization affects outputs. See here for more information: ggerganov/llama.cpp#5962

In the meantime, use the largest that fully fits in your GPU. If you can comfortably fit Q4_K_S, try using a model with more parameters.

llama.cpp feature matrix

See the wiki upstream: https://github.com/ggerganov/llama.cpp/wiki/Feature-matrix

Anti-hype LLM reading list

Goals: Add links that are reasonable and good explanations of how stuff works. No hype and no vendor content if possible. Practical first-hand accounts of models in prod eagerly sought.

Foundational Concepts

Pre-Transformer Models

Align icons with multi-line label text

Originally tweeted by Adam Wathan: https://twitter.com/adamwathan/status/1217864323466432516?lang=en

Codepen: https://codepen.io/adamwathan/pen/bGNxMpz?editors=1000

<div class="bg-gray-100 min-h-screen antialiased text-gray-900 p-6">
  <div class="max-w-sm mx-auto">
    <div class="">

	#using ubuntu22 in this doc
	#you must have an existing digitalocean spaces account or bucket

	#install awscli
	root@kansas:/home/masterje# apt install awscli

	#you will need to use the --endpoint option
	root@kansas:/home/masterje# aws s3 ls --endpoint=https://sgp1.digitaloceanspaces.com
	Unable to locate credentials. You can configure credentials by running "aws configure".

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>Document</title>
	<style>
	#header {


	declare -ar _status=(
	[ 0]=😀 # Success
	[ 1]=🤨 # Error
	[129]=📞 # SIGHUP
	[130]=🛑 # SIGINT
	[131]="(╯°□°）╯︵ ┻━┻" # SIGQUIT
	[132]=👮 # SIGILL
	[133]=🐍 # SIGTRAP
	[134]=💥 # SIGABRT

	declare -a elems=(
	"a 1"
	"b 2"
	"c 3 word"
	"d 4"
	)

	for elem in "${elems[@]}"; do
	read -a strarr <<< "$elem" # uses default whitespace IFS
	echo ${strarr[0]} ${strarr[1]} ${strarr[2]}

	-- Licensed under the MIT License, Copyright (c) 2024 jack.ink

	local function resume_with_error_check(thread: thread, ...: any): ()
	local success, message = coroutine.resume(thread, ...)

	if not success then
	print(string.char(27) .. "[31m" .. message)
	end
	end

	// This is a documented version of the build.gradle file from RemotePreferences:
	// https://github.com/apsun/RemotePreferences/blob/master/library/build.gradle.kts
	//
	// It aims to explain exactly WTF is going on when you inevitably copy-paste
	// someone's build.gradle from the internet and can't figure out why it's not
	// working.
	//
	// It contains, to the best of my knowledge, the best practices as of Oct 2023 for
	// building an Android library and publishing it to OSSRH (Maven Central).
	//