Skip to content

Instantly share code, notes, and snippets.

View NewGraphEnvironment's full-sized avatar

Allan Irvine NewGraphEnvironment

View GitHub Profile
@Kartones
Kartones / postgres-cheatsheet.md
Last active July 8, 2024 04:27
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)
@kjantzer
kjantzer / commit-msgs-since-last-tag.sh
Created September 2, 2014 15:24
Get a compiled list of commit messages since the latest tag. Make sure to change the `GIT_ROOT` variable.
#!/bin/bash
GIT_ROOT='/Users/{username}/Sites/my-git-repo/'
cd $GIT_ROOT
LAST_TAG=$(git describe --tags `git rev-list --tags --max-count=1`)
echo $LAST_TAG
@kauffmanes
kauffmanes / install_anaconda.md
Last active July 7, 2024 12:29
Install Anaconda on Windows Subsystem for Linux (WSL)

Thanks everyone for commenting/contributing! I made this in college for a class and I no longer really use the technology. I encourage you all to help each other, but I probably won't be answering questions anymore.

This article is also on my blog: https://emilykauffman.com/blog/install-anaconda-on-wsl

Note: $ denotes the start of a command. Don't actually type this.

Steps to Install Anaconda on Windows Ubuntu Terminal

  1. Install WSL (Ubuntu for Windows - can be found in Windows Store). I recommend the latest version (I'm using 18.04) because there are some bugs they worked out during 14/16 (microsoft/WSL#785)
  2. Go to https://repo.continuum.io/archive to find the list of Anaconda releases
  3. Select the release you want. I have a 64-bit computer, so I chose the latest release ending in x86_64.sh. If I had a 32-bit computer, I'd select the x86.sh version. If you accidentally try to install the wrong one, you'll get a warning in the terminal. I chose `Anaconda3-5.2.0-Li