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

Preact + Material-UI example

Preact is a fast 3kB alternative to React with the same modern API.

This example uses shows how to use Material UI 4 with Preact X and Preact CLI 3.

How to use

git clone blah preact-mui

Small warning for everyone that are thinking if using Tex colors is a good idea or not

2023-05-02 - Since a few days ago \colorbox and \fcolorbox are broken and Github did't talk about if it's a temporary thing or if it will not be added back.
- 2024-01-04 - Since it has not being added back I deduce that it will never be so I removed all mentions to it on the rest of the gist.
2023-09-29 - Tex seems to not work on h1 to h6 anymore (markdown #'s)
- 2024-01-04 - Now it works again, I'll keep the message for a while to remember that it may change again in the future

As you can se with the above message(s) Tex may not be very stable and may not be an option to you as of the dates expressed above. You can also check other tex problems here.

Github released Tex support and colors* to the markdown and you din't realized

Consider this an informal guide to reading the Solana snapshot format. This guide is written for Solana Labs versions v1.14 through v1.17.

You are probably reading this because you want to read the accounts in a snapshot without going through the pain of interfacing with the Solana Labs codebase.

Terminology

We assume general familiarity with the Solana ledger.

My current favorite SD models

Warning

To access the discord post links please join the TouhouAI (24k members) discord server.

WIP

Enlaces con otros ficheros compartidos en los comentarios:

Conversor del CSV a otros formatos by @Fechin
Versión que incluye regiones como Inglaterra que tienen códigos ISO by @ideaalab

	'use strict';

	const crypto = require('crypto');

	exports.handler = (event, context, callback) => {
	const request = event.Records[0].cf.request;
	const headers = request.headers;
	const method = request.method;
	const body = Buffer.from(request.body.data, 'base64').toString();

	import kotlinx.cinterop.memScoped
	import kotlinx.cinterop.allocArrayOf
	import kotlinx.cinterop.addressOf
	import kotlinx.cinterop.usePinned
	import platform.Foundation.NSData
	import platform.Foundation.create
	import platform.posix.memcpy

	public fun ByteArray.toData(): NSData = memScoped {
	NSData.create(bytes = allocArrayOf(this@toData),

	You are an assistant that engages in extremely thorough, self-questioning reasoning. Your approach mirrors human stream-of-consciousness thinking, characterized by continuous exploration, self-doubt, and iterative analysis.

	## Core Principles

	1. EXPLORATION OVER CONCLUSION
	- Never rush to conclusions
	- Keep exploring until a solution emerges naturally from the evidence
	- If uncertain, continue reasoning indefinitely
	- Question every assumption and inference

	<html>
	<body>
	<main>
	<h1>CatPhotoApp</h1>
	<section>
	<h2>Cat Photos</h2>
	<!-- TODO: Add link to cat photos -->
	<p>See more <a target="_blank" href="https://freecatphotoapp.com">cat photos</a> in our gallery.</p>
	<a href="https://freecatphotoapp.com"><img src="https://cdn.freecodecamp.org/curriculum/cat-photo-app/relaxing-cat.jpg" alt="A cute orange cat lying on its back."></a>
	</section>