Skip to content

Instantly share code, notes, and snippets.

View jasperkuperus's full-sized avatar
💭
😎

Jasper Kuperus jasperkuperus

💭
😎
View GitHub Profile
@robertpainsi
robertpainsi / README.md
Last active March 21, 2024 10:45
How to reopen a pull-request after a force-push?

How to reopen a pull-request after a force-push?

Precodinitions

  • You need the rights to reopen pull requests on the repository.
  • The pull request hasn't been merged, just closed.

Instructions

  1. Write down the current commit hash of your PR-branch git log --oneline -1 <PR-BRANCH>
  2. Write down the latest commit hash on github before the PR has been closed.
  3. git push -f origin :
@cibernox
cibernox / gist:6061265
Created July 23, 2013 09:52
Install git subtree in mac
# This steps is for git 1.8.X in mac, installed bien binary package http://git-scm.com/download/mac
# Clone git source
git clone git@github.com:git/git.git
# Make & install
cd git/contrib/subtree
make
sudo make prefix=/usr/local/git install
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active March 27, 2024 19:48
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'