Skip to content

Instantly share code, notes, and snippets.

@framp
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"] }
apiVersion: apps/v1
kind: DaemonSet
metadata:
labels:
k8s-app: sentry-logging
name: sentry
namespace: kube-system
spec:
selector:
matchLabels:
@framp
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
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")
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"
import Elysia from "elysia";
const router = new Bun.FileSystemRouter({
style: "nextjs",
dir: import.meta.dir,
});
export const get = () => 'OK';
export default new Elysia()
/*
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
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
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;
}
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'));