framp’s gists

framp / Cargo.toml

Last active August 4, 2024 22:02

SUM + IN in sqlx

	[package]
	name = "sqlxxx"
	version = "0.1.0"
	edition = "2021"

	[dependencies]
	anyhow = "1.0.86"
	sqlx = { version = "0.7", features = ["runtime-tokio", "tls-rustls", "sqlite"] }
	tokio = { version = "1", features = ["macros", "rt-multi-thread"] }

framp / sentry-daemon-set.yaml

Created May 27, 2024 18:18

framp / fix-upperbody.py

Last active October 4, 2023 18:30

Detect upperbody and crop a video around it (needs a pass of stabilization afterward, experiment with different classifiers)

	import cv2

	target_cascade = cv2.CascadeClassifier('haarcascade_upperbody.xml')
	video_capture = cv2.VideoCapture('your_video.mp4')

	fps = int(video_capture.get(cv2.CAP_PROP_FPS))

	output_width, output_height = 400, 300
	fourcc = cv2.VideoWriter_fourcc(*'XVID')
	output_video = cv2.VideoWriter('output_video2.mp4', fourcc, fps, (output_width, output_height))

framp / 10m.sh

Last active September 17, 2023 00:29

Blue Green Deployment with Traefik and automatic git sync

	#!/usr/bin/env bash

	output=$(git pull)

	if [[ $output == "Already up to date." ]]; then
	echo "No changes detected."
	else
	echo "Changes detected."
	color=$(grep file dynamic/http.routers.docker-localhost.yml \| cut -d' ' -f8 \| cut -d'@' -f 1);
	new_color=$([ "$color" = "green" ] && echo "blue" \|\| echo "green")

framp / stream-rtmp.sh

Created September 15, 2023 11:38

	ffmpeg \
	-re -i playlist.m3u8 -vcodec libx264 -preset ultrafast -maxrate 600k -b:v 2500k \
	-bufsize 600k -pix_fmt yuv420p -g 60 -c:a aac -b:a 160k -ac 2 \
	-ar 44100 -f flv -s 1280x720 "rtmp://$YOURSERVER/$AUTH"

framp / elysia-file-system-router.ts

Created September 11, 2023 11:21

Just use https://github.com/wobsoriano/elysia-autoroutes

	import Elysia from "elysia";

	const router = new Bun.FileSystemRouter({
	style: "nextjs",
	dir: import.meta.dir,
	});

	export const get = () => 'OK';

	export default new Elysia()

framp / subtle.js

Created September 9, 2023 14:38

	/*
	crypto.subtle.generateKey({
	name: 'RSA-OAEP',
	modulusLength: 2048,
	publicExponent: new Uint8Array([1, 0, 1]),
	hash: {name: 'SHA-256'}
	}, true, ['encrypt', 'decrypt'])
	.then(keypair =>
	crypto.subtle.encrypt({ name: 'RSA-OAEP', hash: {name: 'SHA-256'}}, keypair.publicKey, (new TextEncoder()).encode('lol'))
	.then(encrypted => crypto.subtle.decrypt({ name: 'RSA-OAEP', hash: {name: 'SHA-256'}}, keypair.privateKey, encrypted))

framp / weather-paphos.sh

Last active May 29, 2023 17:49

Get weather info for Paphos, Cyprus

	#!/bin/bash
	SEA=$(curl 'https://seatemperature.info/paphos-water-temperature.html' \
	-H 'authority: seatemperature.info' \
	-H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.7' \
	-H 'accept-language: en-GB,en;q=0.9,en-US;q=0.8,it;q=0.7,es;q=0.6' \
	-H 'cache-control: no-cache' \
	-H 'cookie: adviv=1' \
	-H 'dnt: 1' \
	-H 'pragma: no-cache' \
	-H 'sec-ch-ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24"' \

framp / newton-rhapson-method.js

Created January 12, 2023 07:37

Newton-Rhapson-Method for nicely distributed random numbers on a 2d plane

	const randomPoints = (n: number, d = 2) =>
	const d = 2;
	let g = 1.0;
	for (let i = 0; i < 20; i++) {
	g = g - (Math.pow(g, d + 1) - g - 1) / ((d + 1) * Math.pow(g, d) - 1);
	}
	const alpha = new Array(d).fill(0);
	for (let j = 0; j < d; j++) {
	alpha[j] = Math.pow(1 / g, j + 1) % 1;
	}

framp / short-keys.js

Created December 19, 2022 11:52

	const fs = require('fs');

	const TARGET_FILE = './src/config.tsx';
	const file = fs.readFileSync(TARGET_FILE).toString();
	const lines = file.split('\n');
	const start = lines.findIndex(l => l === '// KEYS');
	const end = lines.findIndex(l => l === '// \\ KEYS');
	const constants = lines.slice(start, end).map((l, i) => l.replace(/".*"/, `"${i.toString(36)}"`));
	lines.splice(start, end-start, ...constants);
	fs.writeFileSync(TARGET_FILE, lines.join('\n'));

Federico Rampazzo framp