shner-elmo’s gists

timabell / backup-vm.sh

Last active May 27, 2024 22:24

tar+lz4 backup with progress - https://timwise.co.uk/2018/04/01/building-a-windows-10-development-vm-from-scratch/

vi3k6i5 / flashtext_regex_timing_keyword_replace.py

Last active May 28, 2023 19:54

Benchmarking timing performance Keyword Replace between regex and flashtext

	#!/bin/python
	from flashtext.keyword import KeywordProcessor
	import random
	import string
	import re
	import time


	def get_word_of_length(str_length):
	# generate a random word of given length

vi3k6i5 / flashtext_regex_timing_keyword_extraction.py

Last active May 28, 2023 21:05

Benchmarking timing performance Keyword Extraction between regex and flashtext

	#!/bin/python
	from flashtext.keyword import KeywordProcessor
	import random
	import string
	import re
	import time

	def get_word_of_length(str_length):
	# generate a random word of given length
	return ''.join(random.choice(string.ascii_lowercase) for _ in range(str_length))

niw / fetch_nike_puls_all_activities.bash

Last active August 11, 2024 16:27

A simple NikePlus API description to fetch past run metrics

	#!/usr/bin/env bash

	# fetch_nike_puls_all_activities.bash
	# A simple bash script to fetch all activities and metrics from NikePlus.
	# See `nike_plus_api.md` for the API details.

	readonly bearer_token="$1"
	if [[ -z "$bearer_token" ]]; then
	echo "Usage: $0 bearer_token"
	exit

Mevrael / mysql_5.7_join_json_column_id.sql

Last active January 11, 2024 16:58

MySQL 5.7 JOIN on JSON column of IDs


	# Example for MySQL 5.7 how to use JOIN on 2 tables without junction table using new JSON column type.
	# Let say we have 2 tables: posts and users
	# Users may like posts
	# We store the IDs of users who liked each post in posts.liked column which is a JSON array
	# which might have a content like "[1, 2, 5, 10]"

	SELECT posts.id AS post_id, users.id AS liked_by_user_id FROM posts JOIN users ON JSON_CONTAINS(posts.liked, CAST(users.id AS CHAR))

pylover / inspections.txt

Last active August 18, 2024 09:49 — forked from ar45/inspections.txt

PyCharm inspections

	# Extracted using: $ unzip -p lib/pycharm.jar com/jetbrains/python/PyBundle.properties \| grep -B1 INSP.NAME \| grep '^#' \| sed 's\|Inspection\|\|g' \| sed -e 's\|#\s\{,1\}\|# noinspection \|'

	# noinspection PyPep8
	# noinspection PyPep8Naming
	# noinspection PyTypeChecker
	# noinspection PyAbstractClass
	# noinspection PyArgumentEqualDefault
	# noinspection PyArgumentList
	# noinspection PyAssignmentToLoopOrWithParameter
	# noinspection PyAttributeOutsideInit

jboner / latency.txt

Last active September 26, 2024 18:19

Latency Numbers Every Programmer Should Know

	Latency Comparison Numbers (~2012)
	----------------------------------
	L1 cache reference 0.5 ns
	Branch mispredict 5 ns
	L2 cache reference 7 ns 14x L1 cache
	Mutex lock/unlock 25 ns
	Main memory reference 100 ns 20x L2 cache, 200x L1 cache
	Compress 1K bytes with Zippy 3,000 ns 3 us
	Send 1K bytes over 1 Gbps network 10,000 ns 10 us
	Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD

Shneor E. shner-elmo