Alexander Loth aloth
🔬
aloth
/ backup_n8n_azure_aks.sh
Created
December 14, 2025 12:20
Robustly export n8n workflows and decrypted credentials from Kubernetes on Azure.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # --- CONFIGURATION --- | |
| export N8N_NAMESPACE="n8n" | |
| # Directory where files will be saved | |
| BACKUP_DIR="n8n_backup_$(date +%Y%m%d_%H%M%S)" | |
| echo "STARTING N8N BACKUP" | |
| echo "-------------------" |
aloth
/ Tableau LinkedIn lookup with Python and Azure Cognitive Services.txt
Last active
January 30, 2019 10:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SCRIPT_STR(" | |
| import http.client, urllib, base64, json | |
| YOUR_API_KEY = 'xxx' | |
| name = _arg1[0] | |
| company = _arg2[0] | |
| try: | |
| headers = {'Ocp-Apim-Subscription-Key': YOUR_API_KEY } | |
| params = urllib.urlencode({'q': name + ' ' + company + ' linkedin','count': '3'}) | |
| connection = http.client.HTTPSConnection('api.cognitive.microsoft.com') | |
| connection.request('GET', '/bing/v7.0/search?%s' % params, '{body}', headers) |
aloth
/ wheezy-backports-raspbian.sh
Created
July 23, 2018 19:17
Debian Backports for Raspbian Wheezy (works on ARMv7 devices: Pi 2 and newer)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| echo "deb http://ftp.fr.debian.org/debian/ wheezy-backports main contrib non-free" | sudo sh -c 'cat >> /etc/apt/sources.list' | |
| echo "deb-src http://ftp.fr.debian.org/debian/ wheezy-backports main" | sudo sh -c 'cat >> /etc/apt/sources.list' | |
| gpg --keyserver pgpkeys.mit.edu --recv-key 7638D0442B90D010 | |
| gpg -a --export 7638D0442B90D010 | sudo apt-key add - | |
| sudo apt-get update |
aloth
/ tc17_julia_tableau_sphere.txt
Created
September 19, 2017 08:53
Calling Julia code from Tableau via R
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SCRIPT_INT(' | |
| library(XRJulia) | |
| if (!exists("ev")) ev <- RJulia() | |
| y <- juliaEval(" | |
| 4 / 3 * %s * ' + STR([Factor]) + ' * pi ^ 3 | |
| ", .arg1) | |
| ', | |
| [Radius]) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SCRIPT_STR(' | |
| newurl <- .arg1 | |
| url <- "" | |
| while(url != newurl){ | |
| data <- system(toString(paste0("curl -I ", newurl)), intern=T) | |
| if(sum(grepl("location: ", tolower(data))) == 0){ | |
| url <- newurl | |
| }else{ | |
| data <- subset(data, tolower(substring(data, 1, 9))=="location:") | |
| stringurl <- substring(data[1], 11, nchar(data[1])-1) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| REGEXP_EXTRACT( | |
| [Post Message], | |
| '((?:http|https)://(?:[\w_-]+(?:(?:\.[\w_-]+)+))(?:[\w.,@?^=%&:/~+#-]*[\w@?^=%&/~+#-]))' | |
| ) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(twitteR) | |
| library(ROAuth) | |
| ## Twitter authentication | |
| ## Replace strings with your credentials | |
| setup_twitter_oauth("consumer_key", "consumer_secret", | |
| "access_token", "access_secret") | |
| # Fetch tweets from user timeline | |
| tweets <- userTimeline("xlth", n = 3200) |
aloth
/ kmeans_r_tableau.txt
Created
December 22, 2016 09:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SCRIPT_INT(' | |
| kmeans(data.frame(.arg1,.arg2,.arg3),' + STR([Cluster Amount]) + ')$cluster; | |
| ', | |
| SUM([Sales]), SUM([Profit]), SUM([Quantity])) |
aloth
/ corrcoef_python_tableau.txt
Created
November 7, 2016 12:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SCRIPT_REAL(' | |
| import numpy as np | |
| return np.corrcoef(_arg1,_arg2)[0,1] | |
| ', | |
| SUM([Sales]), SUM([Profit])) |
aloth
/ install_sentiment_web.R
Last active
August 14, 2016 14:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| install.packages("Rcpp") | |
| install.packages("http://alexloth.com/utils/sentiment/current/sentiment.zip",repos=NULL) |
NewerOlder