Skip to content

Instantly share code, notes, and snippets.

View qbart's full-sized avatar
🧀

Bartłomiej Wójtowicz qbart

🧀
View GitHub Profile
@jpoehls
jpoehls / gist:2030795
Created March 13, 2012 19:02
Using CTRL+W to close tabs in Visual Studio

In Tools | Options | Keyboard...

  1. Add CTRL+W as a Global shortcut for Window.CloseDocumentWindow
  2. Remove the CTRL+W shortcut for Edit.SelectCurrentWord

The caveat to this is if you are used to using CTRL+W to select the current word. If you do, find another shortcut that works for that.

@Kartones
Kartones / postgres-cheatsheet.md
Last active October 13, 2025 11:53
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@a-r-d
a-r-d / convert-and-split.sh
Last active November 22, 2024 21:02
How to take an annoying APE + CUE file cd rip and convert it into a set of FLAC or MP3 files on ubuntu.
#first install all the things:
sudo apt-get install flac ffmpeg mp3splt libav-tools shntool
# Okay first lets do an MP3:
# input files:
# --> cd.ape
# --> cp.cue
# (there are other options, like bitrate, but this is just the bare bones)
avconv -i cd.ape cd.mp3
@lukas-h
lukas-h / license-badges.md
Last active October 15, 2025 11:10
Markdown License Badges for your Project

Markdown License badges

Collection of License badges for your Project's README file.
This list includes the most common open source and open data licenses.
Easily copy and paste the code under the badges into your Markdown files.

Notes

  • The badges do not fully replace the license informations for your projects, they are only emblems for the README, that the user can see the License at first glance.

Translations: (No guarantee that the translations are up-to-date)

@kekru
kekru / add CA cert on CentOS Debian Ubuntu.md
Last active July 30, 2025 02:13
Add CA cert to local trust store on CentOS, Debian or Ubuntu
  • Open a webpage that uses the CA with Firefox
  • Click the lock-icon in the addressbar -> show information -> show certificate
  • the certificate viewer will open
  • click details and choose the certificate of the certificate-chain, you want to import to CentOS
  • click "Export..." and save it as .crt file
  • Copy the .crt file to /etc/pki/ca-trust/source/anchors on your CentOS machine
  • run update-ca-trust extract
  • test it with wget https://thewebsite.org
@davewongillies
davewongillies / Terraform_functions.md
Last active October 11, 2024 16:44
Terraform Functions

Supported built-in functions

  • abs(float) - Returns the absolute value of a given float. Example: abs(1) returns 1, and abs(-1) would also return 1, whereas abs(-3.14) would return 3.14. See also the signum function.

  • basename(path) - Returns the last element of a path.

  • base64decode(string) - Given a base64-encoded string, decodes it and returns the original string.

@shortjared
shortjared / list.txt
Last active October 10, 2025 15:10
List of AWS Service Principals
a4b.amazonaws.com
access-analyzer.amazonaws.com
account.amazonaws.com
acm-pca.amazonaws.com
acm.amazonaws.com
airflow-env.amazonaws.com
airflow.amazonaws.com
alexa-appkit.amazon.com
alexa-connectedhome.amazon.com
amazonmq.amazonaws.com

Ubuntu 18.04 LTS

Packages

apt install libcurl4-openssl-dev gdebi-core wget build-essential wget curl libssl-dev git-core nmap openssl libnss3-dev libxml2 libxml2-dev libxslt1-dev zlib1g zlib1g-dev libssl-dev libreadline7 libreadline-dev libreadline6-dev libncurses5 libncurses5-dev cpu-checker vim htop imagemagick libmagick++6 libmagick++-dev libmagickcore-dev libmagickwand-dev ca-certificates apt-transport-https software-properties-common tmux libpq-dev inotify-tools silversearcher-ag
apt install postgresql-client docker.io
@jun06t
jun06t / vault-golang-login
Created July 13, 2018 15:56
Golang Vault Login Sample
package main
import (
"encoding/json"
"fmt"
"net/http"
"time"
"github.com/hashicorp/vault/api"
"github.com/hashicorp/vault/builtin/credential/aws"