Skip to content

Instantly share code, notes, and snippets.

View DrkSephy's full-sized avatar
🕶️

David Leonard DrkSephy

🕶️
741 followers · 12 following
View GitHub Profile
@neilpw
neilpw / pg-locks-queries.sql
Created April 16, 2020 20:26
PG open locks and queries
SELECT
pg_locks.locktype,
pg_locks.mode,
pg_locks.granted,
pg_locks.pid,
pg_class.relname,
now() - pg_stat_activity.query_start "query_age",
now() - pg_stat_activity.xact_start "xact_age",
pg_stat_activity.query
FROM
@tsiege
tsiege / The Technical Interview Cheat Sheet.md
Last active June 28, 2024 10:38
This is my technical interview cheat sheet. Feel free to fork it or do whatever you want with it. PLEASE let me know if there are any errors or if anything crucial is missing. I will add more links soon.

ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!






\

@dergachev
dergachev / GIF-Screencast-OSX.md
Last active June 5, 2024 22:16
OS X Screencast to animated GIF

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Screencapture GIF

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application: