Skip to content

Instantly share code, notes, and snippets.

@Kartones
Kartones / postgres-cheatsheet.md
Last active January 21, 2025 14:29
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)
@gomaglev
gomaglev / elasticsearch.md
Last active January 21, 2025 14:28
Elasticsearch Best Practice

Elasticsearch

Templates

Elasticsearch is index based storage. Many things need to be considered when creating indices such as properties, data types, number of shards, number of replicas, refresh interval. Elasticsearch doesn't have schemas. All these things can be set when creating the index or use a template to handle it. After template defined, all the indices that match "index_patterns" will apply all the properties in the template. By using templates, it becomes easier to change index settings, mappings and aliases.

@ksnnacar
ksnnacar / LeanLocalizedTextMeshPro.cs
Last active January 21, 2025 14:27
Lean Localization Text Mesh Pro
/*
This file is my contribution to use the Lean Localization asset with TextMeshProUGUI,
I'm not the owner of the main asset, All copyrights are their respective owners.
Please check the original license of the package if you have any questions regarding that.
You can get the asset free on the assetstore:
http://www.assetstore.unity3d.com/#!/content/28504
22.11.2017 K.S.A
github.com/ksnnacar
*/
@anthonycaccese
anthonycaccese / es-history.md
Last active January 21, 2025 14:26
EmulationStation History

EmulationStation is a graphical and themeable emulator front-end created by Aloshi around 2012. Their original work has been the foundation for the UX of many of our favorite gaming focused projects over the last decade and this document aims to capture a small bit of that history. If you see any errors please let me know in the comments below and I will gladly update this document.

History:

es-history

References:

@joulgs
joulgs / terminal.txt
Last active January 21, 2025 14:26
How install libssl1.1 on ubuntu 22.04
wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.0g-2ubuntu4_amd64.deb
sudo dpkg -i libssl1.1_1.1.0g-2ubuntu4_amd64.deb
@brianjbayer
brianjbayer / gist-unlocking-the-secrets-of-rails-secrets-and-credentials.md
Last active January 21, 2025 14:25
A comprehensive examination of Rails Secrets, Credentials, and Secret Key Base

Unlocking the Secrets of Rails Secrets and Credentials

Interurban Tunnel at Blackhand Gorge- Brian J Bayer


If you are like many (most?) of us, you have encountered Rails Credentials/Secrets and secret_key_base and may have been left a bit (or more) confused.

This post is an attempt to remove some of that confusion by

@rvrsh3ll
rvrsh3ll / windows-keys.md
Created February 18, 2024 22:44
Windows Product Keys

NOTE

These are NOT product / license keys that are valid for Windows activation.
These keys only select the edition of Windows to install during setup, but they do not activate or license the installation.

Index

@frozenpandaman
frozenpandaman / widevine-decryption.md
Created December 26, 2023 14:47
download videos protected with widevine DRM
@frakman1
frakman1 / sources.list
Created August 20, 2021 02:08
Contents of /etc/apt/sources.list for Ubuntu 12.04 Precise Pangolin
# deb cdrom:[Ubuntu 12.04 LTS _Precise Pangolin_ - Release amd64 (20120425)]/ dists/precise/main/binary-i386/
# deb cdrom:[Ubuntu 12.04 LTS _Precise Pangolin_ - Release amd64 (20120425)]/ dists/precise/restricted/binary-i386/
# deb cdrom:[Ubuntu 12.04 LTS _Precise Pangolin_ - Release amd64 (20120425)]/ precise main restricted
# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://old-releases.ubuntu.com/ubuntu precise main restricted
deb-src http://old-releases.ubuntu.com/ubuntu precise main restricted
@cjonesy
cjonesy / macbook_pro_ubuntu_install.md
Last active January 21, 2025 14:20
Installing Ubuntu on MacBook Pro

Macbook Pro - Ubuntu Install

Requirements

2 USB drives > 2GB

Pre-Install

Create bootable USB drive

  1. Grab the latest Ubuntu Desktop iso image