Discover gists

README template for your project

Intro section

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

Original post: kubo39/gist 🇯🇵

About SIEVE Cache

A cache algorithm called [SIEVE][sieve-website] was announced in 2023. It claims to be simpler than LRU, and indeed it is a fairly simple algorithm, but it is said to perform as well as existing superior cache algorithms such as S3-FIFO and TinyLFU.

Span.io API Documentation

The Span API does not at this time require any authentication. This will probably change in the future.

Description: Gets panel summary, firmware version, door state, serial number, network status Request: GET /api/v1/status Response:

{
  "software": {
    "firmwareVersion": "spanos2/r202216/04",

`vs` Questions

http://stackoverflow.com/questions/804115 (rebase vs merge).
https://www.atlassian.com/git/tutorials/merging-vs-rebasing (rebase vs merge)
https://www.atlassian.com/git/tutorials/undoing-changes/ (reset vs checkout vs revert)
http://stackoverflow.com/questions/2221658 (HEAD^ vs HEAD~) (See git rev-parse)
http://stackoverflow.com/questions/292357 (pull vs fetch)
http://stackoverflow.com/questions/39651 (stash vs branch)
http://stackoverflow.com/questions/8358035 (reset vs checkout vs revert)

	<template>
	<div
	ref="scrollContainer"
	class="overflow-auto"
	:class="state.dragging ? 'cursor-grabbing' : 'cursor-grab'"
	@mousedown="handleMouseDown"
	@mousemove="handleMouseMove"
	@mouseup="handleMouseUp"
	>
	<div ref="content" class="content" @selectstart="handleSelectStart">

	#!/usr/bin/env bash
	#
	# add smart quotes to Hugo Markdown source files, using the
	# reference implementation of CommonMark's CLI tool:
	# https://github.com/commonmark/commonmark-spec
	# Notes:
	# - assumes TOML front matter
	# - converts footnote-style links to inline
	# - normalizes ordered/unordered list formatting
	#

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	Email: 982092332@qq.com
	SN: GAWAE-FCWQ3-P8NYB-C7GF7-NEDRT-Q5DTB-MFZG6-6NEQC-CRMUD-8MZ2K-66SRB-SU8EW-EDLZ9-TGH3S-8SGA