edisplay edisplay

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

Laravel Xampp Setup (Windows & Mac)

Install Xampp

Install Xampp from https://www.apachefriends.org/index.html

Run the Xampp installer and open the Xampp control panel
Make sure that you enable the Apache and MySQL services
On mac you need to click "Start" on the Home tab, "Enable" on the Network tab and "Mount" on the Location Tab. Click "Explore" on the location tab to open your Xampp/Lampp folder

Install Composer

Laravel Valet Setup (Mac)

This will get you setup with Laravel & Valet on your Mac. Quentin Watt has a good video tutorial on getting setup here as well

Install Homebrew

Go to https://brew.sh/ and copy the command and run in your terminal

It will be something like this...

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

To clear 307 HSTS redirects in Google Chrome (if you experimenting with SSL -- you probably wouldn't want to do this for a site that you do not opperate, since it is there to protect you), go to the following URL and delete the site.

chrome://net-internals/#hsts

	import os

	os.environ["OPENAI_API_KEY"] = "XXX"
	os.environ["GROQ_API_KEY"] = "YYY"

	from routellm.controller import Controller

	client = Controller(
	routers=["mf"],
	strong_model="gpt-4-1106-preview",

	#!/bin/bash
	iatest=$(expr index "$-" i)

	#######################################################
	# SOURCED ALIAS'S AND SCRIPTS BY zachbrowne.me
	#######################################################

	# Source global definitions
	if [ -f /etc/bashrc ]; then
	. /etc/bashrc

	<#

	____ ______ ______ ____ __ __
	/\ _`\ /\ _ \ /\__ _\/\ _`\ /\ \/\ \
	\ \ \L\ \\ \ \L\ \\/_/\ \/\ \ \/\_\\ \ \_\ \
	\ \ ,__/ \ \ __ \ \ \ \ \ \ \/_/_\ \ _ \
	\ \ \/ \ \ \/\ \ \ \ \ \ \ \L\ \\ \ \ \ \
	\ \_\ \ \_\ \_\ \ \_\ \ \____/ \ \_\ \_\
	\/_/ \/_/\/_/ \/_/ \/___/ \/_/\/_/

	[
	{
	"created": "2022-11-21T23:25:28.008Z",
	"name": "sjs-request-page-index",
	"tags": [
	"sjs-request-page-index"
	],
	"content": "import { Component } from \"solid-js\";\n\nconst RequestIndex: Component = () => {\n return (\n <div class=\"flex flex-col md:flex-row gap-4 justify-center items-center bg-gray-200 p-4 border border-gray-300 min-h-full rounded-lg\">\n <div class=\"text-2xl flex gap-4 items-center\">\n <ion-icon class=\"text-4xl\" name=\"arrow-back-circle-outline\"></ion-icon>\n <span>Select a request from the left panel</span>\n </div>\n </div>\n );\n};\n\nexport default RequestIndex;",
	"contentType": "typescriptreact"
	},

	# http://stackoverflow.com/questions/5735666/execute-bash-script-from-url
	bash <(curl -s http://mywebsite.com/myscript.txt)

	# http://stackoverflow.com/questions/4642915/passing-parameters-to-bash-when-executing-a-script-fetched-by-curl
	curl http://foo.com/script.sh \| bash -s arg1 arg2