Skip to content

Instantly share code, notes, and snippets.

View taiar's full-sized avatar

André Taiar taiar

69 followers · 73 following
  • paag 🖤
View GitHub Profile
@taiar
taiar / custom-commands.sublime-commands
Created October 6, 2024 16:21
csv to where sublime plugin
[
{"caption": "CSV to Where", "command": "format_as_where"}
]
@taiar
taiar / README.md
Created April 10, 2024 01:33 — forked from arikfr/README.md
Redash Query Export Tool

Setup

$ pip install click requests

Usage

$ python query_export.py --redash-url "https://app.redash.io/" --api-key ""
@taiar
taiar / connect_private_rds.py
Created October 29, 2023 20:39 — forked from jshahriddhi/connect_private_rds.py
Connecting to a private AWS RDS instance in python
from sshtunnel import SSHTunnelForwarder
import pymysql
with SSHTunnelForwarder(
('ec2-52-202-194-76.public-ec2-instance.amazonaws.com'),
ssh_username="ec2-user",
ssh_pkey="~/ssh-tunnel-rds.pem",
remote_bind_address=('private-rds-instance.ckfkidfytpr4.us-east-1.rds.amazonaws.com', 3306)
) as tunnel:
print("****SSH Tunnel Established****")
@taiar
taiar / x.sh
Created October 20, 2023 22:48
Create and push a docker multi arch image
docker buildx create --use --platform=linux/arm64,linux/amd64 --name multi-platform-builder
docker buildx inspect --bootstrap
docker buildx build --platform=linux/arm64,linux/amd64 --push --tag project-name:latest -f ./project-name/Dockerfile .
@taiar
taiar / iTrem2-ssh.zsh
Created October 20, 2023 16:52 — forked from erangaeb/iTrem2-ssh.zsh
colorize ssh
# tabc <profile name> do the profile change
function tabc() {
NAME=$1; if [ -z "$NAME" ]; then NAME="Default"; fi
# if you have trouble with this, change
# "Default" to the name of your default theme
echo -e "\033]50;SetProfile=$NAME\a"
}
# reset the terminal profile to Default when exit from the ssh session
function tab-reset() {
@taiar
taiar / claner.sh
Created September 18, 2022 16:20
Subtitle cleaner
#!/usr/bin/bash
langs=( "ar" "es" "de" "fr" "it" "ja" "ru" "vi" "vi" "zh-CN" )
for session in *
do
if [ -d $session ]; then
echo $session
for resource in $session/*
do
@taiar
taiar / README.md
Created March 17, 2022 01:23 — forked from arikfr/README.md
Setting up HTTPS with LetsEncrypt for Redash Docker Deployment
  1. Make sure the domain you picked points at the IP of your Redash server.
  2. Switch to the root user (sudo su).
  3. Create a folder named nginx in /opt/redash.
  4. Create in the nginx folder two additional folders: certs and certs-data.
  5. Create the file /opt/redash/nginx/nginx.conf and place the following in it: (replace example.redashapp.com with your domain name) 
    upstream redash {
    server redash:5000;
}
@taiar
taiar / serbilian.rb
Created February 25, 2022 13:56 — forked from brunoro/serbilian.rb
Serbilian cyrilic: a cyrilic script for Brazilian Portuguese based in Serbian Cyrilic
#!/usr/bin/ruby
require 'logger'
require 'pragmatic_tokenizer'
require 'unicode_utils'
class Serbilian
SINGLE_LETTER_WORDS = {
"à" => "a",
"ã" => "ɐ̃",
"â" => "ɐ̃",
@taiar
taiar / readonly_user.sql
Created February 2, 2022 23:34
Create a read only user on psql
CREATE ROLE _readonly_user_name_ WITH LOGIN PASSWORD '_readonly_user_password_'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL 'infinity';
GRANT CONNECT ON DATABASE _database_to_give_access_ TO _readonly_user_name_;
GRANT USAGE ON SCHEMA public TO _readonly_user_name_;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO _readonly_user_name_;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO _readonly_user_name_;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO _readonly_user_name_;
@taiar
taiar / random_color.zsh
Created January 3, 2022 16:18
ZSH Random color name
#!/usr/bin/env zsh
declare -a colors
colors=(
"red"
"purple"
"yellow"
"blue"
"cyan"