This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.
To capture the video (filesize: 19MB), using the free "QuickTime Player" application:
tsiege
/ The Technical Interview Cheat Sheet.md
Last active
July 14, 2024 15:27
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.
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!
\
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |