edisplay edisplay

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

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

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

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

	# The NYC Taxis Dataset - https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page

	pip install parquet-cli

	parq data/yellow_tripdata_2022-01.parquet

	parq data/yellow_tripdata_2022-01.parquet --schema

	parq data/yellow_tripdata_2022-01.parquet --head 10

	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

	[
	{
	"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