Skip to content

Instantly share code, notes, and snippets.

View CodeAdminDe's full-sized avatar

Frederic Roggon CodeAdminDe

  • Hamburg, Germany
View GitHub Profile
@bl0wfish
bl0wfish / migrate_n8n_sqlite_to_postgres.sh
Created November 20, 2025 11:52
Migrate n8n from SQLite to PostgreSQL
#!/usr/bin/env bash
set -euo pipefail
#############################################
# Configuration
#############################################
# Load .env file if present
if [ -f .env ]; then
export $(grep -v '^#' .env | xargs -r)
@c0m4r
c0m4r / vyos_installation_hetzner_cloud.md
Last active January 23, 2026 18:45
VyOS installation on Hetzner Cloud VPS

VyOS installation on Hetzner Cloud VPS

This guide explains how to install the VyOS Rolling Release (free nightly builds) on Hetzner Cloud VPS. This might also work for other VPS providers with the proper rescue system in place.

First log into Hetzner Cloud, switch to your VPS control panel, select Rescue -> Enable Rescue and Power Cycle. It takes up to 1 minute to boot into rescue mode. Your login details will be displayed in the control panel after you activate the console. You can also use previously defined SSH keys.

Hetzner Rescue SSH

Download and write the ISO image in the Rescue environment:

@anjmao
anjmao / security-context-capabilities.yaml
Last active January 6, 2026 17:33
Kubernetes security context all capabilities
apiVersion: v1
kind: Pod
metadata:
name: security-context-capabilities
spec:
containers:
- name: example
image: gcr.io/google-samples/node-hello:1.0
securityContext:
capabilities:
@kvaps
kvaps / talos-build.sh
Last active April 15, 2025 16:19
How to build talos with custom kernel extensions
# Builds pkg
cd ./pkgs
git checkout release-1.9
make PKGS_PREFIX=ghcr.io/kvaps/talos PUSH=1 USERNAME=kvaps/talos PLATFORM=linux/amd64
# output would be:
# => pushing manifest for ghcr.io/kvaps/talos/base:v1.9.0-15-g45c4ba4-dirty@sha256:f3d0f691752e3158c4f36b05e4b5abad2e68437f0faa0928887e69e568ca364d
# Builds talos (with clustom pkgs)
cd ./talos
@DewaldDeJager
DewaldDeJager / README.md
Last active November 27, 2025 09:16
Easy GitHub workflow for keeping a fork in sync with upstream

Sync Fork

This workflow uses the GitHub CLI to keep a forked repo in sync with the upstream repo. Add it to your repo as .github/workflows/sync-fork.yaml.

It runs daily to sync the default branch and can be triggered manually for any branch.

@phlbnks
phlbnks / gmail_oauth.sh
Created January 31, 2023 23:12
Script to generate OAuth token file for use with Google API, specifically with parsedmarc / dmarc-visualizer
#!/bin/bash
# Injest / setup vars // TODO: error handling needed
client_id=$( cat parsedmarc/credentials.json | jq -r '.installed.client_id' )
client_secret=$( cat parsedmarc/credentials.json | jq -r '.installed.client_secret' )
scope="https://www.googleapis.com/auth/gmail.modify"
echo
echo "This script will take your OAuth Desktop Application credentials.json and use it to get a token to interact with the API"
sleep 2
@ipbastola
ipbastola / jq to filter by value.md
Last active January 16, 2026 18:37
JQ to filter JSON by value

JQ to filter JSON by value

Syntax: cat <filename> | jq -c '.[] | select( .<key> | contains("<value>"))'

Example: To get json record having _id equal 611

cat my.json | jq -c '.[] | select( ._id | contains(611))'

Remember: if JSON value has no double quotes (eg. for numeric) to do not supply in filter i.e. in contains(611)

@kshiteesh
kshiteesh / urlsafari
Last active December 15, 2025 14:33
This AppleScript saves all the tabs open in all Safari windows to a Markdown file.
(*
Export All Safari Tabs in All Open Windows to a Markdown File
July 13, 2015
// SCRIPT PAGE
http://hegde.me/urlsafari
// ORIGINAL SCRIPT ON WHICH THIS SCRIPT IS BUILT
http://veritrope.com/code/export-all-safari-tabs-to-a-text-file