Skip to content

Instantly share code, notes, and snippets.

View frafra's full-sized avatar

Francesco Frassinelli frafra

View GitHub Profile
@frafra
frafra / functions.sh
Created February 8, 2023 08:14
debug tricks
function read_strace_file() {
strace --trace=file "$@" |&
sed --quiet 's;.*"\(/[^"]*\)".*;\1;p' |
sort --unique |
fzf --scheme=path |
xargs --no-run-if-empty less
}
export read_strace_file
@frafra
frafra / look_for_value.sql
Created October 10, 2022 16:27
Look if any column contains such a value
create function pg_temp.look_for_value(value text) returns
table(table_fullname text, column_name text)
language plpgsql as $$
declare
r record;
found bool;
begin
for r in select * from information_schema.columns
loop
table_fullname = format('%I.%I.%I', r.table_catalog, r.table_schema, r.table_name);
@frafra
frafra / v4l2loopback_on_fedora_34.md
Last active August 28, 2022 16:33 — forked from kevineduardo/v4l2loopback_on_fedora_34.md
How to install (and compile) the latest v4l2loopback kernel module on Fedora Workstation 34

How to install (and compile) the latest v4l2loopback kernel module on Fedora Workstation 34

Execute the commands below

sudo dnf install git kernel-devel kernel-headers dkms v4l-utils
git clone https://github.com/umlaeute/v4l2loopback.git
cd v4l2loopback
make
v=$(./currentversion.sh)
@frafra
frafra / add-mitmproxy-cert.sh
Last active March 31, 2022 10:34
mitmproxy snippets and examples
#!/bin/bash -xeu
path="/usr/local/share/ca-certificates/mitmproxy"
mkdir -p "$path"
curl -x mitmproxy:8080 mitm.it/cert/pem > "$path/mitmproxy.crt"
# System
update-ca-certificates
# Java
@frafra
frafra / find-dupes-dir.sh
Last active March 14, 2022 08:45
Find identical files and folders (comparing file names, paths and sizes)
#!/bin/bash
#
# Example:
# $ ./find-dupes-dir.sh $HOME/Documents/*/
set -Eeuo pipefail
declare -A dirs
for dir in "$@"
do
#!/bin/bash
#
# Build a container with the required command and run it
set -euo pipefail
docker_like() {
if command -v podman &> /dev/null
then
podman "$@"
@frafra
frafra / remove-files-from-git.md
Last active July 4, 2022 13:42
Remove files from git history

Did you forgot to add some rules into your .gitignore and committed some files by mistake? Here is how to fix that. Be aware that this procedure is going to overwrite the entire history of the project and your collaborators will have to clone the repository again.

Fix .gitignore files and commit

Fix your .gitignore files. You can have more than one, by placing them into different folders (useful for projects using different programming languages). Use https://gitignore.io to generate good defaults.

Remove ignored files and commit

@frafra
frafra / example-cleanup.sh
Created November 14, 2021 23:32
Run a service in a specific time range using systemd
#!/bin/bash
for unit in test_python_stop.service test_python_{start,stop}.timer
do
systemctl --user stop $unit
systemctl --user disable $unit
done
systemctl --user stop test_python.service
rm -f \
~/.config/systemd/user/test_python.service \
@frafra
frafra / scan-network.sh
Last active May 28, 2021 23:05
Scan local network and show hostname, IP, MAC address, brand
#!/bin/sh
if (( $# != 1 )); then
>&2 echo "Usage: $0 NETWORK_INTERFACE"
exit 1
fi
sudo arp-scan -gx --localnet -I $1 |
awk '{
l=""
@frafra
frafra / .pre-commit-config.yaml
Last active November 30, 2023 03:36
Good defaults for a Python project: Poetry + pre-commit + black + flakehell + isort
repos:
- repo: local
hooks:
- id: black
name: black
entry: black
language: system
types: [python]
- repo: local
hooks: