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

Как собирать общую статистику по git репозиторию

Команда git summary

Команда git summary не является встроенной и требует установки пакета git-extras

С помощью команды можно узнать процент авторства исходного кода проекта:

# Количество и процент написанных разработчиком строк во всех файлов проекта

📂 Minimize allocations in Go

A collection of tips for when you need to minimize the number of allocations in your Go programs.

Use the go profiler to identify which parts of your program are responsible for most allocations.

⚠️ Never apply these tricks blindly (i.e. without measuring the actual performance benefit/impact). Most of these tricks cause a tradeoff between reducing memory allocations and other aspects (including e.g. higher peak memory usage, higher CPU usage, lower maintainability, higher probability of introducing subtle bugs). Only apply these tricks if the tradeoff in every specfic case is globally positive.

Protobuf

Building Complex Drag & Drop Visual AI Workflows with React Flow and Python Flask

Created by @rUv

This tutorial demonstrates how to create a Python Flask implementation with React Flow to build complex AI workflows, reasoning systems, and comprehension modeling tools.

React Flow is a powerful open-source library for building interactive node-based interfaces in React applications. Its flexibility and extensibility make it an excellent choice for creating sophisticated AI applications.

tmux shortcuts & cheatsheet

start new with session name:

tmux new -s myname

attach to named:

tmux a -t myname

	version: 2.1

	setup: true

	orbs:
	path-filtering: circleci/path-filtering@0.0.2

	workflows:
	setup-workflow:
	jobs:

	# PowerView's last major overhaul is detailed here: http://www.harmj0y.net/blog/powershell/make-powerview-great-again/
	# tricks for the 'old' PowerView are at https://gist.github.com/HarmJ0y/3328d954607d71362e3c

	# the most up-to-date version of PowerView will always be in the dev branch of PowerSploit:
	# https://github.com/PowerShellMafia/PowerSploit/blob/dev/Recon/PowerView.ps1

	# New function naming schema:
	# Verbs:
	# Get : retrieve full raw data sets
	# Find : ‘find’ specific data entries in a data set

	#!/usr/bin/env python3

	import os
	import sys

	_b = sys.version_info[0] < 3 and (lambda x:x) or (lambda x:x.encode('utf-8'))

	def ssh_exec_pass(password, args, capture_output=False):
	'''
	Wrapper around openssh that allows you to send a password to

	adb help // List all comands

	== Adb Server
	adb kill-server
	adb start-server

	== Adb Reboot
	adb reboot
	adb reboot recovery
	adb reboot-bootloader

	#!/bin/bash
	# By @minad and @SietsevanderMolen

	WIFI_VM="sys-net"

	json() {
	if [[ -n "$3" ]]; then
	echo -n "{\"name\":\"$1\",\"color\":\"$3\",\"full_text\":\"$2\"},"
	else
	echo -n "{\"name\":\"$1\",\"full_text\":\"$2\"},"